Handling inconsistencies in data warehouses

Authors:
Mónica Caniupán
Affiliations:
School of Computer Science, Carleton University, Ottawa, Canada
Venue:
EDBT'04 Proceedings of the 2004 international conference on Current Trends in Database Technology
Year:
2004

Citing 15
Cited 2

Foundations of logic programming

Foundations of logic programming
Circumscription

Handbook of logic in artificial intelligence and logic programming (vol. 3)
An overview of data warehousing and OLAP technology

ACM SIGMOD Record
Consistent query answers in inconsistent databases

PODS '99 Proceedings of the eighteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Updating OLAP dimensions

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
A general framework for the view selection problem for data warehouse design and evolution

Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
Selection of Views to Materialize Under a Maintenance Cost Constraint

ICDT '99 Proceedings of the 7th International Conference on Database Theory
Foundations of Aggregation Constraints

PPCP '94 Proceedings of the Second International Workshop on Principles and Practice of Constraint Programming
Expiring Data in a Warehouse

VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Extending Practical Pre-Aggregation in On-Line Analytical Processing

VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Consistency in Data Warehouse Dimensions

IDEAS '02 Proceedings of the 2002 International Symposium on Database Engineering & Applications
Scalar aggregation in inconsistent databases

Theoretical Computer Science - Database theory
Maintaining Data Cubes under Dimension Updates

ICDE '99 Proceedings of the 15th International Conference on Data Engineering
The generalized MDL approach for summarization

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Characterizing and computing semantically correct answers from databases with annotated logic and answer sets

Proceedings of the 2nd international conference on Semantics in databases

Repair-oriented relational schemas for multidimensional databases

Proceedings of the 15th International Conference on Extending Database Technology
A multidimensional data model with subcategories for flexibly capturing summarizability

Proceedings of the 25th International Conference on Scientific and Statistical Database Management

Quantified Score

Hi-index	0.00

Visualization

Abstract

Data warehouses (DWs) can become inconsistent when some dimensional constraints are not satisfied by the dimension instances In this paper, we present preliminary results about the effects of the violation of partitioning constraints in homogeneous dimension instances over aggregation queries, and in particular over the summarizability property (SUMM) of the DWs We are interested in finding ways to retrieve consistent answers even when the DW is inconsistent We give a notion of repair for inconsistent instances based on a notion of prioritized minimization We also describe a notion of consistent answer in DWs.