Skip to main content
SpringerLink
Log in

A Data Warehouse Engineering Process

  • Conference paper
Book cover Advances in Information Systems (ADVIS 2004)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 3261))

Included in the following conference series:

Abstract

Developing a data warehouse (DW) is a complex, time consuming and prone to fail task. Different DW models and methods have been presented during the last few years. However, none of them addresses the whole development process in an integrated manner. In this paper, we present a DW development method, based on the Unified Modeling Language (UML) and the Unified Process (UP), which addresses the design and development of both the DW back-stage and front-end. We extend the UML in order to accurately represent the different parts of a DW. Our proposal provides a seamless method for developing DWs.

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

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. QED Press/John Wiley (1992); (Last edition: 3rd edition, John Wiley & Sons, 2002)

    Google Scholar 

  2. Object Management Group (OMG): Unified Modeling Language Specification 1.5. Internet (2003), http://www.omg.org/cgi-bin/doc?formal/03-03-01

  3. Jacobson, I., Booch, G., Rumbaugh, J.: The Unified Software Development Process. In: Object Technology Series, Addison-Wesley, Reading (1999)

    Google Scholar 

  4. Golfarelli, M., Rizzi, S.: A Methodological Framework for Data Warehouse Design. In: Proc. of the ACM 1st Intl. Workshop on Data Warehousing and OLAP (DOLAP 1998), Bethesda, USA, pp. 3–9 (1998)

    Google Scholar 

  5. Cabibbo, L., Torlone, R.: A Logical Approach to Multidimensional Databases. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 183–197. Springer, Heidelberg (1998)

    Chapter  Google Scholar 

  6. Tryfona, N., Busborg, F., Christiansen, J.: starER: A Conceptual Model for Data Warehouse Design. In: Proc. of the ACM 2nd Intl. Workshop on Data Warehousing and OLAP (DOLAP 1999), Kansas City, USA (1999)

    Google Scholar 

  7. Husemann, B., Lechtenborger, J., Vossen, G.: Conceptual Data Warehouse Design. In: Proc. of the 2nd Intl. Workshop on Design and Management of Data Warehouses (DMDW 2000), Stockholm, Sweden, pp. 3–9 (2000)

    Google Scholar 

  8. Trujillo, J., Palomar, M., Gómez, J., Song, I.: Designing Data Warehouses with OO Conceptual Models. IEEE Computer, special issue on Data Warehouses 34, 66–75 (2001)

    Google Scholar 

  9. Abell, A., Samos, J., Saltor, F.: A Framework for the Classification and Description of Multidimensional Data Models. In: Mayr, H.C., Lazanský, J., Quirchmayr, G., Vogel, P. (eds.) DEXA 2001. LNCS, vol. 2113, pp. 668–677. Springer, Heidelberg (2001)

    Chapter  Google Scholar 

  10. Kimball, R.: The Data Warehouse Toolkit, 2nd edn. John Wiley & Sons, Chichester (1996); (Last edition: 2nd edition, John Wiley & Sons, 2002)

    Google Scholar 

  11. Giovinazzo, W.: Object-Oriented Data Warehouse Design. In: Building a star schema, Prentice-Hall, New Jersey (2000)

    Google Scholar 

  12. Cavero, J., Piattini, M., Marcos, E.: MIDEA: A Multidimensional Data Warehouse Methodology. In: Proc. of the 3rd Intl. Conf. on Enterprise Information Systems (ICEIS 2001), Setubal, Portugal, pp. 138–144 (2001)

    Google Scholar 

  13. Moody, D., Kortink, M.: From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design. In: Proc. of the 3rd Intl. Workshop on Design and Management of Data Warehouses (DMDW 2001), Interlaken, Switzerland, pp. 1–10 (2001)

    Google Scholar 

  14. Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The data warehouse lifecycle toolkit. John Wiley & Sons, Chichester (1998)

    Google Scholar 

  15. Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of Data Warehouses, 2nd edn. Springer, Heidelberg (2003)

    Google Scholar 

  16. Lujn-Mora, S., Trujillo, J., Song, I.: Extending UML for Multidimensional Modeling. In: Jézéquel, J.-M., Hussmann, H., Cook, S. (eds.) UML 2002. LNCS, vol. 2460, pp. 290–304. Springer, Heidelberg (2002)

    Google Scholar 

  17. Lujn-Mora, S., Trujillo, J., Song, I.: Multidimensional Modeling with UML Package Diagrams. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, pp. 199–213. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  18. Trujillo, J., Lujn-Mora, S.: A UML Based Approach for Modeling ETL Processes in Data Warehouses. In: Song, I.-Y., Liddle, S.W., Ling, T.-W., Scheuermann, P. (eds.) ER 2003. LNCS, vol. 2813, pp. 307–320. Springer, Heidelberg (2003)

    Chapter  Google Scholar 

  19. Object Management Group (OMG): Common Warehouse Metamodel (CWM) Specification 1.0. Internet (2001), http://www.omg.org/cgi-bin/doc?ad/2001-02-01

  20. Bruckner, R., List, B., Schiefer, J.: Developing Requirements for Data Warehouse Systems with Use Cases. In: Proc. of the 7th Americas Conf. on Information Systems (AMCIS 2001), Boston, USA, pp. 329–335 (2001)

    Google Scholar 

  21. Arlow, J., Neustadt, I.: UML and the Unified Process. In: Object Technology Series, Addison-Wesley, Reading (2002)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. D. of Software and Computing Systems, University of Alicante, Carretera de San Vicente s/n, Alicante, Spain

    Sergio Luján-Mora & Juan Trujillo

Authors
  1. Sergio Luján-Mora
    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. Dokuz Eylül University, lzmir, Turkey

    Tatyana Yakhno

Rights and permissions

Reprints and permissions

Copyright information

© 2004 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Luján-Mora, S., Trujillo, J. (2004). A Data Warehouse Engineering Process. In: Yakhno, T. (eds) Advances in Information Systems. ADVIS 2004. Lecture Notes in Computer Science, vol 3261. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30198-1_3

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-30198-1_3

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-23478-4

  • Online ISBN: 978-3-540-30198-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation