The SIRIUS Approach for Refreshing Data Warehouses Incrementally

Data warehouse refresh incorporates issues on how to capture and propagate updates occurring in operational systems into the warehouse in order to keep the data warehouse up-to-date. In this paper, we propose an object-oriented approach for the incremental refresh of data warehouses which considers the special nature of warehouse data, e.g., its temporal and heterogeneous dimension. Our approach can be used for the integration of data from a wide variety of heterogeneous operational sources and independently of a particular database system used for storing the warehouse data.

[1]  Gio Wiederhold,et al.  Value-added Mediation in Large-Scale Information Systems , 1995, DS-6.

[2]  Jian Yang,et al.  Algorithms for Materialized View Design in Data Warehousing Environment , 1997, VLDB.

[3]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[4]  Matthias Jarke,et al.  Incremental Maintenance of Externally Materialized Views , 1996, VLDB.

[5]  John Mylopoulos,et al.  A generic integration architecture for cooperative information systems , 1996, Proceedings First IFCIS International Conference on Cooperative Information Systems.

[6]  Alejandro P. Buchmann,et al.  Research Issues in Data Warehousing , 1997, BTW.

[7]  Ambuj K. Singh,et al.  Efficient view maintenance at data warehouses , 1997, SIGMOD '97.

[8]  Nick Roussopoulos,et al.  Materialized views and data warehouses , 1998, SGMD.

[9]  Yue Zhuge,et al.  The Strobe algorithms for multi-source warehouse consistency , 1996, Fourth International Conference on Parallel and Distributed Information Systems.

[10]  Divesh Srivastava,et al.  Answering Queries with Aggregation Using Views , 1996, VLDB.

[11]  Mary Roth,et al.  Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources , 1997, VLDB.

[12]  Inderpal Singh Mumick,et al.  The Stanford Data Warehousing Project , 1995 .

[13]  Klaus R. Dittrich,et al.  SIRIUS: An Approach for Data Warehouse Refreshment , 1998 .

[14]  Jennifer Widom,et al.  Making views self-maintainable for data warehousing , 1996, Fourth International Conference on Parallel and Distributed Information Systems.

[15]  Jennifer Widom,et al.  A System Prototype for Warehouse View Maintenance , 1996, VIEWS.

[16]  Gio Wiederhold,et al.  Intelligent integration of information , 1993, Springer US.

[17]  Jennifer Widom,et al.  Maintenance of Materialized Views: Problems, Techniques, and Applications , 1999, IEEE Data Eng. Bull..

[18]  Jennifer Widom,et al.  Active Database Systems: Triggers and Rules For Advanced Database Processing , 1994 .

[19]  David Jordan,et al.  The Object Database Standard: ODMG 2.0 , 1997 .

[20]  Jennifer Widom,et al.  Research problems in data warehousing , 1995, CIKM '95.

[21]  Jennifer Widom,et al.  Maintaining Temporal Views over Non-Temporal Information Sources for Data Warehousing , 1998, EDBT.

[22]  Nam Huyn,et al.  Multiple-View Self-Maintenance in Data Warehousing Environments , 1997, VLDB.

[23]  Elisa Bertino,et al.  Integration of heterogeneous data repositories by using object-oriented views , 1991, [1991] Proceedings. First International Workshop on Interoperability in Multidatabase Systems.

[24]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[25]  Erich J. Neuhold,et al.  ViewSystem: integrating heterogeneous information bases by object-oriented views , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[26]  Matthias Jarke,et al.  Dwq : Esprit Long Term Research Project, No 22469 Data Warehouse Quality: a Review of the Dwq Project , 2022 .