Skip to main content
SpringerLink
Log in
Book cover

International Conference on Conceptual Modeling

ER 2007: Conceptual Modeling - ER 2007 pp 56–71Cite as

A Model Driven Modernization Approach for Automatically Deriving Multidimensional Models in Data Warehouses

  • Conference paper

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 4801))

Abstract

Data warehouses integrate several operational sources to provide a multidimensional (MD) analysis of data. Therefore, the development of a data warehouse claims for an in-depth analysis of these data sources. Several approaches have been presented to obtain multidimensional structures from data sources in order to guide this development. However, these approaches assume that a wide documentation of the data sources is available and only provide informal guidelines to support the discovery of MD elements. Therefore, this task may become highly difficult for complex and large data sources (e.g. legacy systems). To overcome these problems, we consider the development of the data warehouse as a modernization scenario that addresses the analysis of the available data sources, thus discovering MD structures to either derive a data-driven conceptual MD model or reconcile a requirement-driven conceptual MD model with data sources. Specifically, we use concepts from Architecture Driven Modernization (ADM) in order to automatically perform the following tasks: (i) obtain a logical representation of data sources (ii) mark this logical representation with MD concepts, and (iii) derive a conceptual MD model from the marked model. Finally, we have provided a case study based on a real world project in order to exemplify the application of our approach.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Inmon, W.: Building the Data Warehouse. Wiley & Sons, Chichester (2002)

    Google Scholar 

  2. Kimball, R., Ross, M.: The Data Warehouse Toolkit. Wiley & Sons, Chichester (2002)

    Google Scholar 

  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)

    Article  Google Scholar 

  4. Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual data warehouse modeling. In: 2nd Int. Workshop on Design and Management of Data Warehouses, DMDW 2000

    Google Scholar 

  5. Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. 8th Int. Workshop on Data Warehousing and OLAP, DOLAP, 47–56 (2005)

    Google Scholar 

  6. Mazón, J.N., Trujillo, J., Lechtenbörger, J.: A set of QVT relations to assure the correctness of data warehouses by using multidimensional normal forms. In: Embley, D.W., Olivé, A., Ram, S. (eds.) ER 2006. LNCS, vol. 4215, pp. 385–398. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  7. Mazón, J.N., Trujillo, J., Lechtenbörger, J.: Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data & Knowledge Engineering (doi:10.1016/ j.datak.2007.04.004)

    Google Scholar 

  8. Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: 9th Int. Workshop on Data Warehousing and OLAP, DOLAP, pp. 3–10 (2006)

    Google Scholar 

  9. Seacord, R., Plakosh, D., Lewis, G.: Modernizing Legacy Systems: Software Technologies, Engineering Processes and Business Practices. Addison-Wesley, London, UK (2003)

    Google Scholar 

  10. Olivé, A.: Conceptual schema-centric development: A grand challenge for information systems research. In: Pastor, Ó., Falcão e Cunha, J. (eds.) CAiSE 2005. LNCS, vol. 3520, pp. 1–15. Springer, Heidelberg (2005)

    Chapter  Google Scholar 

  11. OMG.: MDA Guide, 1.0.1., http://www.omg.org/cgi-bin/doc?omg/03-06-01

  12. OMG: Architecture Driven Modernization (ADM) http://adm.omg.org/

  13. Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M.: Applying MDA to the development of data warehouses. In: 8th Int. Workshop on Data Warehousing and OLAP, DOLAP, pp. 57–66 (2005)

    Google Scholar 

  14. Mazón, J.N., Pardillo, J., Trujillo, J.: Applying transformations to model driven data warehouses. In: DaWaK 2006. LNCS, vol. 4081, pp. 13–22. Springer, Heidelberg (2006)

    Google Scholar 

  15. Mazón, J.N., Trujillo, J.: An MDA approach for the development of data warehouses. Decision Support Systems (doi:10.1016 /j.dss.2006.12.003)

    Google Scholar 

  16. Böhnlein, M., vom Ende, A.U.: Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems. In: 2nd Int. Workshop on Data Warehousing and OLAP, DOLAP, pp. 15–21 (1999)

    Google Scholar 

  17. Moody, D.L., Kortink, M.A.R.: From enterprise models to dimensional models: a methodology for data warehouse and data mart design. In: 2nd Int. Workshop on Design and Management of Data Warehouses, DMDW (2000)

    Google Scholar 

  18. Phipps, C., Davis, K.C.: Automating data warehouse conceptual schema design and evaluation. In: 4th Int. Workshop on Design and Management of Data Warehouses, DMDW 2000, pp. 23–32 (2000)

    Google Scholar 

  19. Alhajj, R.: Extracting the extended entity-relationship model from a legacy relational database. Inf. Syst. 28(6), 597–618 (2003)

    Article  MATH  Google Scholar 

  20. Jensen, M.R., Holmgren, T., Pedersen, T.B.: Discovering multidimensional structure in relational data. In: Kambayashi, Y., Mohania, M.K., Wöß, W. (eds.) DaWaK 2004. LNCS, vol. 3181, pp. 138–148. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  21. van den Heuvel, W.J.: Matching and adaptation: Core techniques for MDA-(ADM)-driven integration of new business applications with wrapped legacy systems. Workshop on Model-Driven Evolution of Legacy Systems  (2004)

    Google Scholar 

  22. OMG: MOF 2.0 Query/View/Transformation, http://www.omg.org/cgi-bin/doc?ptc/2005,-11-01

  23. OMG: Common Warehouse Metamodel Specification 1.1, http://www.omg.org/cgi-bin/doc?formal/03-03-02

  24. Soutou, C.: Relational database reverse engineering: Algorithms to extract cardinality constraints. Data Knowl. Eng. 28(2), 161–207 (1998)

    Article  MATH  Google Scholar 

  25. OMG: Unified Modeling Language Specification 2.0, http://www.omg.org/cgi-bin/doc?formal/05-07-04

  26. Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59(3), 725–769 (2006)

    Article  Google Scholar 

  27. Hick, J.M., Hainaut, J.L.: Strategy for database application evolution: The DB-MAIN approach. In: Song, I.-Y., Liddle, S.W., Ling, T.-W., Scheuermann, P. (eds.) ER 2003. LNCS, vol. 2813, pp. 291–306. Springer, Heidelberg (2003)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept. of Software and Computing Systems, University of Alicante, Spain

    Jose-Norberto Mazón & Juan Trujillo

Authors
  1. Jose-Norberto Mazón
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Juan Trujillo
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Christine Parent Klaus-Dieter Schewe Veda C. Storey Bernhard Thalheim

Rights and permissions

Reprints and permissions

Copyright information

© 2007 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Mazón, JN., Trujillo, J. (2007). A Model Driven Modernization Approach for Automatically Deriving Multidimensional Models in Data Warehouses. In: Parent, C., Schewe, KD., Storey, V.C., Thalheim, B. (eds) Conceptual Modeling - ER 2007. ER 2007. Lecture Notes in Computer Science, vol 4801. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-75563-0_6

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-75563-0_6

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-75562-3

  • Online ISBN: 978-3-540-75563-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation