A Standard for Representing Multidimensional Properties: The Common Warehouse Metamodel (CWM)
Data warehouses, multidimensional databases, and OLAP tools are based on the multidimensional (MD) modeling. Lately, several approaches have been proposed to easily capture main MD properties at the conceptual level.These conceptual MD models, together with a precise management of metadata, are the core of any related tool imple- mentation. However, the broad diversity of MD models and management of metadata justifies the necessity of a universally understood standard definition for metadata, thereby allowing different tools to share infor- mation in an easy form. In this paper, we make use of the Common Warehouse Metamodel (CWM) to represent the main MD properties at the conceptual level in terms of CWM metadata. Then, CWM-compliant tools could interoperate by exchanging their CWM-based metadata in a commonly understood format and benefit of the expressiveness of the MD model at the conceptual level.
KeywordsConcept al MD modeling CWM DW metadata integration OLAP
Unable to display preview. Download preview PDF.
- 1.A. Abelló, J. Samos, and F. Saltor. Benefits of an Object-Oriented Multidimensional Data Model. In K. Dittrich, G. Guerrini, I. Merlo, M. Oliva, and E. Rodriguez, editors, Proceedings Symposium on Objects and Databases in 14th ECOOP Conference, pages 141–152. Springer LNCS 1944, 2000.Google Scholar
- 2.P.A. Bernstein, T. Bergstraesser, J. Carlson, S. Pal, P. Sanders, and D. Shutt. Microsoft Repository Version 2 and the Open Information Model. Information Systems, 24, 2, 1999.Google Scholar
- 3.W. Giovinazzo. Object-Oriented Data Warehouse Design. Building a star schema. Prentice-Hall, NJ, 2000.Google Scholar
- 4.R. Kimball. The data warehousing toolkit. John Wiley, 2 edition, 1996.Google Scholar
- 9.J. Poole, D. Chang, D. Tolbert, and D. Mellor. CWM: An Introduction to the Standard for Data Warehouse Integration. John Wiley, 2002.Google Scholar
- 10.J. Trujillo, J. Gómez, and M. Palomar. Modeling the Behavior of OLAP Applications Using an UML Compilant Approach. In Proceedings 1st ADVIS Conference, pages 14–23. Springer LNCS 1909, 2000.Google Scholar
- 11.J. Trujillo, M. Palomar, J. Gómez, and Il-Yeol Song. Designing Data Warehouses with OO Concept al Models. IEEE Computer, special issue on Data Warehouses, 34, 12, 66–75, 2001.Google Scholar
- 12.T. Vetterli, A. Vaduva, and M. Staudt. Metadata Standards for Data Wareho sing: Open Information Model vs. Common Warehouse Metamodel. ACM SIGMOD Record, 23, 3, 2000.Google Scholar