Administering in the data warehause system

Marcin Gorawski, Dariusz Mrozek


In the article, we would like to introduce crucial aspects of the mana-gement process in the data warehouse environment. We investigate existing mana-gement models and the cooperative management model we created. Special place we dedicate to role of metadata concept, the way we can store it and exchange in men-tioned models. Additionally, we would like to introduce management console appli-cation that is based on the cooperative management model.


data warehouses; administering; metadata; repository

Full Text:

PDF (Polski)


Kimball R., Reeves L., Ross M., Thornthwaite W.: The Data Warehouse Lifecycle Tool-kit, Expert Methods for Designing, Developing and Deploying Data Warehouses. John Wiley & Sons, Inc., New York, 1998.

Gorawski M.: Praktyczne aspekty projektowania hurtowni danych. Studia Informatica, vol.24, nr 4 (56), 2004.

Staudt M., Vaduva A., Vetterli T.: The Role of Metadata for Data Warehousing, Proc. In-ternational Database Engineering and Applications Symposium (IDEAS '01), Grenoble, France, July 2001.

Stöhr T., Müller R., Rahm E.: An Integrative and Uniform Model for Metadata Manage-ment in Data Warehousing Environments, Preceedings of the International Workshop on Design and Management of Data Warehouses (DMDW’99).

Staudt M., Vaduva A., Vetterli T.: Metadata Standards for Data Warehousing: Open Infor-mation Model vs. Common Warehouse Metamodel, SIGMOD Record 29(3): 68-75 2000.

Meta Data Coalition. Open Information Model. Version 1.0, August 1999,

Object Management Group, Common Warehouse Metamodel (CWM) Specification, Sep-tember 1999,

Object Management Group, XML Metadata Interchange (XMI) Specification, Version 2.0, May 2003,