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.
- Lars Baekgaard. Event-entity-relationship modeling in data warehouse environments. In Proc. DOLAP'9, pages 9--14, 1999.]] Google ScholarDigital Library
- P. Buneman, S.~Khanna, and W.C. Tan. Why and Where: A characterization of data provenance. In Proc. ICDT'01, LNCS 1973, pages 316--330, 2001.]] Google ScholarDigital Library
- P. Buneman et al. Comprehension syntax. SIGMOD Record, 23(1):87--96, 1994.]] Google ScholarDigital Library
- 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.]]Google Scholar
- Surajit Chaudhuri and Umeshwar Dayal. An overview of data warehousing and {OLAP technology. SIGMOD Record, 26(1):65--74, 1997.]] Google ScholarDigital Library
- Y. Cui and J. Widom. Lineage tracing for general data warehouse transformations. Proc. VLDB'01, pages 471--480, 2001.]] Google ScholarDigital Library
- Y. Cui, J. Widom, and J. L. Wiener. Tracing the lineage of view data in a warehousing environment. ACM Transactions on Database Systems, 25(2):179--227, 2000.]] Google ScholarDigital Library
- 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.]]Google Scholar
- 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.]]Google Scholar
- M. Golfarelli and S. Rizzi. A methodological framework for data warehouse design. In Proc. DOLAP '98, 1998.]] Google ScholarDigital Library
- 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.]]Google Scholar
- B. Hsemann, J. Lechtenbürger, and G. Vossen. Conceptual data warehouse modeling. In Proc. DMDW'00, 2000.]]Google Scholar
- E. Jasper, N. Tong, P. McBrien, and A. Poulovassilis. View generation and optimisation in the AutoMed data integration framework. Technical report, AutoMed Project, 2003.]]Google Scholar
- P. McBrien and A. Poulovassilis. A uniform approach to inter-model transformations. In Proc. CAiSE'99, LNCS 1626, pages 333--348, 1999. In Proc. ICDE'03, 2003.]] Google ScholarDigital Library
- P. McBrien and A. Poulovassilis. Data integration by Bi-directional schema transfformation rules In Proc. ICDE'03, 2003.]]Google Scholar
- 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.]]Google Scholar
- Erhard Rahm and Hong Hai Do. Data cleaning: Problems and current approaches. IEEE Data Engineering Bulletin, 23(4):3--13, 2000.]]Google Scholar
- D. Theodoratos. Semantic integration and querying of heterogeneous data sources using a hypergraph data model. In Proc. BNCOD'02, LNCS 2405, pages 166--182, 2002.]] Google ScholarDigital Library
- N. Tryfona, F. Busborg, and J. Christiansen. starER: A conceptual model for data warehouse design. In Proc. DOLAP '99, pages 3--8, 1999.]] Google ScholarDigital Library
- A. Tsois, N. Karayannidis, and T. Sellis. MAC: Conceptual data modeling for OLAP. In Proc. DMDW'01, 2001.]]Google Scholar
- P. Vassiliadis, A. Simitsis, and S. Skiadopoulos. Conceptual modeling for {ETL processes. In Proc. DOLAP'02, 2002.]] Google ScholarDigital Library
- A. Woodruff and M. Stonebraker. Supporting fine-grained data lineage in a database visualization environment. In ACDE'97, UK, pages 91--102.]] Google ScholarDigital Library
Index Terms
- Using AutoMed metadata in data warehousing environments
Recommendations
Metadata Based Student Data Extraction from Universities Data Warehouse
ICSPS '09: Proceedings of the 2009 International Conference on Signal Processing SystemsAbstract-This paper is intended to introduce the general concept of data warehouse and metadata. A data warehouse system loads data from various operational databases, clean data, transforms the data attribute in a commonly defined attribute description ...
Fuzzy integration of web data sources for data warehousing
EUROCAST'07: Proceedings of the 11th international conference on Computer aided systems theoryIn this paper we show our work related to an approach for monitoring web sources on the World Wide Web using its temporal properties in order to integrate them in a temporal Data Warehouse. We use these temporal properties obtained for integrating data ...
Metadata management: past, present and future
In the past, metadata has always been a second-class citizen in the world of databases and data warehouses. Its main purpose has been to define the data. However, the current emphasis on metadata in the data warehouse and software repository communities ...
Comments