Advertisement

A Data Warehouse Engineering Process

  • Sergio Luján-Mora
  • Juan Trujillo
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3261)

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.

Keywords

data warehouse UML Unified Process software engineering 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Inmon, W.: Building the Data Warehouse. QED Press/John Wiley (1992); (Last edition: 3rd edition, John Wiley & Sons, 2002)Google Scholar
  2. 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. 3.
    Jacobson, I., Booch, G., Rumbaugh, J.: The Unified Software Development Process. In: Object Technology Series, Addison-Wesley, Reading (1999)Google Scholar
  4. 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. 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)CrossRefGoogle Scholar
  6. 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. 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. 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. 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)CrossRefGoogle Scholar
  10. 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. 11.
    Giovinazzo, W.: Object-Oriented Data Warehouse Design. In: Building a star schema, Prentice-Hall, New Jersey (2000)Google Scholar
  12. 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. 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. 14.
    Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The data warehouse lifecycle toolkit. John Wiley & Sons, Chichester (1998)Google Scholar
  15. 15.
    Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of Data Warehouses, 2nd edn. Springer, Heidelberg (2003)Google Scholar
  16. 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. 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)CrossRefGoogle Scholar
  18. 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)CrossRefGoogle Scholar
  19. 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. 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. 21.
    Arlow, J., Neustadt, I.: UML and the Unified Process. In: Object Technology Series, Addison-Wesley, Reading (2002)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Sergio Luján-Mora
    • 1
  • Juan Trujillo
    • 1
  1. 1.D. of Software and Computing SystemsUniversity of AlicanteAlicanteSpain

Personalised recommendations