Abstract:Relational databases play a central role in many information systems. Their schema contains structural (e.g. tables and columns) and behavioral (e.g. stored procedures or views) entity descriptions. Then, just like for ``normal'' software, changes in legislation, offered functionalities, or functional contexts, impose to evolve databases and their schemas. But in some scenarios, it is not so easy to deconstruct a wished evolution of the schema into a precise sequence of operations. Changing a database schema may impose manually dropping and recreating dependent entities, or manually searching for dependencies in stored procedures. This is important because getting even the order of application of the operators can be difficult and have profound consequences. This meta-model allows us to compute the impact of planned changes and recommend additional changes that will ensure that the RDBMS constraints are always verified. The recommendations can then be compiled into a valid SQL patch actually updating the database schema in an orderly way. We replicated a past evolution showing that, without detailed knowledge of the database, we could perform the same change in 75\% less time than the expert database architect. We also exemplify the use of our approach on other planned changes.

Research on Dynamic Schema Modification in ORDBMS

Implementation of Object Component for Improving ONet-object Database Management System

Schema Optimization and Conflict Mechanism in Relational Database System Migration

A Hybrid Strategy to Construct Scientific Instrument Ontology from Relational Database Model

A Dynamic O/R Mapping Framework and Its Implementation

Toward Programmable Strategy for Co-existence of Relational Schemes.

A Study on TGIS Based on Dynamic Multilevel Base State with Amendments

ADO: An Active Distributed Object-Oriented Database Model

Domain knowledge resource management based on sub-ontology

Data Dependence Analysis in Presence of Inheritance and Polymorphism

Research on Dynamic Modeling of Multi-body Dynamics Simulation Based on Inheritance and Transformation

Toward Co-existing Database Schemas based on Bidirectional Transformation

A Semantic Mapping System for Bridging the Gap between Relational Database and Semantic Web

Research on deductive object-oriented database systems

Automatic Recommendations for Evolving Relational Databases Schema

Implementation of Schema Management in Step Based Object-Oriented Engineering Database Management System

AN OBJECT-RELATIONAL IFC STORAGE MODEL BASED ON ORACLE DATABASE

Algorithm design based on hierarchical model database

Research on Spatio-Temporal Data Management Based on Object Relational Database

Algebraic Meta-structure Handling of Huge Database Schemata

Compound Schema Registry