SCHEMA EVOLUTION FOR STARS AND SNOWFLAKES

C. Kaas · Torben Bach Pedersen

36 citations0/0 files storedInternational Workshop on Pattern Recognition in Information Systems (PRIS)

No readable copy stored yet — this record is metadata only.

No open-access location is known for this record yet.

Literature note Cite in a project Citation map

Big Data and Business Intelligence Advanced Database Systems and Queries Semantic Web and Ontologies

Abstract

The most common implementation platform for multidimensional data warehouses is RDBMSs storing data in relational star and snowflake schemas. DW schemas evolve over time, which may invalidate existing analysis queries used for reporting purposes. However, the evolution properties of star and snowflake schemas have not previously been investigated systematically. This paper systematically investigates the evolution properties of star and snowflake schemas. Eight evolution operations are considered, covering insertion and deletion of dimensions, levels, dimension attributes, and measure attributes. For each operation, the formal semantics of the changes for star and snowflake schemas are given, and instance adaption and impact on existing queries are described. Finally, we compare the evolution properties of star and snowflake schemas, concluding that the star schema is considerably more robust towards schema changes than the snowflake schema.

Paper brief

Loading…

Cite this work

Citation unavailable for this work.

BibTeX RIS CSL-JSON

No public copy is stored for this record, so only the metadata is cited.

Citations in this library

Citation map →

Stored only when both papers are in the corpus — 36 citations exist upstream.

Cited by

2007Data Warehouse Evolution Framework.2005Metadata Management in a Multiversion Data Warehouse

Imported from OpenAlex (CC0) — nothing here is generated.