Generating data quality rules and integration into ETL process

International Conference on Information and Knowledge Management, Proceedings

Volumn , Issue , 2009, Pages 65-72

  Rodić, Jasna ^a   Baranović, Mirta ^b  

^a ORACLE Croatia   (Croatia)

^b UNIVERSITY OF ZAGREB   (Croatia)

Author keywords

Data quality; Generator; Metadata; Oracle; Rules

Indexed keywords

DATA QUALITY; ETL PROCESS; MANUAL INSPECTION; SOURCE SYSTEMS;

DATA REDUCTION; KNOWLEDGE MANAGEMENT; METADATA;

DATA WAREHOUSES;

EID: 74549176561     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1651291.1651303     Document Type: Conference Paper

References (21)

1. T. Dasu and T. Johnson. Exploratory Data Mining and Data Cleaning. John Wiley and Sons, Chichester, 2003.
2. H. Galhardas and D. Florescu and D. Shasha and E. Simon and J. P. Matsumoto and C. A. Saita. AJAX: an Extensible Data Cleaning Tool. http://web.tagus.ist.utl.pt/ helena.galhardas/ajax-desc.html
3. P. Gomes and J. Farinha and M. J. Trigueiros. A Data Quality Metamodel Extension to CWM. In 4th Asia Pacific Conference on Conceptual Modelling Proceedings, pages 17-26. APCCM, February 2007.
4. T. N. Herzog and F. Scheuren and W. E. Winkler. Data Quality and Record Linkage Techniques. Springer, Heidelberg, 2007.
5. Y. Hong and T. Yang and J. Kang and D. Lee. Record Linkage as DNA Sequence Alignment Problem. In Proceedings of the 6th International Workshop on Quality in Databases and Management of Uncertain Data, pages 13-22. QDB/MUD, August 2008.
6. S. K. Kachigan. Multivariate Statistical Analysis: A Conceptual Introduction. Radius Press, New York, 1991.
7. H. Kim and D. Lee. Parallel Linkage. In 16th ACM Int'l Conf. on Information and Knowledge Management, pages 283-292. CIKM, November 2007.
8. R. Kimball and J. Caserta. The Data Warehouse ETL Toolkit. Wiley Publishing Inc., Indianapolis, 2004.
9. F. Korn and S. Muthukrishnan and Y. Zhu. Checks and Balances: Monitoring Data Quality Problems in Network Traffic Database. In 29th International Conference on Very Large Databases Proceedings, pages 536-547. VLDB, September 2003.
10. D. Luebbers and U. Grimmer and M. Jarke. Systematic Development of Data Mining - Based Data Quality Tools. In 29th International Conference on Very Large Databases Proceedings, pages 548-559. VLDB, September 2003.
11. A. Maydanchik. Data Quality Assessment. Technics Publications, Denville, 2007.
12. T. Morgan. Business Rules and Information Systems: Aligning IT with Business Goals. Addison-Wesley, Reading, Massachusetts, 2002.
13. J. E. Olson. Data Quality: The Accuracy Dimension. Morgan Kaufmann, San Francisco, 2003.
14. B. W. On and N. Koudas and D. Lee and D. Srivastava. Group Linkage. In Proceedings of the 23rd International Conference on Data Engineering pages 496-505. ICDE, April 2007.
15. C. Ordonez and J. García-García. Referential integrity quality metrics. In Decision Support Systems, Volume 44, Issue 2, pages 495-508. Elsevier Science Publishers B. V., Amsterdam, 2008.
16. M. G. Piattini and C. Calero and M. Genero. Information and Database Quality. Kluwer Academic Publishers, Boston / Dordrecht / London, 2002.
17. V. Raman and J. M. Hellerstein. Potter's Wheel: An Interactive Data Cleaning System. In 27th International Conference on Very Large Databases Proceedings, pages 381-390. VLDB, September 2001.
18. J. Rodić. Data Quality Rules Implementation Using Oracle Technology. In 32nd International Convention Mipro Proceedings, pages 216-221. Mipro, May 2009.
19. R. G. Ross. Principles of Business Rule Approach. Addison-Wesley, Reading, Massachusetts, 2003.
20. D. Taniar. Progressive Methods in Data Warehousing and Business Intelligence. Idea Group Inc., Calgary, 2009.
21. J. D. Ullman and J. Widom. A First Course in Database Systems. Prentice Hall, Upper Saddle River, New Jersey, 1997.