Applying MDA to the development of data warehouses

ABSTRACT

Different modeling approaches have been proposed to overcome every design pitfall of the development of the different parts of a data warehouse (DW) system. However, they are all partial solutions which deal with isolated aspects of the DW and do not provide designers with an integrated and standard method for designing the whole DW (ETL processes, data sources, DW repository and so on). On the other hand, the Model Driven Architecture (MDA) is a standard framework for software development that addresses the complete life cycle of designing, deploying, integrating, and managing applications by using models in software development. In this paper, we describe how to align the whole DW development process to MDA. Then, we define MD2A (MultiDimensional Model Driven Architecture), an approach for applying the MDA framework to one of the stages of the DW development: multidimensional (MD) modeling. First, we describe how to build the different MDA artifacts (i.e. models) by using extensions of the Unified Modeling Language (UML). Secondly, transformations between models are clearly and formally established by using the Query/View/Transformation (QVT) approach. Finally, an example is provided to better show how to apply MDA and its transformations to the MD modeling.

REFERENCES

• 1: Luca Cabibbo , Riccardo Torlone, A Logical Approach to Multidimensional Databases, Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology, p.183-197, March 23-27, 1998
• 2: David Frankel, Model Driven Architecture: Applying MDA to Enterprise Computing, John Wiley & Sons, Inc., New York, NY, 2002
• 3: Golfarelli M., Maio D., Rizzi S. The Dimensional Fact Model: A Conceptual Model for Data Warehouses. Int. J. Cooperative Inf. Syst. 7(2-3): 215-247. 1998.
• 4: William H. Inmon , W. H. Inmon, Building the Data Warehouse,3rd Edition, John Wiley & Sons, Inc., New York, NY, 2002
• 5: Ivar Jacobson , Grady Booch , James Rumbaugh, The unified software development process, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1999
• 6: Matthias Jarke , Y. Vassiliou , P. Vassiliadis , M. Lenzerini, Fundamentals of Data Warehouses, Springer-Verlag New York, Inc., Secaucus, NJ, 1999
• 7: Ralph Kimball , Margy Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, John Wiley & Sons, Inc., New York, NY, 2002
• 8: Anneke G. Kleppe , Jos Warmer , Wim Bast, MDA Explained: The Model Driven Architecture: Practice and Promise, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 2003
• 9: Sergio Luján-Mora , Juan Trujillo , Il-Yeol Song, Multidimensional Modeling with UML Package Diagrams, Proceedings of the 21st International Conference on Conceptual Modeling, p.199-213, October 07-11, 2002
• 10: Sergio Luján-Mora , Juan Trujillo , Il-Yeol Song, Extending the UML for Multidimensional Modeling, Proceedings of the 5th International Conference on The Unified Modeling Language, p.290-304, September 30-October 04, 2002
• 11: Luj&225;n-Mora S., Trujillo J. A Data Warehouse Engineering Process. In Proceedings of the 3rd Biennial International Conference on Advances in Information Systems (ADVIS'04). Lecture Notes in Computer Science, Izmir, Turkey, October 2004. Springer-Verlag.
• 12: Luj&225;n-Mora S., Vassiliadis P., Trujillo J. Data Mapping Diagrams for Data Warehouse Design with UML. In Proceedings of the 23rd International Conference on Conceptual Modeling (ER'04), Lecture Notes in Computer Science, Shanghai, China, November 2004. Springer-Verlag.
• 13: Sergio Luján-Mora , Juan Trujillo, Physical modeling of data warehouses using UML, Proceedings of the 7th ACM international workshop on Data warehousing and OLAP, November 12-13, 2004, Washington, DC, USA [doi>10.1145/1031763.1031772]
• 14: Mazon J-N, Trujillo J., Serrano M., Piattini M. Designing data warehouses: from business requirement analysis to multidimensional modeling. 13th IEEE International Requirements Engineering Conference Workshop on Requirements Engineering for Business Needs and IT Alignment (REBNITA). Paris. August, 2005. http://homepage.mac.com/karlalancox/documents/MazonCRC_000.pdf
• 15: Enrique Medina , Juan Trujillo, A Standard for Representing Multidimensional Properties: The Common Warehouse Metamodel (CWM), Proceedings of the 6th East European Conference on Advances in Databases and Information Systems, p.232-247, September 08-11, 2002
• 16: Stephen J. Mellor , Scott Kendall , Axel Uhl , Dirk Weise, MDA Distilled, Addison Wesley Longman Publishing Co., Inc., Redwood City, CA, 2004
• 17: Object Management Group (OMG). Unified Modeling Language Specification 1.5. http://www.omg.org/cgi-bin/doc?formal/03-03-01
• 18: OMG Common Warehouse Metamodel (CWM) Specification 1.0.1. http://www.omg.org/cgi-bin/doc?formal/03-03-02
• 19: OMG, Object Management Group: Model Driven Architecture (MDA). 2004. http://www.omg.org/cgi-bin/doc?formal/03-06-01
• 20: OMG 2nd Revised Submission: MOF 2.0 Query/Views/Transformations. http://www.omg.org/cgi-bin/doc?ad/05-03-02
• 21: Poole J. Model Driven Data Warehouse (MDDW). www.cwmforum.org/POOLEIntegrate2003.pdf
• 22: Juan Trujillo , Manuel Palomar , Jaime Gomez , Il-Yeol Song, Designing Data Warehouses with OO Conceptual Models, Computer, v.34 n.12, p.66-75, December 2001 [doi>10.1109/2.970579]
• 23: Trujillo J., Luj&225;n-Mora S. A UML based Approach for Modeling ETL Processes in Data Warehouses. In proceedings of the 22nd International Conference on Conceptual Modeling (ER'03), volume 2813 of Lecture Notes in Computer Science, pages 307-320, Chicago, USA, October 2003. Springer-Verlag.
• 24: Nectaria Tryfona , Frank Busborg , Jens G. Borch Christiansen, starER: a conceptual model for data warehouse design, Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP, p.3-8, November 02-06, 1999, Kansas City, Missouri, United States [doi>10.1145/319757.319776]
• 25: Eric S. K. Yu, Towards Modeling and Reasoning Support for Early-Phase Requirements Engineering, Proceedings of the 3rd IEEE International Symposium on Requirements Engineering (RE'97), p.226, January 05-08, 1997

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.7 Database Administration
          Subjects: Data warehouse and repository

Additional Classification:
  D. Software
  D.2 SOFTWARE ENGINEERING
      D.2.0 General
          Subjects: Standards

Keywords:
MDA, QVT, data warehouse, multidimensional modeling