Semantics and implementation of schema evolution in object-oriented databases
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
Evolution and change in data management — issues and directions
ACM SIGMOD Record
A vision for management of complex models
ACM SIGMOD Record
Adapting materialized views after redefinitions: techniques and a performance study
Information Systems - Data warehousing
Schema evolution in data warehouses
Knowledge and Information Systems
A Framework for Schema Updates In An Object-Oriented Database System
Proceedings of the Seventh International Conference on Data Engineering
A Transparent Object-Oriented Schema Change Approach Using View Evolution
ICDE '95 Proceedings of the Eleventh International Conference on Data Engineering
On Schema Evolution in Multidimensional Databases
DaWaK '99 Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery
A Logical Model for Data Warehouse Design and Evolution
DaWaK 2000 Proceedings of the Second International Conference on Data Warehousing and Knowledge Discovery
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
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
Preserving mapping consistency under schema changes
The VLDB Journal — The International Journal on Very Large Data Bases
Hecataeus: A What-If Analysis Tool for Database Schema Evolution
CSMR '08 Proceedings of the 2008 12th European Conference on Software Maintenance and Reengineering
Data warehouse scenarios for model management
ER'00 Proceedings of the 19th international conference on Conceptual modeling
Graph-based modeling of ETL activities with multi-level transformations and updates
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
What-if analysis for data warehouse evolution
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
E-ETL: framework for managing evolving etl processes
Proceedings of the 4th workshop on Workshop for Ph.D. students in information & knowledge management
ORE: an iterative approach to the design and evolution of multi-dimensional schemas
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
A BPMN-Based Design and Maintenance Framework for ETL Processes
International Journal of Data Warehousing and Mining
Hi-index | 0.00 |
In this paper, we discuss the problem of performing impact prediction for changes that occur in the schema/structure of the data warehouse sources. We abstract Extract-Transform-Load (ETL) activities as queries and sequences of views. ETL activities and its sources are uniformly modeled as a graph that is annotated with policies for the management of evolution events. Given a change at an element of the graph, our method detects the parts of the graph that are affected by this change and highlights the way they are tuned to respond to it. For many cases of ETL source evolution, we present rules so that both syntactical and semantic correctness of activities are retained. Finally, we experiment with the evaluation of our approach over real-world ETL workflows used in the Greek public sector.