Data Management

Consistent Aggregations in Databases With Referential Integrity Errors

Date Added: Jan 2012
Format: PDF

A data warehouse integrates tables coming from multiple source databases, where each database has different tables, columns with similar content across databases and different referential integrity constraints, enforced to different compliance levels. Some source databases may have more reliable data than others, if referential integrity is more strictly enforced or their respective logical data model is more comprehensive. Thus, a query in an integrated database is likely to refer to tables and columns with referential integrity errors. In this paper, the authors improve aggregations to handle referential integrity errors on OLAP databases.