Skip to main content
SpringerLink
Log in

Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts

  • Conference paper
Book cover Conceptual Modeling - ER 2008 (ER 2008)

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

Included in the following conference series:

Abstract

A corporate data warehouse is a repository that provides decision makers with a large amount of historical data concerning the overall enterprise strategy. In order to customize the data warehouse, many organizations develop concrete data marts focused on a particular department or business process. However, their integrated development is still an open problem for many organizations due to the technical and organizational challenges involved during the design of these repositories as a complete solution. Therefore, we present here a design approach in order to build both the corporate data warehouse and data marts from user’s requirements in an integrated way. Our approach consists on linking information requirements to specific data marts elicited by using the goal-oriented requirement engineering, which are automatically translated into the implementation of the corresponding data repositories by means of model-driven engineering techniques. Its great advantage is that user’s requirements are captured since the very-early development stages of a data-warehousing project in order to automatically translate them into the entire data-warehousing platform.

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

Access this chapter

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 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Watson, H.J., Annino, D.A., Wixom, B.H., Avery, K.L., Rutherford, M.: Current Practices in Data Warehousing. Inf. Syst. Manage. 18(1), 1–9 (2001)

    Article  Google Scholar 

  2. Jukic, N.: Modeling Strategies and Alternatives for Data Warehousing Projects. Commun. ACM 49(4), 83–88 (2006)

    Article  Google Scholar 

  3. Cabibbo, L., Torlone, R.: An Architecture for Data Warehousing Supporting Data Independence and Interoperability. Int. J. Cooperative Inf. Syst. 10(3), 377–397 (2001)

    Article  Google Scholar 

  4. Jarke, M., Jeusfeld, M.A., Quix, C., Vassiliadis, P.: Architecture and Quality in Data Warehouses: An Extended Repository Approach. Inf. Syst. 24(3), 229–253 (1999)

    Article  Google Scholar 

  5. Samos, J., Saltor, F., Sistac, J., Bardés, A.: Database Architecture for Data Warehousing: An Evolutionary Approach. In: Quirchmayr, G., Bench-Capon, T.J.M., Schweighofer, E. (eds.) DEXA 1998. LNCS, vol. 1460, pp. 746–756. Springer, Heidelberg (1998)

    Chapter  Google Scholar 

  6. Luján-Mora, S., Trujillo, J.: Applying the UML and the Unified Process to the design of Data Warehouses. J. Comput. Inform. Syst. 17(2), 12–42 (2006)

    Google Scholar 

  7. Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. In: DOLAP, pp. 47–56 (2005)

    Google Scholar 

  8. Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., Paraboschi, S.: Designing Data Marts for Data Warehouses. ACM Trans. Softw. Eng. Methodol. 10(4), 452–483 (2001)

    Article  Google Scholar 

  9. Mazón, J.N., Pardillo, J., Trujillo, J.: A Model-Driven Goal-Oriented Requirement Engineering Approach for Data Warehouses. In: ER Workshops, pp. 255–264 (2007)

    Google Scholar 

  10. Sen, A., Sinha, A.P.: A Comparison of Data Warehousing Methodologies. Commun. ACM 48(3), 79–84 (2005)

    Article  Google Scholar 

  11. Breslin, M.: Data Warehousing Battle of the Giants: Comparing the Basics of the Kimball and Inmon Models. Bus. Intel. J. 9(1), 6–20 (2004)

    Google Scholar 

  12. Inmon, W.H.: Building the Data Warehouse. Wiley, Chichester (2005)

    Google Scholar 

  13. Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley, Chichester (2002)

    Google Scholar 

  14. Chaudhuri, S., Dayal, U.: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 26(1), 65–74 (1997)

    Article  Google Scholar 

  15. Mazón, J.N., Pardillo, J., Trujillo, J.: Applying Transformations to Model Driven Data Warehouses. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2006. LNCS, vol. 4081, pp. 13–22. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  16. Mazón, J.N., Trujillo, J.: An MDA approach for the development of data warehouses. Dec. Support Syst. (in press, 2007)

    Google Scholar 

  17. 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 

  18. 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 

  19. Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual data warehouse modeling. In: DMDW, p. 6 (2000)

    Google Scholar 

  20. Abelló, A., Samos, J., Saltor, F.: YAM2: a multidimensional conceptual model extending UML. Inf. Syst. 31(6), 541–567 (2006)

    Article  Google Scholar 

  21. Yu, E.S.K., Mylopoulos, J.: Understanding “Why” in Software Process Modelling, Analysis, and Design. In: ICSE, pp. 159–168 (1994)

    Google Scholar 

  22. Bézivin, J.: Model Driven Engineering: An Emerging Technical Space. In: GTTSE, pp. 36–64 (2006)

    Google Scholar 

  23. Pardillo, J., Mazón, J.N., Trujillo, J.: Model-driven OLAP Metadata for Data Warehouses. In: BNCOD (in press, 2008)

    Google Scholar 

  24. Object Management Group: Model Driven Architecture (MDA), Unified Modeling Language (UML), Common Warehouse Metamodel (CWM), Query/View/Transformation Language (QVT), MOF Model to Text Transformation Language (Mof2Text) (March 2008), http://www.omg.org

  25. Abelló, A., Samos, J., Saltor, F.: On relationships offering new drill-across possibilities. In: DOLAP, pp. 7–13 (2002)

    Google Scholar 

  26. Kimball, R.: The Soul of the Data Warehouse, Part Two: Drilling Across. Intel. Enterprise Mag. (April 2003)

    Google Scholar 

  27. Cabibbo, L., Torlone, R.: On the Integration of Autonomous Data Marts. In: SSDBM, pp. 223–231 (2004)

    Google Scholar 

  28. Hurtado, C.A., Mendelzon, A.O., Vaisman, A.A.: Updating OLAP Dimensions. In: DOLAP, pp. 60–66 (1999)

    Google Scholar 

  29. Vassiliadis, P.: Gulliver in the land of data warehousing: practical experiences and observations of a researcher. In: DMDW, pp. 12–1 (2000)

    Google Scholar 

  30. Moody, D.L., Kortink, M.A.R.: From enterprise models to dimensional models: a methodology for data warehouse and data mart design. In: DMDW, p. 5 (2000)

    Google Scholar 

  31. Horner, J., Song, I.Y., Chen, P.P.: An analysis of additivity in OLAP systems. In: DOLAP, pp. 83–91 (2004)

    Google Scholar 

  32. Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data Knowl. Eng. 59(2), 348–377 (2006)

    Article  Google Scholar 

  33. Pedersen, T.B.: How Is BI Used in Industry?: Report from a Knowledge Exchange Network. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2004. LNCS, vol. 3181, pp. 179–188. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  34. Jones, M.E., Song, I.Y.: Dimensional modeling: Identification, classification, and evaluation of patterns. Dec. Support Syst (in press, 2007)

    Google Scholar 

  35. Niemi, T., Nummenmaa, J., Thanisch, P.: Constructing OLAP Cubes Based on Queries. In: DOLAP (2001)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Lucentia Research Group, Department of Software and Computing Systems, University of Alicante, Spain

    Jesús Pardillo & Juan Trujillo

Authors
  1. Jesús Pardillo
    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

Editors and Affiliations

  1. Department of Computer Science, City University of Hong Kong, 83 Tat Chee Avenue, Kowloon, Hong Kong, China

    Qing Li

  2. EPFL-IC-IIF-LBD, Station 14 - INJ 236, 1015 Lausanne, Switzerland

    Stefano Spaccapietra

  3. Faculty of Information, University of Toronto, 140 St. George Street, M5S 3G6, Toronto, Ontario, Canada

    Eric Yu

  4. Universitat Politècnica Catalunya, Jordi Girona 1-3, 08034, Barcelona, Spain

    Antoni Olivé

Rights and permissions

Reprints and permissions

Copyright information

© 2008 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Pardillo, J., Trujillo, J. (2008). Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts. In: Li, Q., Spaccapietra, S., Yu, E., Olivé, A. (eds) Conceptual Modeling - ER 2008. ER 2008. Lecture Notes in Computer Science, vol 5231. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-87877-3_31

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-87877-3_31

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-87876-6

  • Online ISBN: 978-3-540-87877-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation