Data warehouse refreshment is often viewed as a problem of maintaining materialized views over operational sources. In this paper, we show that the data warehouse refreshment process is a complex process comprising several tasks, e.g., monitoring, extracting, transforming, integrating and cleaning operational data, deriving new data, building histories and loading the data warehouse. We propose a novel approach for defining and executing the refreshment process based on specifications stored in an object-oriented metadata repository. Our approach considers the multidimensional character of OLAP data and can be used in conjunction with various operational sources and target data warehouses.
|
229
|
View maintenance in a warehousing environment
– Zhuge, Garcia-Molina, et al.
- 1995
|
|
220
|
Research problems in data warehousing
– Widom
- 1995
|
|
188
|
The Object Database Standard: ODMG 2.0
– Cattell
- 1997
|
|
187
|
Don’t scrap it, wrap it! A wrapper architecture for data sources
– Roth, Schwarz
- 1997
|
|
172
|
An Overview of Data Warehousing
– Chaudhuri, Dayal
- 1997
|
|
112
|
Making views self-maintainable for data warehousing
– Quass, Gupta, et al.
- 1996
|
|
86
|
The Strobe Algorithms for Multi-Source Warehouse Consistency
– Zhuge, Garc'ia-Molina, et al.
- 1996
|
|
84
|
Multi-Table Joins Through Bitmapped Join Indexes
– O’Neill, Graefe
- 1995
|
|
73
|
Algorithms for materialized view design in data warehousing environment
– YANG, KARLAPALEM, et al.
- 1997
|
|
65
|
The Stanford Data Warehousing Project
– Hammer, Garcia-Molina, et al.
- 1995
|
|
63
|
Bitmap index design and evaluation
– Chan, Ioannidis
- 1998
|
|
58
|
Extending the E/R Model for the Multidimensional Paradigm
– Sapia, Blaschka, et al.
- 1998
|
|
50
|
Answering Queries with Aggregation Using Views
– Dar, Jagadish, et al.
- 1996
|
|
48
|
A methodological framework for data warehouse design
– Golfarelli, Rizzi
- 1998
|
|
47
|
ViewSystem: Integrating Heterogeneous Information Bases by Object-Oriented Views
– Kaul, Drosten, et al.
- 1990
|
|
46
|
starER: A conceptual model for data warehouse design
– Tryfona, Busborg, et al.
- 1999
|
|
42
|
Encoded bitmap indexing for data warehouses
– Wu, Buchmann
- 1998
|
|
35
|
Materialized Views and Data Warehouses
– Roussopoulos
- 1998
|
|
34
|
Integration of Heterogeneous Data Repositories by Using Object-Oriented Views
– Bertino
- 1991
|
|
33
|
Multiple-View Self-Maintenance in Data Warehousing Environments
– Huyn
- 1997
|
|
28
|
Jarke. Incremental Maintenance of Externally Materialized Views
– Staudt, Matthias
- 1996
|
|
25
|
A System Prototype for Warehouse View Maintenance
– Wiener, Gupta, et al.
- 1996
|
|
20
|
Modeling Data Warehouse Refreshment Process as a Workflow Application
– Bouzeghoub, Fabret, et al.
- 1999
|
|
18
|
A Generic Integration Architecture for Cooperative Information Systems
– Mylopoulos, Gal, et al.
- 1996
|
|
14
|
Ceri (eds.). Active Database Systems: Triggers and Rules For Advanced Database processing
– Widom, S
- 1995
|
|
6
|
Designing the Global Data Warehouse with SPJ Views
– Theodoratos, Ligoudistianos, et al.
- 1999
|
|
5
|
Data Warehouse Quality: A Review of the DWQ
– Jarke, Vassiliou
- 1997
|
|
3
|
Building the Data Warehouse
– Immon
- 1996
|
|
3
|
Utilizing Page-Level Join Index for Optimization in Parallel Join Execution
– Lee, Chang
- 1995
|
|
3
|
The SIRIUS Approach for Refreshing Data Warehouses Incrementally
– Vavouras, Gatziu, et al.
- 1999
|
|
1
|
The DataFoundry Project: Managing Change in a Genome Warehouse. Presentation in
– Critchlow
- 1998
|
|
1
|
Data Warehouse Maintenance Under Cuncurrent Schema and Data Updates
– Zhang
- 1999
|
