Research problems in data warehousing

The topic of data warehousing encompasses architectures, algorithms, and tools for bringing together selected data from multiple databases or other information sources into a single repository, called a data warehouse, suitable for direct querying or analysis. In recent years data warehousing has become a prominent buzzword in the database industry, but attention from the database research community has been limited. In this paper we motivate the concept of a data warehouse, we outline a general data warehousing architecture, and we propose a number of technical issues arising from the architecture that we believe are suitable topics for exploratory research.

[1]  Per-Åke Larson,et al.  Updating derived relations: detecting irrelevant and autonomously computable updates , 1986, VLDB.

[2]  Michael D. Soo,et al.  Bibliography on temporal databases , 1991, SGMD.

[3]  Jennifer Widom,et al.  Deriving Production Rules for Incremental View Maintenance , 1991, VLDB.

[4]  Gio Wiederhold,et al.  Mediators in the architecture of future information systems , 1992, Computer.

[5]  Jan Chomicki,et al.  History-less checking of dynamic integrity constraints , 1992, [1992] Eighth International Conference on Data Engineering.

[6]  Alon Y. Halevy,et al.  Queries Independent of Updates , 1993, VLDB.

[7]  Jennifer Widom,et al.  Local verification of global integrity constraints in distributed databases , 1993, SIGMOD '93.

[8]  W. H. Inmon,et al.  Rdb/VMS: Developing the Data Warehouse , 1993 .

[9]  Jennifer Widom,et al.  The TSIMMIS Project: Integration of Heterogeneous Information Sources , 1994, IPSJ.

[10]  Kenneth A. Ross,et al.  Efficient Incremental Evaluation of Queries with Aggregation , 1994, ILPS.

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

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

[13]  H. Garcia-Molina,et al.  The Stanford Data Warehousing Project , 1995, IEEE Data Eng. Bull..

[14]  Data Integration and Warehousing Using H2O , 1995, IEEE Data Eng. Bull..

[15]  Jeffrey D. Ullman,et al.  A Query Translation Scheme for Rapid Implementation of Wrappers , 1995, DOOD.

[16]  Jennifer Widom,et al.  View maintenance in a warehousing environment , 1995, SIGMOD '95.

[17]  Hector Garcia-Molina,et al.  Efficient Snapshot Differential Algorithms for Data Warehousing , 1996, VLDB.

[18]  Jennifer Widom,et al.  Change detection in hierarchically structured information , 1996, SIGMOD '96.

[19]  H. V. Jagadish,et al.  Data Integration using Self-Maintainable Views , 1996, EDBT.