Schema Evolution

Managing and querying transaction-time databases under schema evolution

Authors: 
Moon, Hyun J.; Curino, Carlo A.; Deutsch, Alin; Hou, Chien-Yi; Zaniolo, Carlo
Year: 
2008
Venue: 
VLDB

The old problem of managing the history of database information is now made more urgent and complex by fast-spreading web information systems. Indeed, systems such as Wikipedia are faced with the challenge of managing the history of their databases in the face of intense database schema evolution. Our PRIMA system addresses this difficult problem by introducing two key pieces of new technology.

What-If Analysis for Data Warehouse Evolution

Authors: 
Papastefanatos, G.; Vassiliadis, P.; Simitsis, A.; Vassiliou, Y.
Year: 
2007
Venue: 
DaWaK 2007

In this paper, we deal with the problem of performing what-if analysis for changes that occur in the schema/structure of the data warehouse sources. We abstract software modules, queries, reports and views as (sequences of) queries in SQL enriched with functions. Queries and relations 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 indicates the way they are tuned to respond to it.

Data Reverse Engineering using System Dependency Graphs

Authors: 
Cleve, A; Henrard, J.; Hainaut, JL;
Year: 
2006
Venue: 
Proceedings of the 13th Working Conference on Reverse Engineering (WCRE 2006)

Data reverse engineering (DRE) is a complex and costly process that requires a deep understanding of large dataintensive software systems. This process can be made easier with the use of program understanding methods and tools. In this paper, we focus on the program slicing technique and we show how it can be adapted to support DRE. We present a DML-independent SDG construction approach involving the analysis of database operations as a first stage. We describe a tool based upon this approach and we report on two industrial DRE projects.

Wrapper-based evolution of legacy information systems

Authors: 
Thiran, P.; Hainaut, J.-L.; Houben, G.-J.; Benslimane, D.
Year: 
2006
Venue: 
TOSEM 2006, Vol. 15, Is. 4: 329-359

System evolution most often implies the integration of legacy components, such as databases, with newly developed ones, leading to mixed architectures that suffer from severe heterogeneity problems. For instance, incorporating a new program in a legacy database application can create an integrity mismatch, since the database model and the program data view can be quite different (e.g. standard file model versus OO model).

An Online Bibliography on Schema Evolution

Authors: 
Rahm, Erhard; Bernstein, Philip A.
Year: 
2006
Venue: 
Sigmod Record

We briefly motivate and present a new online bibliography on schema evolution, an area which has recently gained much interest in both research and practice.

Managing knowledge about information system evolution

Authors: 
Jarke, M; Rose, T
Year: 
1988
Venue: 
Proceedings of the 1988 ACM SIGMOD international conference

This paper describes the design and initial prototype implementation of a knowledge base management system (KBMS) for controlling database software development and maintenance. The KBMS employs a version of the conceptual modelling language CML to represent knowledge about the tool-aided development process of an information system from requirements analysis to conceptual design to implementation, together with the relationship of these system components to the real-world environment in which the information system is intended to function.

Syndicate content