Referential integrity quality metrics

Decision Support Systems

Volumn 44, Issue 2, 2008, Pages 495-508

  Ordonez, Carlos ^a   García García, Javier ^b  

^a University of Houston   (United States)

^b UNIVERSIDAD NACIONAL AUTÓNOMA DE MÉXICO   (Mexico)

Author keywords

Database integration; Foreign key; Metric; Referential integrity

Indexed keywords

ERROR ANALYSIS; OPTIMIZATION;

DATABASE INTEGRATION; REFERENTIAL COMPLETENESS; REFERENTIAL INTEGRITY; REFERENTIAL INTEGRITY QUALITY METRICS; SYNTHETIC DATABASES;

RELATIONAL DATABASE SYSTEMS;

EID: 36248935540     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.dss.2007.06.004     Document Type: Article

References (25)

1. Berndt D.J., and Fisher J.W. Understanding dimension volatility in data warehouses. INFORMS CIST Conference (2001)
2. Berndt D.J., Fisher J.W., Studnicki J., and Hevner A.R. Healthcare data warehousing and quality assurance. IEEE Computer 34 12 (2001) 56-65
3. Bohannon P., Fan W., Flaster M., and Rastogi R. A cost-based model and effective heuristic for repairing constraints by value modification. ACM SIGMOD Conference (2005) 143-154
4. Calero C., Piattini M., and Genero M. Empirical validation of referential integrity metrics. Information & Software Technology 43 15 (2001) 949-957
5. Cammarata S.J., Ramachandra P., and Shane D. Extending a relational database with deferred referential integrity checking and intelligent joins. ACM SIGMOD Conference (1989) 88-97
6. Cappiello C., Francalanci C., and Pernici B. Data quality assessment from the users perspective. ACM IQIS (2004) 68-73
7. Chaudhuri S. An overview of query optimization in relational systems. ACM PODS Conference (1998) 84-43
8. Codd E.F. Extending the database relational model to capture more meaning. ACM TODS 4 4 (1979) 397-434
9. Dasu T., Johnson T., Muthukrishnan S., and Shkapenyuk V. Mining database structure; or, how to build a data quality browser. ACM SIGMOD Conference (2002) 240-251
10. Elmasri R., and Navathe S.B. Fundamentals of Database Systems. 3rd edition (2000), Addison/Wesley, Redwood, City, California
11. Fisher J.W., and Berndt D.J. Understanding dimension volatility in data warehouses. INFORMS Conference on Information Systems and Technology (CIST) Conference (2001)
12. Fuxman A., Fazli E., and Miller R.J. Conquer: efficient management of inconsistent databases. ACM SIGMOD Conference (2005) 155-166
13. Gray J., Bosworth A., Layman A., and Pirahesh H. Data cube: a relational aggregation operator generalizing group-by, cross-tab and sub-total. ICDE Conference (1996) 152-159
14. Horowitz B.M. A run-time execution model for referential integrity maintenance. IEEE ICDE Conference (1992) 548-556
15. Johnson T., Marathe A., and Dasu T. Database exploration and Bellman. IEEE Data Engineering Bulletin 26 3 (2003) 34-39
16. Lim E.P., and Chiang R.H. The integration of relationship instances from heterogeneous databases. Decision Support Systems 29-2 3-4 (2000) 153-167
17. Markowitz V.M. Safe referential structures in relational databases. VLDB (1991) 123-132
18. Motro A., and Rakov I. Estimating the quality of data in relational databases. IQ (1996) 94-110
19. Mukhopadhyay D., and Thomas G. Practical approaches to maintaining referential integrity in multidatabase systems. RIDE-IMS (July 1993) 42-49
20. Ordonez C., and García-García J. Consistent aggregations in databases with referential integrity errors. ACM IQIS Workshop (2006)
21. Pipino L., Lee Y.W., and Wang R.Y. Data quality assessment. ACM CACM 45 4 (2002) 211-218
22. Scannapieco M., and Batini C. Completeness in the Relational Model: A Comprehensive Frame-work. IQ Conference (2004)
23. Serrano M., Calero C., Trujillo J., Lujan-Mora S., and Piattini M. Empirical validation of metrics for conceptual models of data warehouses. CAISE (2004) 506-520
24. Türker C., and Gertz M. Semantic integrity support in SQL: 1999 and commercial (object-)relational database management systems. VLDBJ 10 4 (2001) 241-269
25. Wang R.Y., Reddy M.P., and Kon H.B. Toward quality data: an attribute-based approach. Decision Support Systems 13 3-4 (1995) 349-372