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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Parmenter, D.: Key Performance Indicators: Developing, Implementing, and Using Winning KPIs, 2nd edn. Jon Wiley & Sons, Inc. (2010)
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)
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)
Popova, V., Treur, J.: A Specification Language for Organizational Performance Indicators. Applied Intelligence Journal 27(3), 291–301 (2007)
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)
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)
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)
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)
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)
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)
Thakur, G., Gosain, A.: DWEVOLVE: a Requirement Based Framework for Data Warehouse Evolution. ACM SIGSOFT Software Engineering Notes 36(6), 1–8 (2011)
Solodovnikova, D.: Data warehouse evolution framework. In: Proceedings of Spring Young Researcher’s Colloquium on Database and Information Systems, Moscow, Russia (2007)
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)
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)
Object Management Group. Common Warehouse Metamodel Specification, v1.1. http://www.omg.org/cgi-bin/doc?formal/03-03-02
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)
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)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)