Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Data Warehouse Metadata

  • Panos Vassiliadis
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_912

Definition

Data warehouse metadata are pieces of information stored in one or more special-purpose metadata repositories that include (i) information on the contents of the data warehouse, their location and their structure, (ii) information on the processes that take place in the data warehouse back-stage, concerning the refreshment of the warehouse with clean, up-to-date, semantically and structurally reconciled data, (iii) information on the implicit semantics of data (with respect to a common enterprise model), along with any other kind of data that aids the end-user exploit the information of the warehouse, (iv) information on the infrastructure and physical characteristics of components and the sources of the data warehouse, and, (v) information including security, authentication, and usage statistics that aids the administrator tune the operation of the data warehouse as appropriate.

Historical Background

Data warehouses are systems with significant complexity in their...
This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Bernstein P, Levy A, Pottinger R. A vision for management of complex models. ACM SIGMOD Rec. 2000;29(4):55–63.CrossRefGoogle Scholar
  2. 2.
    Bernstein PA, Rahm E Data warehouse scenarios for model management. In: Proceedings of the 19th International Conference on Conceptual Modeling; 2000. p. 1–15.Google Scholar
  3. 3.
    Carneiro L, Brayner A. X-META: a methodology for data warehouse design with metadata management. In: Proceedings of the 4th International Workshop on Design and Management of Data Warehouses; 2002. p. 13–22.Google Scholar
  4. 4.
    Common Warehouse Metamodel (CWM) Specification, version 1.1. OMG, March 2003.Google Scholar
  5. 5.
    Foundations of Data Warehouse Quality (DWQ) homepage. http://www.dblab.ece.ntua.gr/~dwq/
  6. 6.
    Golfarelli M, Lechtenbörger J, Rizzi S, Vossen G. Schema versioning in data warehouses: enabling cross-version querying via schema augmentation. Data Knowl Eng. 2006;59(2):435–59.CrossRefGoogle Scholar
  7. 7.
    Jarke M, Jeusfeld MA, Quix C, Vassiliadis P. 1998, Architecture and quality in data warehouses. In: Proceedings of the 10th Conference on Advanced Information Systems Engineering, 1998. LNCS, vol. 1413; 1998. p. 93–113.Google Scholar
  8. 8.
    Jarke M, Jeusfeld MA, Quix C, Vassiliadis P. Architecture and quality in data warehouses. Inf Syst. 1999;24(3):229–53.CrossRefGoogle Scholar
  9. 9.
    Jarke M, Lenzerini Y, Vassiliou P, editors. Vassiliadis fundamentals of data warehouses. 2nd ed. Springer; 2003, p. 207.Google Scholar
  10. 10.
    Jeusfeld MA, Quix C, Jarke M. Design and analysis of quality information for data warehouses. In: Proceedings of the 17th International Conference on Conceptual Modeling; 1998. p. 349–62.CrossRefGoogle Scholar
  11. 11.
    Kimball R, Caserta J. The data warehouse ETL toolkit. New York: Wiley; 2004.Google Scholar
  12. 12.
    Kimbal R, Reeves L, Ross M, Thornthwaite W. The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses. Hoboken: Wiley; 1998.Google Scholar
  13. 13.
    Metadata Coalition: Proposal for version 1.0 metadata interchange specification; 1996.Google Scholar
  14. 14.
    MetaData Coalition. Open Information Model, version 1.0; 1999.Google Scholar
  15. 15.
    Müller R, Stöhr T, Rahm E. An integrative and uniform model for metadata management in data warehousing environments. In: Proceedings of the International Workshop on Design and Management of Data Warehouses; 1999.Google Scholar
  16. 16.
    Quix C. Repository support for data warehouse evolution. In: Proceedings of the International Workshop on Design and Management of Data Warehouses; 1999.Google Scholar
  17. 17.
    Sapia C, Blaschka M, Höfling G. GraMMi: using a standard repository management system to build a generic graphical modeling tool. In: 33rd Annual Hawaii International Conference on System Sciences; 2000.Google Scholar
  18. 18.
    Vaduva A, Kietz J-U, Zücker R. M4 – a metamodel for data preprocessing. In: Proceedings of the ACM 4th International Workshop on Data Warehousing and OLAP; 2001.Google Scholar
  19. 19.
    Vetterli T, Vaduva A, Staudt M. Metadata standards for data warehousing: open information model vs. common warehouse metamodel. ACM SIGMOD Rec. 2000;29(3):68–75.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.University of IoanninaIoanninaGreece

Section editors and affiliations

  • Manfred Jeusfeld
    • 1
  1. 1.IITUniversity of SkövdeSkövdeSweden