Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to main content
Springer Nature Link
Log in

Data Warehouse Life Cycle and Design

  • Reference work entry
  • First Online:
Encyclopedia of Database Systems

Synonyms

Data warehouse design methodology

Definition

The term data warehouse life-cycleis used to indicate the phases (and their relationships) a data warehouse system goes through between when it is conceived and when it is no longer available for use. Apart from the type of software, life cycles typically include the following phases: requirement analysis, design (including modeling), construction, testing, deployment, operation, maintenance, and retirement. On the other hand, different life cycles differ in the relevance and priority with which the phases are carried out, which can vary according to the implementation constraints (i.e., economic constraints, time constraints, etc.) and the software specificities and complexity. In particular, the specificities in the data warehouse life-cycle derive from the presence of the operational database that feeds the system and by the extent of this kind of system that must be considered in order to keep the cost and the complexity of...

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

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 6,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 4,319.99
Price excludes VAT (USA)
  • Durable hardcover 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

Recommended Reading

  1. Demarest M. The politics of data warehousing. Retrieved June 2007 from http://www.noumenal.com/marc/dwpoly.html

  2. Giorgini P, Rizzi S, Garzetti M. GRAnD: a goal-oriented approach to requirement analysis in data warehouses. Decis Supp Syst. 2008;45(1):4–21.

    Article  Google Scholar 

  3. Jensen M, Holmgren T, Pedersen T. Discovering multidimensional structure in relational data. In: Proceedings of the 6th International Conference on Data Warehousing and Knowledge Discovery; 2004.

    Chapter  Google Scholar 

  4. Kimbal R, Reeves L, Ross M, Thornthwaite W. The data warehouse lifecycle toolkit. New York: Wiley; 1998.

    Google Scholar 

  5. Jarke M, Lenzerini M, Vassiliou Y, Vassiliadis P. Fundamentals of data warehouses. Springer; 2000.

    Google Scholar 

  6. Golfarelli M, Rizzi S. Data warehouse design: modern principles and methodologies. McGraw-Hill; 2009.

    Google Scholar 

  7. Laender A, Freitas G, Campos M. MD2 – getting users involved in the development of data warehouse applications. In: Proceedings of the 14th International Conference on Advanced Information Systems Engineering; 2002.

    Google Scholar 

  8. Winter R, Strauch B. A method for demand-driven information requirements analysis in data warehousing. In: Proceedings of the 36th Annual Hawaii International Conference on System Sciences; 2003.

    Google Scholar 

  9. Hüsemann B, Lechtenbörger J, Vossen G. Conceptual data warehouse design. In: Proceedings of the 2nd International Workshop on Design and Management of Data Warehouses; 2000.

    Google Scholar 

  10. Abelló A, Samos J, Saltor F. YAM2: a multidimensional conceptual model extending UML. Inform Syst. 2006;31(6):541–67.

    Article  Google Scholar 

  11. Theodoratos D, Sellis T. Designing data data warehouses. Data Knowl Eng. 1999;31(3):279–301.

    Article  MATH  Google Scholar 

  12. Trujillo J, Luján-Mora SA. UML based approach for modeling ETL processes in data warehouses. In: Proceedings of the 22nd International Conference on Conceptual Modeling; 2003.

    Chapter  Google Scholar 

  13. Vassiliadis P, Simitsis A, Skiadopoulos S. Conceptual modeling for ETL processes. In: Proceedings of the ACM 5th International Workshop on Data Warehousing and OLAP; 2002.

    Google Scholar 

  14. Golfarelli M, Rizzi S, Saltarelli E. Index selection for data warehousing. In: Proceedings of the 4th International Workshop on Design and Management of Data Warehouses; 2002.

    Google Scholar 

  15. Golfarelli M, Rizzi S, Turricchia E. Modern software engineering methodologies meet data warehouse design: 4WD. In: Proceedings of the 13th International Conference on Data Warehousing and Knowledge Discovery; 2011.

    Chapter  Google Scholar 

  16. Hughes R. Agile data warehousing: delivering world-class business intelligence systems using scrum and XP. IUniverse; 2008.

    Google Scholar 

  17. Golfarelli M, Rizzi S. WAND: a CASE tool for data warehouse design. In: Proceedings of the 17th International Conference on Data Engineering; 2001.

    Google Scholar 

  18. Trujillo J, Luján-Mora S, Medina E. The gold model case tool: an environment for designing OLAP applications. In: Proceedings of the ACM 5th International Workshop on Data Warehousing and OLAP; 2002.

    Google Scholar 

  19. Francia M, Golfarelli M, Rizzi S. A methodology for social BI. In: Proceedings of the International Conference on Database Engineering and Applications; 2014.

    Google Scholar 

  20. Tho N, Tjoa A. Grid-based zero-latency data warehousing for continuous data streams processing. In: Proceedings of the 6th International Conference on Information Integration and Web Based Applications & Services; 2004.

    Google Scholar 

  21. Abelló A, Darmont J, Etcheverry L, Golfarelli M, Mazón JN, Naumann F, Pedersen TB, Rizzi S, Trujillo J, Vassiliadis P, Vossen G. Fusion cubes: towards self-service business intelligence. Int J Data Warehouse Min. 2013;9(2).

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. DISI – University of Bologna, Bologna, Italy

    Matteo Golfarelli

Authors
  1. Matteo Golfarelli
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Matteo Golfarelli .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, GA, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, ON, Canada

    M. Tamer Özsu

Section Editor information

  1. Department of Computer Science, Aalborg University, Aalborg, Denmark

    Torben Bach Pedersen

  2. DISI, Univ. of Bologna, Bologna, Italy

    Stefano Rizzi

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Science+Business Media, LLC, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Golfarelli, M. (2018). Data Warehouse Life Cycle and Design. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_117

Download citation

Publish with us

Policies and ethics

Search

Navigation