The framework for detecting and propagating changes from data sources structure into a data wareshouse

• Autorzy: Wrembel R. , Bębel B. , Królikowski Z.
• Języki publikacji: EN

Abstrakty

EN

In this paper we propose a framework for detecting changes in external data sources (EDSs) and propagating them into a multiversion data warehouse (MVDW). The architecture of our prototype MVDW uses an operational data store (ODS) as a buffering layer between EDSs and a MVDW. The functionality of the ODS that we developed is responsible for detecting structural changes in external data sources and creating the set of MVDW modification operations automatically. The operations can next be applied to a new or existing data warehouse version. Changes in data sources that are to be detected and the way they are to be propagated into a data warehouse are defined by a management software, also discussed in the paper.

Słowa kluczowe

EN

external data sources; data warehouse

PL

źródło danych; magazyn danych

• Wydawca: Wydawnictwo Politechniki Poznańskiej
• Czasopismo: Foundations of Computing and Decision Sciences
• Rocznik: 2005
• Tom: Vol. 30, No. 4
• Strony: 361--372
• Opis fizyczny: Bibliogr. 35 poz.

Twórcy

autor

Wrembel R.

• Institute of Computing Science, Poznań University of Technology, Poznań, Poland

autor

Bębel B.

• Institute of Computing Science, Poznań University of Technology, Poznań, Poland

autor

Królikowski Z.

• Institute of Computing Science, Poznań University of Technology, Poznań, Poland

Bibliografia

• [1] Andany J., Leonard М., Palisser С., Management of schema evolution in databases, Proc. of VLDB, 1991.
• [2] Balmin, A., Papadimitriou, Т., Papakonstanitnou, Y., Hypothetical Queries in an OLAP Environment, Proc. of VLDB, Egypt, 2000.
• [3] Bębel В., Transactional Refreshing of Data Warehouses. PhD thesis, Poznań University of Technology, Institute of Computing Science, 2005.
• [4] Bębel В., Eder J., Koncilia C., Morzy Т., Wrembel R., Creation and Management of Versions in Multiversion Data Warehouse, Proc. of ACM SAC, Cyprus, 2004,
• [5] Bębel В., Królikowski Z., Morzy Т., Wrembel R., Transaction Concepts for Supporting Changes in Data Warehouses, Proc. of ICEIS, Portugal, 2004.
• [6] Bellahsene Z., View Mechanism for Schema Evolution in Object-Oriented DBMS, Proc. of BNCOD, 1996.
• [7] Benatallah В., A Unified Framework for Supporting Dynamic Schema Evolution in Object Databases, Proc. of ER, 1999.
• [8] Blaschka, M. Sapia, C., Hofling, G., On Schema Evolution in Multidimensional Databases, Proc. of DaWak99, Italy, 1999.
• [9] Body, M., Miquel, M., Bédard, Y., Tchounikine A., A Multidimensional and Multiversion Structure for OLAP Applications, Proc. of DOLAP, USA, 2002.
• [10] Bouguettaya A., Benatallah В., Elmargamid A., Interconnecting Heterogeneous Information Systems, Kluwer Academic Publishers, 1998.
• [11] Chamoni, P., Stock, S., Temporal Structures in Data Warehousing, Proc. of DaWaK99, Italy, 1999.
• [12] Chawathe S.S., Garcia-Molina H., Hammer J., Ireland K., Papakonstantinou Y., Ullman J.D., Widom J., The TSIMMIS project: Integration of heterogeneous information sources, Proc. of IPS, Japan, 1994.
• [13] Chen J., Chen S., Rundensteiner E., A Transactional Model for Data Warehouse Maintenance, Proc of ER, Finland, 2002.
• [14] Eder, J., Koncilia, C., Changes of Dimension Data in Temporal Data Warehouses, Proc. of DaWaK, Germany, 2001.
• [15] Eder, J., Koncilia, C., Morzy, Т., The COMET Metamodel for Temporal Data Warehouses, Proc. of CAISE, Canada, 2002.
• [16] Elmagarmid A., Rusinkiewicz М., Sheth А., Management of Heterogeneous and Autonomous Database Systems, Morgan Kaufmann Publishers, 1999.
• [17] Gyssens M., Lakshmanan L.V.S., A Foundation for Multi-Dimensional Databases, Proc. of VLDB, Grece, 1997.
• [18] Hurtado, C.A., Mendelzon, A.O.: Vaisman, A.A., Maintaining Data Cubes under Dimension Updates, Proc. Of ICDE, Australia, 1999.
• [19] Hurtado, C.A., Mendelzon, A.O.: Vaisman, A.A., Updating OLAP Dimensions, Proc. of DOLAP, 1999.
• [20] Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P., Fundamentals of Data Warehouses, Springer-Verlag, 2000, ISBN 3-540-65365-1.
• [21] Kaas Ch.K., Pedersen Т.B., Rasmussen B.D., Schema Evolution for Stars and Snowflakes, Proc. of ICEIS, Portugal, 2004.
• [22] Kang, H.G., Chung, C.W., Exploiting Versions for On-line Data Warehouse Maintenance in MOLAP Servers, Proc. of VLDB, China, 2002.
• [23] Koeller, A., Rundensteiner, E.A., Hachem, N., Integrating the Rewriting and Ranking Phases of View Synchronization, Proc. of DOLAP, USA, 1998.
• [24] Kulkarni, S., Mohania, M., Concurrent Maintenance of Views Using Multiple Versions, Proc. of IDEAS, 1999.
• [25] Letz C., Henn E.T., Vossen G., Consistency in Data Warehouse Dimensions, Proc. of IDEAS, 2002.
• [26] Levy A., Rajaraman A., Ordille J., Querying heterogeneous information sources using source descriptions, Proc. of VLDB, 1996.
• [27] McBrien P., Poulovassilis A., Automatic Migration and Wrapping of Database Applications - a Schema Transformation Approach, Proc. Of ER, 1999.
• [28] McBrien P., Poulovassilis A., Schema Evolution in Heterogeneous Database Architectures, A Schema Transformation Approach, Proc. of CAiSE, 2002.
• [29] Mendelzon, A.O., Vaisman, A.A., Temporal Queries in OLAP, Proc. of VLDB, Egypt, 2000.
• [30] Morzy, Т., Wrembel, R., Modeling a Multiversion Data Warehouse: A Formal Approach, Proc. of ICEIS, France, 2003.
• [31] Quass, D., Widom, J., On-Line Warehouse View Maintenance, Proc. of SIGMOD, 1997.
• [32] Rundensteiner E., Koeller A., and Zhang X., Maintaining Data Warehouses over Changing Information Sources, Communications of the ACM, vol. 43, No. 6, 2000.
• [33] Templeton M., Henley H., Maros E., van Buer D.J., InterVisio: Dealing with the complexity of federated database access, The VLDB Journal, 4(2), 1995.
• [34] Vaisman A.A., Mendelzon A.O., Ruaro W., Cymerman S.G., Supporting Dimension Updates in an OLAP Server, Proc. of CAISE02 Conference, Canada, 2002.
• [35] Roth M.T., Schwarz P., Don't scrap it, wrap it. A wrapper architecture for data sources, Proc. of VLDB, 1997.