论文信息 - Using Reference Models for Data Warehouse Metadata Management

Using Reference Models for Data Warehouse Metadata Management

Based on experience from applying the Common Warehouse Metamodel to metadata management at a large Swiss bank, the applicability of metadata reference models in complex application domains is analyzed. In order to explain the context of the case, the state-of-the-art of the Common Warehouse Metamodel and its application for data warehouse management are summarized. Based on the project experience documented in this paper, benefits of the reference model approach are described and recommendations for future developments of the Common Warehouse Metamodel are proposed.

Robert Winter | Alexander Schwinn | Florian Melchert | Clemens Herrmann

[1] Markus Helfert,et al. Proactive data quality management for data warehouse systems , 2002, DMDW.

[2] Florian Melchert. Das Common Warehouse Metamodel als Standard für Metadaten im Data Warehousing , 2003 .

[3] David Mellor,et al. Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration , 2001 .

[4] Model Driven Architecture (mda) Faq , .

[5] Günther Pernul,et al. Towards OLAP security design — survey and research issues , 2000, DOLAP '00.

[6] Panos Vassiliadis,et al. Towards Quality-oriented Data Warehouse Usage and Evolution , 2000, Inf. Syst..

[7] John Matthew Poole. Common Warehouse Metamodel Developer's Guide , 2003 .

[8] Erhard Rahm,et al. On Metadata Interoperability in Data Warehouses , 2000 .

[9] Arnon Rosenthal,et al. View security as the basis for data warehouse security , 2000, DMDW.

[10] Robert J. Muller,et al. Database Design for Smarties: Using UML for Data Modeling , 1999 .

[11] Larry P. English. Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits , 1999 .

[12] Gunnar Auth,et al. Integriertes Metadatenmanagement für das Data Warehousing. Grundlagen, Nutzenpotenziale, Architektur , 2002 .

[13] Michael Jennings,et al. Universal Meta Data Models , 2004 .

[14] Erhard Rahm,et al. Comparison of Schema Matching Evaluations , 2002, Web, Web-Services, and Database Systems.