6533b821fe1ef96bd127ac14

RESEARCH PRODUCT

Metadata to Support Data Warehouse Evolution

Darja Solodovnikova

subject

Data elementInformation retrievalDatabaseComputer scienceInformationSystems_DATABASEMANAGEMENTcomputer.software_genreData warehouseMetadata repositorySchema evolutionMetadataRelational database management systemData extractionSchema (psychology)computer

description

The focus of this chapter is metadata necessary to support data warehouse evolution. We present the data warehouse framework that is able to track evolution process and adapt data warehouse schemata and data extraction, transformation, and loading (ETL) processes. We discuss the significant part of the framework, the metadata repository that stores information about the data warehouse, logical and physical schemata and their versions. We propose the physical implementation of multiversion data warehouse in a relational DBMS. For each modification of a data warehouse schema, we outline the changes that need to be made to the repository metadata and in the database.

yearjournalcountryeditionlanguage
2009-01-01
https://doi.org/10.1007/b137171_65