A UML-based data warehouse design method

Decision Support Systems

Volumn 42, Issue 3, 2006, Pages 1449-1473

  Prat, Nicolas ^a   Akoka, Jacky ^b   Comyn Wattiau, Isabelle ^b  

^a ESSEC BUSINESS SCHOOL   (France)

^b CEDRIC CNAM   (France)

Author keywords

Conceptual design; Data warehouse; Decision support; Logical design; On Line Analytical Processing (OLAP); Physical design

Indexed keywords

COMPUTATIONAL METHODS; COMPUTER PROGRAMMING LANGUAGES; DATA REDUCTION; DATA STRUCTURES; DECISION SUPPORT SYSTEMS; LOGIC DESIGN; MATHEMATICAL MODELS;

METAMODELS; MULTIDIMENSIONAL MODELS; OBJECT CONSTRAINT LANGUAGE (OCL); ON LINE ANALYTICAL PROCESSING (OLAP) TOOLS; PHYSICAL DESIGN;

DATA WAREHOUSES;

EID: 33750489758     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.dss.2005.12.001     Document Type: Article

References (39)

1. Abello A., Samos J., and Saltor F. Benefits of an object-oriented multidimensional data model. ECOOP 2000 Symposium on Objects and Databases, Sophia-Antipolis, France (2000 (June))
2. Agrawal R., Gupta A., and Sarawagi S. Modeling multidimensional databases. 13th International Conference on Data Engineering (ICDE '97), Birmingham, UK (1997 (April))
3. Akoka J., Comyn-Wattiau I., and Prat N. Dimension hierarchies design from UML generalizations and aggregations. 20th International Conference on Conceptual Modeling (ER 2001), Yokohama, Japan (2001 (Nov.))
4. Arkhipenkov S., and Golubev D. Oracle Express OLAP (2002), Charles River Media
5. Blaschka M., Sapia C., Höfling G., and Dinter B. Finding your way through multidimensional data models. DEXA Workshop on Data Warehouse Design and OLAP Technology (DWDOT '98), (Vienna, Austria) (1998 (Aug.))
6. Bonifati A., Cattaneo F., Ceri S., Fuggetta A., and Paraboschi S. Designing data marts for data warehouses. ACM Transactions on Software Engineering and Methodology 10 4 (2001 (Oct.)) 452-483
7. Buzydlowski J.W., Song I.-Y., and Hassell L. A framework for object-oriented on-line analytical processing. 1st ACM Workshop on Data warehousing and OLAP (DOLAP '98), (Washington DC, USA) (1998 (Nov.))
8. Cabibbo L., and Torlone R. A logical approach to multidimensional databases. 6th International Workshop on Extending Database Technology (EDBT '98), (Valencia, Spain) (1998, (March))
9. Carneiro L., and Brayner A. X-META: a methodology for data warehouse design with metadata management. 4th International Workshop on Design and Management of Data Warehouses (DMDW 2002), (Toronto, Canada) (2002 (May))
10. Chaudhuri S., and Dayal U. An overview of data warehousing and OLAP technology. SIGMOD Record 26 1 (1997 (March)) 65-74
11. Datta A., and Thomas H. The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses. Decision Support Systems 27 3 (1999 (Dec.)) 289-301
12. Gardner S.R. Building the data warehouse. Communications of the ACM 41 9 (1998 (Sept.)) 52-60
13. Golfarelli M., and Rizzi S. A methodological framework for data warehouse design. 1st ACM Workshop on Data Warehousing and OLAP (DOLAP '98), (Washington DC, USA) (1998 (Nov.))
14. Hüsemann B., Lechtenbörger J., and Vossen G. Conceptual data warehouse design. 2nd International Workshop on Design and Management of Data Warehouses (DMDW 2000) (Stockholm, Sweden) (2000 (June))
15. Jarke M., Lenzerini M., Vassiliou Y., and Vassiliadis P. Fundamentals of Data Warehouses. second ed., (2003), Springer-Verlag
16. Kimball R. The Data Warehouse Toolkit (1996), John Wiley & Sons
17. Klasse Objecten, OCL Checker, version 0.3, (Feb. 2001), http://www.klasse.nl/ocl/ocl-checker.html.
18. Lehner W., Albrecht J., and Wedekind H. Normal forms for multidimensional databases. 10th International Conference on Statistical and Scientific Database Management (SSDBM '98), (Capri, Italy) (1998 (July))
19. Lenz H.-J., and Shoshani A. Summarizability in OLAP and statistical data bases. 9th International Conference on Statistical and Scientific Database Management (SSDBM '97), (Olympia, Washington, USA) (1997 (Aug.))
20. Luján-Mora S., and Trujillo J. A comprehensive method for data warehouse design. 5th International Workshop on Design and Management of Data Warehouses (DMDW 2003), (Berlin, Germany) (2003 (Sept.))
21. Moody D.L., and Kortink M.A.R. From enterprise models to dimensional models: a methodology for data warehouse and data mart design. 2nd International Workshop on Design and Management of Data Warehouses (DMDW 2000), (Stockholm, Sweden) (2000 (June))
22. Nguyen T.B., Tjoa A.M., and Wagner R. An object-oriented multidimensional data model for OLAP. 1st International Conference on Web-Age Information Management (WAIM) (2000)
23. Niemi T., Nummenmaa J., and Thanisch P. Constructing OLAP cubes based on queries. 4th ACM Workshop on Data warehousing and OLAP (DOLAP '01), (Atlanta, USA) (2001 (Nov.))
24. Object Management Group, OMG Modeling and Metadata Specifications, http://www.omg.org/technology/documents/modeling_spec_catalog.htm.
25. Y.-T. Park, An Empirical Investigation of the Effects of Data Warehousing on Decision Performance, Information and Management, in press (available online at www.sciencedirect.com, April 2005).
26. Pedersen T.B., and Jensen C.S. Multidimensional data modeling for complex data. 15th International Conference on Data Engineering (ICDE '99), (Sydney, Australia) (1999 (March))
27. Peralta V., and Ruggia R. Using design guidelines to improve data warehouse logical design. 5th International Workshop on Design and Management of Data Warehouses (DMDW 2003), (Berlin, Germany) (2003 (Sept.))
28. Phipps C., and Davis K.C. Automating data warehouse conceptual schema design and evaluation. 4th International Workshop on Design and Management of Data Warehouses (DMDW 2002), (Toronto, Canada) (2002 (May))
29. èmes Journées Bases de Données Avancées, (Evry, France, Oct. 2002), http://faculty.essec.fr/n.prat/BDA02_Prat_Akoka.pdf.
30. Rafanelli M., and Ricci F. Proposal of a logical model for statistical databases. 2nd International Workshop on Statistical Database Management (SSDBM '83), (Los Altos, California) (1983 (Sept.))
31. Sapia C., Blaschka M., Höfling G., and Dinter B. Extending the E/R Model for the multidimensional paradigm. International Workshop on Data Warehousing and Data Mining (DWDM '98) in conjunction with the 17th Int. Conf. on Conceptual Modeling (ER '98), (Singapore) (1998 (Nov.))
32. Z. Shi, Y. Huang, Q. He, L. Xu, S. Liu, L. Qin, Z. Jia, J. Li, H. Huang, L. Zhao, MSMiner - A Developing Platform for OLAP, Decision Support Systems, in press (available online at www.sciencedirect.com, Dec. 2004).
33. Shim J.P., Warkentin M., Courtney J.F., Power D.J., Sharda R., and Carlsson C. Past, present, and future of decision support technology. Decision Support Systems 33 2 (2002 (June)) 111-126
34. Si-Saïd Cherfi S., and Prat N. Multidimensional schemas quality: assessing and balancing analyzability and simplicity. International Workshop on Conceptual Modeling Quality (IWCMQ '03) in conjunction with the 22nd International Conference on Conceptual Modeling (ER '03), (Chicago, Illinois, USA) (2003 (Oct.))
35. The OLAP Report - Market share analysis, (2005), http://www.olapreport.com/Market.htm.
36. Tryfona N., Busborg F., and Christiansen J.B. starER: a conceptual model for data warehouse design. 2nd ACM Workshop on Data Warehousing and OLAP (DOLAP '99), (Kansas City, USA) (1999 (Nov.))
37. Tsois A., Karayannidis N., and Sellis T. MAC: conceptual data modeling for OLAP. 3rd International Workshop on Design and Management of Data Warehouses (DMDW 2001), (Interlaken, Switzerland) (2001 (June))
38. Vassiliadis P., and Sellis T. A survey of logical models for OLAP databases. SIGMOD Record 28 4 (1999 (Dec.)) 64-69
39. Watson H.J., Fuller C., and Ariyachandra T. Data warehouse governance: best practices at Blue Cross and Blue Shield of North Carolina. Decision Support Systems 38 3 (2004 (Dec.)) 435-450