ABSTRACT
A data warehouse (DW) provides an information for analytical processing, decision making, and data mining tools. On the one hand, the structure and content of a data warehouse reflects a real world, i.e. data stored in a DW come from real production systems. On the other hand, a DW and its tools may be used for predicting trends and simulating a virtual business scenarios. This activity is often called the what-if analysis. Traditional DW systems have static structure of their schemas and relationships between data, and therefore they are not able to support any dynamics in their structure and content. For these purposes, multiversion data warehouses seem to be very promising. In this paper we present a concept and an ongoing implementation of a multiversion data warehouse that is capable of handling changes in the structure of its schema as well as simulating alternative business scenarios.
- Balmin, A., Papadimitriou, T., Papakonstanitnou, Y.: Hypothetical Queries in an OLAP Environment. Proc. of the VLDB Conf., Egypt, 2000]] Google ScholarDigital Library
- Bellahsene, Z.: View Adaptation in Data Warehousing Systems. Proc. of the DEXA Conf., 1998]] Google ScholarDigital Library
- Blaschka, M. Sapia, C., Hofling, G.: On Schema Evolution in Multidimensional Databases. Proc. of the DaWak99 Conference, Italy, 1999]] Google ScholarDigital Library
- Body, M., Miquel, M., Bédard, Y., Tchounikine A.: A Multidimensional and Multiversion Structure for OLAP Applications. Proc. of the DOLAP'2002 Conf., USA, 2002]] Google ScholarDigital Library
- Chamoni, P., Stock, S.: Temporal Structures in Data Warehousing. Proc. of the Data Warehousing and Knowledge Discovery DaWaK, Italy, 1999]] Google ScholarDigital Library
- Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP technology. SIGMOD Record, 26, 1997]] Google ScholarDigital Library
- Eder, J., Koncilia, C.: Changes of Dimension Data in Temporal Data Warehouses. Proc. of the DaWak 2001 Conference, Germany, 2001]] Google ScholarDigital Library
- Eder, J., Koncilia, C., Morzy, T.: The COMET Metamodel for Temporal Data Warehouses. Proc. of the CAISE'02 Conference, Canada, 2002]] Google ScholarDigital Library
- Hurtado, C. A., Mendelzon, A. O.: Vaisman, A. A.: Maintaining Data Cubes under Dimension Updates. Proc. of the ICDE Conference, Australia, 1999]] Google ScholarDigital Library
- Hurtado, C. A., Mendelzon, A. O.: Vaisman, A. A.: Updating OLAP Dimensions. Proc. of the DOLAP Workshop, 1999]] Google ScholarDigital Library
- Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of Data Warehouses. Springer-Verlag, 2000, ISBN 3-540-65365-1]] Google ScholarDigital Library
- Kang, H. G., Chung, C. W.: Exploiting Versions for On--line Data Warehouse Maintenance in MOLAP Servers. Proc. of the VLDB Conference, China, 2002]]Google Scholar
- Koeller, A., Rundensteiner, E. A., Hachem, N.: Integrating the Rewriting and Ranking Phases of View Synchronization. Proc. of the DOLAP Workshop, USA, 1998]] Google ScholarDigital Library
- Kulkarni, S., Mohania, M.: Concurrent Maintenance of Views Using Multiple Versions. Proc. of the Intern. Database Engineering and Application Symposium, 1999]] Google ScholarDigital Library
- Mendelzon, A. O., Vaisman, A. A.: Temporal Queries in OLAP. Proc. of the VLDB Conference, Egypt, 2000]] Google ScholarDigital Library
- Morzy, T., Wrembel, R.: Modeling a Multiversion Data Warehouse: A Formal Approach. Proc. of the Int. Conf. on Enterprise Information Systems - ICESI'2003, France, 2003]]Google Scholar
- Quass, D., Widom, J.: On--Line Warehouse View Maintenance. Proc. of the SIGMOD Conference, 1997]] Google ScholarDigital Library
- Roddick J.: A Survey of Schema Versioning Issues for Database Systems. In Information and Software Technology, volume 37(7):383--393, 1996]]Google ScholarCross Ref
- Rundensteiner E., Koeller A., and Zhang X.: Maintaining Data Warehouses over Changing Information Sources. Communications of the ACM, vol. 43, No. 6, 2000]] Google ScholarDigital Library
- Sjøberg D.: Quantifying Schema Evolution. Information Software Technology 35, 1, 35--54, 1993]]Google Scholar
- Wrembel, R. Bȩbel B.: Schema Management in a Multiversion Data Warehouse. Submitted to the First Special Interest Symposium on Data Warehousing and Data Mining, Germany, July, 2003]]Google Scholar
- SAP America, Inc. and SAP AG. Data Modelling with BW - ASAP for BW Accelerator. 1998. http://www.sap.com]]Google Scholar
- Agrawal, R., Buroff, S., Gehani, N., Shasha, D. (1991). Object Versioning in Ode. Proc. of the ICDE Conference]] Google ScholarDigital Library
- Ahmed-Nacer M., Estublier J.: Schema Evolution in Software Engineering. In: Databases -- A new Approach in ADELE environment. Computers and Artificial Intelligence, 19:183--203, 2000]]Google Scholar
- Bielikova M., Navrat P.: Modelling Versioned Hypertext Documents. Proc. of the ECOOP'98, SCM-8 Symposium, Belgium, 1998]] Google ScholarDigital Library
- Cellary, W., Jomier, G. (1990). Consistency of Versions in Object-Oriented Databases. Proc. of the VLDB Conference]] Google ScholarDigital Library
- Kim, W., Chou, H. (1998). Versions of Schema for Object-Oriented Database. Proc. of the VLDB Conference]] Google ScholarDigital Library
Index Terms
- Creation and management of versions in multiversion data warehouse
Recommendations
On querying versions of multiversion data warehouse
DOLAP '04: Proceedings of the 7th ACM international workshop on Data warehousing and OLAPA data warehouse (DW) is fed with data that come from external data sources that are production systems. External data sources, which are usually autonomous, often change not only their content but also their structure. The evolution of external data ...
Alliance Rules for Data Warehouse Cleansing
ICSPS '09: Proceedings of the 2009 International Conference on Signal Processing SystemsData Cleansing is an activity performed on the data sets of data warehouse to enhance and maintain the quality and consistency of the data. This paper addresses the problems related with dirty data, entrance of dirty data and detection of dirty data in ...
Metadata management in a multiversion data warehouse
OTM'05: Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, COA, and ODBASE - Volume Part IIA data warehouse (DW) is supplied with data that come from external data sources (EDSs) that are production systems. EDSs, which are usually autonomous, often change not only their contents but also their structures. The evolution of external data ...
Comments