Static analysis of partial referential integrity for better quality SQL data

19th Americas Conference on Information Systems, AMCIS 2013 - Hyperconnected World: Anything, Anywhere, Anytime

Volumn 4, Issue , 2013, Pages 3076-3085

  Link, Sebastian ^a   Memari, Mozhgan ^a  

^a UNIVERSITY OF AUCKLAND   (New Zealand)

Author keywords

Data quality; Efficiency; Index; Partial referential integrity; Performance analysis; SQL standard

Indexed keywords

CLEANING; DATABASE SYSTEMS; ECONOMIC AND SOCIAL EFFECTS; EFFICIENCY; INFORMATION SYSTEMS; INFORMATION USE; SEMANTICS;

COMMERCIAL DATABASE SYSTEM; DATA QUALITY; DATABASE RELATIONS; INDEX; INDEXING STRUCTURES; PARTIAL INFORMATION; PERFORMANCE ANALYSIS; REFERENTIAL INTEGRITY;

QUALITY CONTROL;

EID: 84893320347     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (15)

1. Australian Medicare. (2012) http://www.humanservices.gov.au/customer/services/medicare/medicare/, November 2012.
2. Bravo, L., and Bertossi, L. (2006) Semantically correct query answers in the presence of null values, Current Trends in Database Technology, 336-357.
3. Codd, E. F. (1970) A relational model of data for large shared data banks, Communications of the ACM, 13, 6, 377-387.
4. Eckerson, W. (2002) Data quality and the bottom line: Achieving business success through a commitment to high quality data, The Data Warehousing Institute, 1-36.
5. Fan, W. and Geerts, F. (2012) Foundations of Data Quality Management, Synthesis Lectures on Data Management, 4, 5, 1-217.
6. Field, A. (2009) Discovering statistics using SPSS, Sage Publications Limited.
7. Grefen, P. and Apers, P. (1993) Integrity control in relational database systems: an overview, Data and Knowledge Engineering, 10, 2, 187-223.
8. Hartmann, S., Leck, U., and Link, S. (2011) On Codd families of keys over incomplete relations, The Computer Journal, 54, 7, 1166-1180.
9. Hartmann, S. and Link, S. (2012) The implication problem of data dependencies over SQL table definitions: Axiomatic, algorithmic and logical characterizations, ACM Transactions on Database Systems, 37, 2, 131-1352.
10. Härder, T., and Reinert, J. (1996) Access path support for referential integrity in SQL2, The VLDB Journal, 5, 3, 196-214.
11. Müller, H. and Freytag, J. C. (2003) Problems, methods, and challenges in comprehensive data cleansing, Technical Report HUB-IB-164, Humboldt-Universität zu Berlin, Berlin, Germany.
12. Ordonez, C., and García-García, J. (2008) Referential integrity quality metrics, Decision Support Systems, 44, 2, 495-508.
13. Tseng, F. S., Chen, A. L., and Yang, W. P. (1993) Refining imprecise data by integrity constraints, Data and Knowledge Engineering, 11, 3, 299-316.
14. Türker, C., and Gertz, M. (2001) Semantic integrity support in SQL: 1999 and commercial (object-) relational database management systems, The VLDB Journal, 10, 4, 241-269.
15. Zhang, H., Kuan Tan, H., Zhang, L., Lin, X., Wang, X., Zhang, C., and Mei, H. (2011) Checking enforcement of integrity constraints in database applications based on code patterns, Journal of Systems and Software, 84, 12, 2253-2264.