Design Metrics for Data Warehouse Evolution

Authors:
George Papastefanatos;Panos Vassiliadis;Alkis Simitsis;Yannis Vassiliou
Affiliations:
National Technical University of Athens, Athens, Hellas;University of Ioannina, Ioannina, Hellas;Stanford University and HP Labs, California, USA;National Technical University of Athens, Athens, Hellas
Venue:
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Year:
2008

Citing 11
Cited 6

Adapting materialized views after redefinitions: techniques and a performance study

Information Systems - Data warehousing
Schema evolution in data warehouses

Knowledge and Information Systems
On Schema Evolution in Multidimensional Databases

DaWaK '99 Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery
Defining Metrics for Conceptual Schema Evolution

FoMLaDO/DEMM 2000 Selected papers from the 9th International Workshop on Foundations of Models and Languages for Data and Objects, Database Schema Evolution and Meta-Modeling
The CVS Algorithm for View Synchronization in Evolvable Large-Scale Information Systems

EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Why is the snowflake schema a good data warehouse design?

Information Systems
Measuring Graph Abstractions of Software: An Information-Theory Approach

METRICS '02 Proceedings of the 8th International Symposium on Software Metrics
Schema versioning in data warehouses: enabling cross-version querying via schema augmentation

Data & Knowledge Engineering - Special issue: WIDM 2004
Hecataeus: A What-If Analysis Tool for Database Schema Evolution

CSMR '08 Proceedings of the 2008 12th European Conference on Software Maintenance and Reengineering
A set of quality indicators and their corresponding metrics for conceptual models of data warehouses

DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
Evolution of data warehouses' optimization: a workload perspective

DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery

Visual Modelling of Data Warehousing Flows with UML Profiles

DaWaK '09 Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery
Toward Formal Semantics for Data and Schema Evolution in Data Stream Management Systems

ER '09 Proceedings of the ER 2009 Workshops (CoMoL, ETheCoM, FP-UML, MOST-ONISW, QoIS, RIGiM, SeCoGIS) on Advances in Conceptual Modeling - Challenging Perspectives
A family of experiments to validate measures for UML activity diagrams of ETL processes in data warehouses

Information and Software Technology
Schema design alternatives for multi-granular data warehousing

DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
Data Warehouse Testing

International Journal of Data Warehousing and Mining
A BPMN-Based Design and Maintenance Framework for ETL Processes

International Journal of Data Warehousing and Mining

Quantified Score

Hi-index	0.00

Visualization

Abstract

During data warehouse design, the designer frequently encounters the problem of choosing among different alternatives for the same design construct. The behavior of the chosen design in the presence of evolution events is an important parameter for this choice. This paper proposes metrics to assess the quality of the warehouse design from the viewpoint of evolution. We employ a graph-based model to uniformly abstract relations and software modules, like queries, views, reports, and ETL activities. We annotate the warehouse graph with policies for the management of evolution events. The proposed metrics are based on graph-theoretic properties of the warehouse graph to assess the sensi tivity of the graph to a set of possible events. We evaluate our metrics with experiments over alternative configurations of the same warehouse schema.