Skip to main content

Handling Evolving Data Warehouse Requirements

  • Conference paper
  • First Online:
New Trends in Databases and Information Systems (ADBIS 2015)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 539))

Included in the following conference series:

  • East European Conference on Advances in Databases and Information Systems

Abstract

A data warehouse is a dynamic environment and its business requirements tend to evolve over time, therefore, it is necessary not only to handle changes in data warehouse data, but also to adjust a data warehouse schema in accordance with changes in requirements. In this paper, we propose an approach to propagate modified data warehouse requirements in data warehouse schemata. The approach supports versions of data warehouse schemata and employs the requirements formalization metamodel and multiversion data warehouse metamodel to identify necessary changes in a data warehouse.

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

Access this chapter

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. Parmenter, D.: Key Performance Indicators: Developing, Implementing, and Using Winning KPIs, 2nd edn. Jon Wiley & Sons, Inc. (2010)

    Google Scholar 

  2. Winter, R., Strauch, B.: A method for demand-driven information requirements analysis in data warehousing projects. In: Proceedings of the 36th Annual Hawaii International Conference on System Sciences, p. 9. IEEE (2003)

    Google Scholar 

  3. Frank, U., Heise, D., Kattenstroth, H., Schauer, H.: Designing and utilizing business indicator systems within enterprise models - outline of a method. In: Loos, P., Nüttgens, M., Turowski, K., Werth, D. (eds.) Modellierung Betrieblicher Informationssysteme (MobIS 2008) - Modellierung zwischen SOA und Compliance Management, LNI, Saarbrücken, Germany, vol. 141, pp. 89–105 (2008)

    Google Scholar 

  4. Popova, V., Treur, J.: A Specification Language for Organizational Performance Indicators. Applied Intelligence Journal 27(3), 291–301 (2007)

    Article  Google Scholar 

  5. Golfarelli, M., Lechtenbörger, J., Rizzi, S., Vossen, G.: Schema versioning in data warehouses: Enabling cross-version querying via schema augmentation. Data Knowl. Eng. 59(2), 435–459 (2006)

    Article  Google Scholar 

  6. Vaisman, A.A., Mendelzon, A.O., Ruaro, W., Cymerman, S.G.: Supporting dimension updates in an OLAP server. Inf. Syst. 29(2), 165–185 (2004)

    Article  Google Scholar 

  7. Bebel, B., Eder, J., Koncilia, C., Morzy, T., Wrembel, R.: Creation and management of versions in multiversion data warehouse. In: SAC. pp. 717–723 (2004)

    Google Scholar 

  8. Malinowski, E., Zimányi, E.: A Conceptual Model for Temporal Data Warehouses and Its Transformation to the ER and the Object-Relational Models. Data Knowl. Eng. 64(1), 101–133 (2008)

    Article  Google Scholar 

  9. Jovanovic, P., Romero, O., Simitsis, A., Abelló, A.: ORE: an iterative approach to the design and evolution of multi-dimensional schemas. In: Proceedings of the 15th International Workshop on Data Warehousing and OLAP, pp. 1–8. ACM (2002)

    Google Scholar 

  10. Thenmozhi, M., Vivekanandan, K.: An Ontological Approach to Handle Multidimensional Schema Evolution for Data Warehouse. International Journal of Database Management Systems 6(3), 33–52 (2014)

    Article  Google Scholar 

  11. Thakur, G., Gosain, A.: DWEVOLVE: a Requirement Based Framework for Data Warehouse Evolution. ACM SIGSOFT Software Engineering Notes 36(6), 1–8 (2011)

    Article  Google Scholar 

  12. Solodovnikova, D.: Data warehouse evolution framework. In: Proceedings of Spring Young Researcher’s Colloquium on Database and Information Systems, Moscow, Russia (2007)

    Google Scholar 

  13. Niedritis, A., Niedrite, L., Kozmina, N.: Performance measurement framework with formal indicator definitions. In: Grabis, J., Kirikova, M. (eds.) BIR 2011. LNBIP, vol. 90, pp. 44–58. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

  14. Kozmina, N., Niedrite, L.: Extending a metamodel for formalization of data warehouse requirements. In: Johansson, B., Andersson, B., Holmberg, N. (eds.) BIR 2014. LNBIP, vol. 194, pp. 362–374. Springer, Heidelberg (2014)

    Google Scholar 

  15. Object Management Group. Common Warehouse Metamodel Specification, v1.1. http://www.omg.org/cgi-bin/doc?formal/03-03-02

  16. Solodovņikova, D.: The Formal Model for Multiversion Data Warehouse Evolution. Selected Papers from the 8th International Baltic Conference DB&IS, pp. 91–102. IOS Press (2008)

    Google Scholar 

  17. Golfarelli, M., Maio, D., Rizzi, S.: Conceptual design of data warehouses from E/R schemes. In: Proc. of 31st Hawaii Int. Conf. on System Sciences, pp. 334–343. IEEE, USA (1998)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Darja Solodovnikova .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Solodovnikova, D., Niedrite, L., Kozmina, N. (2015). Handling Evolving Data Warehouse Requirements. In: Morzy, T., Valduriez, P., Bellatreche, L. (eds) New Trends in Databases and Information Systems. ADBIS 2015. Communications in Computer and Information Science, vol 539. Springer, Cham. https://doi.org/10.1007/978-3-319-23201-0_35

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-23201-0_35

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-23200-3

  • Online ISBN: 978-3-319-23201-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics