Abstract
Data warehouses tend to evolve, because of changes in data sources and business requirements of users. All these kinds of changes must be properly handled, therefore, data warehouse development is never-ending process. In this paper we propose the evolution-oriented user-centric data warehouse design, which on the one hand allows to manage data warehouse evolution automatically or semi-automatically, and on the other hand it provides users with the understandable, easy and transparent data analysis possibilities. The proposed approach supports versions of data warehouse schemata and data semantics.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Golfarelli M, Lechtenbörger J, Rizzi S, Vossen G (2006) Schema versioning in data warehouses: enabling cross-version querying via schema augmentation. Data Knowl Eng 59(2):435–459
Hurtado CA, Mendelzon AO, Vaisman AA (1999) Maintaining data cubes under dimension updates. In: 15th international conference on data engineering. IEEE Computer Society, Sydney, pp 346–357
Blaschka M (2000) FIESTA: a framework for schema evolution in multidimensional databases. PhD thesis, Technische Universitat Munchen, Germany
Banerjee S, Davis KC (2009) Modeling data warehouse schema evolution over extended hierarchy semantics. J Data Semant XIII, LNCS 5530. Springer, Heidelberg, pp 72–96
Marotta A (2000) Data warehouse design and maintenance through schema transformations. Master thesis, Universidad de la República Uruguay
Velegrakis Y, Miller RJ, Popa L (2003) Mapping adaptation under evolving schemas. In: 29th international conference on VLDB. Morgan Kaufmann, Berlin, pp 584–595
Bellahsene Z (2002) Schema evolution in data warehouses. Knowl Inf Syst 4:283–304
Rundensteiner EA, Koeller A, Zhang X (2000) Maintaining data warehouses over changing information sources. Commun ACM 43(6):57–62
Wrembel R, Bebel B (2005) Metadata management in a multiversion data warehouse. In: OTM conferences (2), LNCS 3761. Springer, Heidelberg, pp 1347–1364
Body M, Miquel M, Bedard Y, Tchounikine A (2002) A multidimensional and multiversion structure for OLAP applications. In: ACM 5th international workshop on data warehousing and OLAP. ACM, McLean, pp 1–6
Morzy T, Wrembel R (2004) On querying versions of multiversion data warehouse. In: ACM 7th international workshop on data warehousing and OLAP. ACM, Washington, pp 92–101
Solodovnikova D (2007) Data warehouse evolution framework. In: Spring young researcher’s colloquium on database and information systems, Moscow, Russia
Object Management Group (2003) Common warehouse metamodel specification, v1.1 http://www.omg.org/cgi-bin/doc?formal/03-03-02
Solodovnikova D (2008) Building queries on multiple versions of data warehouse. In: 8th International Baltic conference on DB&IS, Tallinn, Estonia, pp 75–86
Acknowledgments
This work has been supported by ESF projects No. 2009/0216/1DP/1.1.1.2.0/09/APIA/VIAA/044 and 2009/0138/1DP/1.1.2.1.2/09/IPIA/VIAA/004.
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer Science+Business Media, LLC
About this paper
Cite this paper
Solodovnikova, D., Niedrite, L. (2011). Evolution-Oriented User-Centric Data Warehouse. In: Pokorny, J., et al. Information Systems Development. Springer, New York, NY. https://doi.org/10.1007/978-1-4419-9790-6_58
Download citation
DOI: https://doi.org/10.1007/978-1-4419-9790-6_58
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4419-9645-9
Online ISBN: 978-1-4419-9790-6
eBook Packages: Computer ScienceComputer Science (R0)