• Login
  • Register
  • Search

A Data Warehouse Design Method

Yameng Ban, Zhijuan Wang

Abstract


Data warehouse is an important part of data driven decision support system. The design of data warehouse is a
complex task, which needs systematic method. This paper presents a design method of data warehouse based on UML, which
spans three design stages: concept, logic and physics. Our approach consists of a set of meta models used in each phase, and
a set of transformations that can be semi automated. Following our idea of object-oriented, we use UML to represent all meta
models, and illustrate the formal specification of OMG based transformation of object constraint language.

Keywords


Data Warehouse; Decision Support;Meta Model

Full Text:

PDF

Included Database


References


[1] The OLAP Report – Market share analysis; 2008. http://www. olapreport.com/Market.htm.

[2] Bonifati A, Cattaneo F, Ceri S, et al. Designing data marts for data warehouses. ACM Transactions on Software

Engineering and Methodology 2007; 10 (4): 452-483.

[3] Arkhipenkov S, Golubev D. Oracle express OLAP. Charles River Media; 2006.

[4] Peralta V, Ruggia R. Using design guidelines to improve data warehouse logical design. 5th International Workshop on

Design and Management of Data Warehouses; 2007.

[5] Jarke M, Lenzerini M. Vassiliou Y, et al. Fundamentals of data warehouses, Second ed. Berlin: Springer-Verlag; 2008.

[6] Kimball R. The data warehouse toolkit. JohnWiley&Sons; 1996.

[7] Luján-Mora S, Trujillo J. A comprehensive method for datawarehouse design. 5th International Workshop on Design and

Management of Data Warehouses; 2007.




DOI: http://dx.doi.org/10.18686/ahe.v5i3.3478

Refbacks