Forschungsdatenbank

Projektübersicht
Login
Suche

Gatziu

Fakultäten » Wirtschaftswissenschaftliche Fakultät » Informatik, Institut für » Prof. Dr. Klaus Dittrich (verstorben) » Gatziu

Completed research project

Title / Titel
SIRIUS
(Supporting incremental refreshment of information warehouses)
PDF Abstract (PDF, 14 KB)
Summary / Zusammenfassung

Data warehouse systems integrate information from several operational systems and store this information in a data storage (the data warehouse, DWH) that is targeted for decision support. In the context of the SIRIUS project, we investigate the data warehouse refresh process with the main focus on

  • the applicability of our approach in data warehouse environments consisting of a wide variety of heterogeneous operational sources (various database systems, flat files, etc.),
  • providing facilities in order to refresh a DWH independently of how warehouse data are persistently stored, i.e., we make no assumptions about the database system used for the DWH and about modeling concepts,
  • the support of incremental warehouse refresh. Data warehouse volumes can reach hundreds of gigabytes or even several terabytes. Hence, avoiding a complete reload of DWH data is a crucial issue and can reduce the refreshment time of DWH data significantly,
  • providing mechanisms regarding the special nature of the warehouse data like derived and historical data,
  • the support of the automatic execution of the whole refresh process based on user-defined specifications (e.g., about the start of the refresh process),
  • facilitating the adaptation of new refresh techniques which might, e.g., become necessary because of the extension of a DWH by new sources or new kinds of data from the same sources.

Weitere Informationen
Publications / Publikationen S. Gatziu, A. Vavouras, K. R. Dittrich:
SIRIUS: An Approach for Data Warehouse Refreshment.
Technical Report, 98.07, Department of Computer Science, University of Zurich, June 1998.

A. Vavouras, S. Gatziu, K. Dittrich:
The SIRIUS Approach for Refreshing Data Warehouses Incrementally.
8. Fachtagung BTWí99 (Datenbanksysteme in Büro, Technik und Wissenschaft, Freiburg, March 1999

Keywords / Suchbegriffe data warehousing, data warehouse refresh process, data warehouse design
Project leadership and contacts /
Projektleitung und Kontakte
Dr. S. Gatziu (Project Leader) gatziu@ifi.uzh.ch
A. Vavouras vavouras@ifi.uzh.ch
Funding source(s) /
Unterstützt durch
Universität Zürich (position pursuing an academic career)
 
Duration of Project / Projektdauer Jan 1998 to Jun 2000