Using AutoMed metadata in data warehousing environments

ABSTRACT

What kind of metadata can be used for expressing the multiplicity of data models and the data transformation and integration processes in data warehousing environments? How can this metadata be further used for supporting other data warehouse activities? We examine how these questions are addressed by AutoMed, a system for expressing data transformation and integration processes in heterogeneous database environments.

REFERENCES

• 1: Lars Bækgaard, Event-entity-relationship modeling in data warehouse environments, Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP, p.9-14, November 02-06, 1999, Kansas City, Missouri, United States [doi>10.1145/319757.319779]
• 2: Peter Buneman , Sanjeev Khanna , Wang Chiew Tan, Why and Where: A Characterization of Data Provenance, Proceedings of the 8th International Conference on Database Theory, p.316-330, January 04-06, 2001
• 3: Peter Buneman , Leonid Libkin , Dan Suciu , Val Tannen , Limsoon Wong, Comprehension syntax, ACM SIGMOD Record, v.23 n.1, p.87-96, March 1994 [doi>10.1145/181550.181564]
• 4: D. Calvanese, G. Giacomo, M. Lenzerini, D. Nardi, and R. Rosati. A principled approach to data integration and reconciliation in data warehousing. In Proc. DMDW'99, 1999.
• 5: Surajit Chaudhuri , Umeshwar Dayal, An overview of data warehousing and OLAP technology, ACM SIGMOD Record, v.26 n.1, p.65-74, March 1997 [doi>10.1145/248603.248616]
• 6: Yingwei Cui , Jennifer Widom, Lineage Tracing for General Data Warehouse Transformations, Proceedings of the 27th International Conference on Very Large Data Bases, p.471-480, September 11-14, 2001
• 7: Yingwei Cui , Jennifer Widom , Janet L. Wiener, Tracing the lineage of view data in a warehousing environment, ACM Transactions on Database Systems (TODS), v.25 n.2, p.179-227, June 2000 [doi>10.1145/357775.357777]
• 8: H. Fan. Incremental view maintenance and data lineage tracing in heterogeneous database environments. In Proc. BNCOD'02 PhD Summer School, Sheffied, pages 14--21, 2002.
• 9: H. Fan and A. Poulovassilis. Tracing data lineage using schema transformation pathways. In Knowledge Transformation for the Semantic Web, pages 64--79. IOS Press, 2003.
• 10: Matteo Golfarelli , Stefano Rizzi, A methodological framework for data warehouse design, Proceedings of the 1st ACM international workshop on Data warehousing and OLAP, p.3-9, November 02-07, 1998, Washington, D.C., United States [doi>10.1145/294260.294261]
• 11: Holger Hinrichs and Thomas Aden. An {ISO 9001: 2000 compliant quality management system for data integration in data warehouse systems. In Proc. DMDW'01, 2001.
• 12: B. Hsemann, J. Lechtenbürger, and G. Vossen. Conceptual data warehouse modeling. In Proc. DMDW'00, 2000.
• 13: E. Jasper, N. Tong, P. McBrien, and A. Poulovassilis. View generation and optimisation in the AutoMed data integration framework. Technical report, AutoMed Project, 2003.
• 14: Peter McBrien , Alexandra Poulovassilis, A Uniform Approach to Inter-model Transformations, Proceedings of the 11th International Conference on Advanced Information Systems Engineering, p.333-348, June 14-18, 1999
• 15: P. McBrien and A. Poulovassilis. Data integration by Bi-directional schema transfformation rules In Proc. ICDE'03, 2003.
• 16: D. Moody and M. Kortink. From enterprise models to dimensional models: a methodology for data warehouse and data mart design. In Proc. DMDW'00, 2000.
• 17: Erhard Rahm and Hong Hai Do. Data cleaning: Problems and current approaches. IEEE Data Engineering Bulletin, 23(4):3--13, 2000.
• 18: Dimitri Theodoratos, Semantic Integration and Querying of Heterogeneous Data Sources Using a Hypergraph Data Model, Proceedings of the 19th British National Conference on Databases: Advances in Databases, p.166-182, July 17-19, 2002
• 19: Nectaria Tryfona , Frank Busborg , Jens G. Borch Christiansen, starER: a conceptual model for data warehouse design, Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP, p.3-8, November 02-06, 1999, Kansas City, Missouri, United States [doi>10.1145/319757.319776]
• 20: A. Tsois, N. Karayannidis, and T. Sellis. MAC: Conceptual data modeling for OLAP. In Proc. DMDW'01, 2001.
• 21: Panos Vassiliadis , Alkis Simitsis , Spiros Skiadopoulos, Conceptual modeling for ETL processes, Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP, p.14-21, November 08-08, 2002, McLean, Virginia, USA [doi>10.1145/583890.583893]
• 22: Allison Woodruff , Michael Stonebraker, Supporting Fine-grained Data Lineage in a Database Visualization Environment, Proceedings of the Thirteenth International Conference on Data Engineering, p.91-102, April 07-11, 1997

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Data models

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Normal forms; Schema and subschema

General Terms:
Design

Keywords:
data integration, data warehouse, metadata