Schema Evolution publication categorizer

HECATAEUS is an open-source software tool for enabling impact prediction, what-if analysis, and regulation of relational database schema evolution. We follow a graph theoretic approach and represent database schemas and database constructs, like queries and views, as graphs. Our tool enables the user to create hypothetical evolution events and examine their impact over the overall graph before these are actually enforced on it.

Recently, there are many e-commerce search engines that return information from Web databases. Unlike text search engines, these e-commerce search engines have more complicated user interfaces. Our aim is to construct automatically a natural query user interface that integrates a set of interfaces over a given domain of interest. For example, each airline company has a query interface for ticket reservation and our system can construct an integrated interface for all these companies. This will permit users to access information uniformly from multiple sources.

Many data integration solutions in the market today include tools for schema mapping, to help users visually relate elements of different schemas. Schema elements are connected with lines, which are interpreted as mappings, i.e. high-level logical expressions capturing the relationship between source and target data-sets; these are compiled into queries and programs that convert source-side data instances into target-side instances.

DEMO PAPER:

A `reasonable' minimal set of primitives for updating an object-oriented (O2) database schema is defined and the problems which need to be solved in order to obtain a usable schema update mechanism are shown. The distinction between structural and behavioral consistency for the O2 system is described in some detail and it is demonstrated how updates could be performed by invoking an interactive tool. Updates are classified in three categories. Each category is explained in detail.

An approach for evolutionary database design is presented which tries to remedy some of the shortcomings of previous design methods. The approach distinguishes clearly between a conceptual and a logical database design. A conceptual schema models the relevant aspects of reality. A logical schema describes the structure of the database as generic tables, and it reflects the design decisions taken to map the objects of the conceptual schema into the generic tables.

Telecom Databases need very high availability for
both read and write transactions. Thus it is desired that
not even schema changes are allowed to block any type
of transactions. We show in this paper a method to handle
schema changes which is based on a transaction oriented
change with the aid of triggers. The old and the
new schema can be used concurrently so it is never necessary
to block any transactions.
A nice feature of the method presented in this paper
is that it is easy to integrate into an already existing
DBMS.
This functionality is rarely, if ever, found in neither

Object-oriented database systems (OODBMS) offer powerful modeling concepts as required by advanced application domains like CAD/CAM/CAE or office automation. Typical applications have to handle large and complex structured objects which frequently change their value and their structure. As the structure is described in the schema of the database, support for schema evolution is a highly required feature. Therefore, a set of schema update primitives must be provided which can be used to perform the required changes, even in the presence of populated databases and running applications.

In this paper we describe a new approach to data integration which subsumes the previous approaches of local as view (LAV) and global as view (GAV). Our method, which we term both as view (BAV), is based on the use of reversible schema transformation sequences. We show how LAV and GAV view definitions can be fully derived from BAV schema transformation sequences, and how BAV transformation sequences may be partially derived from LAV or GAV view definitions.

Merging and coalescing data from multiple and diverse
sources into different data formats continues to be an important
problem in modern information systems. Schema
Matching, the process of matching elements of a source
schema with elements of a target schema, and Schema Mapping,
the process of creating a query that maps between two
disparate schemas, are at the heart of data integration systems.
We demonstrate Clio, a semi-automatic schema mapping
tool developed at the IBM Almaden Research Center.
In this demonstration we showcase Clio’s mapping engine

The need to transform data between heterogeneous databases arises from a number of critical tasks in data management. These tasks are complicated by schema evolution in the underlying databases and by the presence of non-standard database constraints. We describe a declarative language called WOL (Well-founded Object Logic) for specifying such transformations, and its implementation in a system called Morphase (an “enzyme” for morphing data).