engleski

Conceptual Model for the New Generation of Data Warehouse System Catalog

This paper introduces a formal definition of a Data Vault model and a conceptual data model of a new Data Warehouse (DW) system catalog (Metadata Vault Repository - MDV) which is based on the Data Vault (DV) method for database modeling. The goal of this conceptual MDV model is to serve as a basis for future development of a new generation of DW temporal system catalogs – catalogs that will track and manage changes in the DW data and metadata, as well as in its' schemas. The main contributions of this paper are: a) a formal definition of DV model and its main concepts, b) a conceptual MDV model, c) a final set of fundamental changes over the DW schema, and d) a formal algebra for DW schema maintenance.

Data Warehouse ; Data Vault ; Schema Evolution ; Conceptual Model ; System Catalog

nije evidentirano