On the Migration of Relational Schemas and Data to Object-Oriented Database Systems, Andreas Behm and Andreas Geppert and Klaus R. Dittrich
Available as
compressed postscript.
@InProceedings{ behm.geppert.ea:on,
author = {Andreas Behm and Andreas Geppert and Klaus R. Dittrich},
title = {On the Migration of Relational Schemas and Data to
Object-Oriented Database Systems},
booktitle = {Proc. 5th International Conference on Re-Technologies for
Information Systems},
publisher = {Oesterreichische Computer Gesellschaft},
year = {1997},
editor = {J. Györkös and M. Krisper and H.C. Mayr},
pages = {13-33},
address = {Klagenfurt, Austria},
month = {December},
url = {ftp://ftp.ifi.unizh.ch/pub/techreports/TR-97/ifi-97.10.ps.gz}
,
abstract = {Many organizations have collected large volumes of data
which are often stored in relational databases. Now that
object-oriented database management systems (OODBMSs) are
becoming mature, many organizations also want to benefit
from object-oriented technology in general and OODBMSs in
particular. One general approach to migrate to object
technology is to divide the process into two phases, where
the first one transforms the relational into an
object-oriented schema and the second one migrates the data
into the object-oriented database system. Our approach
differs from comparable approaches because it provides
assistance in both phases, while other work considers only
the first phase. In the first phase we use transformation
rules to construct an object-oriented schema which is
semantically equivalent to the relational schema. In the
second phase, the schema transformation information is used
to generate programs that migrate the relational data into
an object-oriented database. The concepts of both, schema
transformation and data migration are implemented using O2
as the OODBMS.},
keywords = {OODBMS, Migration, Schema Transformation, Reengineering},
class = {Database_Migration Re-Design Alteration }
}
Inverse Wrappers for Legacy Information Systems Migration, Henrard, Jean and Cl\`eve, Anthony and Hainaut, Jean-Luc
Available as
hypertext.
@InProceedings{ henrard.cleve.ea:inverse,
author = {Henrard, Jean and Cl\`eve, Anthony and Hainaut, Jean-Luc},
title = {Inverse Wrappers for Legacy Information Systems
Migration},
booktitle = {Wrapper Techniques for Legacy Database ({WRAP}'04)},
pages = {30-43},
year = {2004},
editor = {Thiran, Philippe and van den Heuvel, Willem-Jan},
volume = {04-34},
series = {CS Report},
publisher = {Technische Universiteit Eindhoven},
abstract = {The paper studies some problems that arise when a
technology change induces the migration of a data-centered
application. In particular, it addresses the difficult
problem of migrating application programs from a legacy
data manager, such as a COBOL file system, to a modern
DBMS, such as a relational database management system. The
approach suggested in this paper relies on the concept of
inverse wrappers, that is, wrappers that simulate the
legacy API on top of the new database. This architecture
allows (1) the design of a fully normalized database rid of
the anomalies of the legacy data, (2) future programs to be
developed on a sound basis and (3) legacy programs to work
on the new database with minimum transformation, and
therefore at low cost. The paper describes the components
of this architecture, a methodology to design them and a
CASE tool that automates their generation.},
keywords = {wrapper, migration, database reverse engineering, CASE},
url = {http://www.fundp.ac.be/recherche/publications/fr/50552.html}
,
class = {Data_Reverse_Engineering Reverse_Engineering_Tools
Source-to-Source-Translation Database_Migration}
}
Strategies for Data Reengineering, Henrard, Jean and Hick, Jean-Marc and Thiran, Philippe and Hainaut, Jean-Luc
Available as
hypertext.
@InProceedings{ henrard.hick.ea:strategies,
author = {Henrard, Jean and Hick, Jean-Marc and Thiran, Philippe and
Hainaut, Jean-Luc},
title = {Strategies for Data Reengineering},
booktitle = {Proc. of the 9th Working Conference on Reverse
Engineering},
year = {2002},
publisher = {IEEE Computer Society Press},
keywords = {reengineering, migration, database, reverse, engineering,
application},
abstract = {This paper describes and analyzes a serie of strategies to
migrate data-intensive applications from a legacy data
management system to a modern DMS. Considering two ways to
migrate the data and three ways to propagate the
corresponding perturbation to the program code, the paper
identifies six reference strategies that provide different
levels of quality and induce different costs. Three of them
are discussed in detail and illustrated by the conversion
of COBOL files into a SQL database.},
url = {http://www.fundp.ac.be/recherche/publications/fr/40462.html}
,
class = {Data_Reverse_Engineering Reverse_Engineering_Tools
Reengineering_in_General Database_Migration}
}
Design Recovery of Legacy Database Applications based on Possibilistic Reasoning, Jens H. Jahnke and Melanie Heitbreder
Available as
hypertext.
@InProceedings{ jahnke.heitbreder:design,
author = {Jens H. Jahnke and Melanie Heitbreder},
title = {Design Recovery of Legacy Database Applications based on
Possibilistic Reasoning},
booktitle = {Proceedings of 7th IEEE International Conference of Fuzzy
Systems (FUZZ'98)},
publisher = {IEEE Computer Society},
year = {1998},
month = {May},
url = {http://www.uni-paderborn.de/cs/jahnke.html},
abstract = {Industrial database applications often evolve over three
or more generations of developers, cover several hundred
thousand lines of code and maintain a vast amount of data.
A rapidly growing number of companies face the problem that
they have to adapt or modernise such existing legacy
database applications (LDA) in order to keep up with
emerging requirements. The documentation of such LDAs is
often obsolete as they have been developed over several
generations of programmers. This paper presents an
application of possibilistic reasoning to infer the
semantic information that is necessary to recover the
conceptual design of an LDA. A dedicated, graphical
language (called Generic Fuzzy Reasoning Nets) is
introduced to specify and customise the applied reverse
engineering process. The actual reasoning process is
performed by a nonmonotonic inference engine based on fuzzy
petri nets which supports lazy execution of expensive
analysis operations.},
keywords = {data reverse engineering, expert system, uncertain
reasoning, legacy database},
class = {Extracting_Business_Rules Software_Reverse_Engineering
Database_Migration Reverse_Design Re-Design
Process_Models_for_Reverse_Design Alteration }
}
A Design Environment for Migrating Relational to Object-Oriented Database Systems, J.-H. Jahnke and W. Schäfer and A. Zündorf
@InProceedings{ jahnke.schäfer.ea:design,
author = {J.-H. Jahnke and W. Schäfer and A. Zündorf},
title = {A Design Environment for Migrating Relational to
Object-Oriented Database Systems},
booktitle = {Proceedings of the International Conference on Software
Maintenance ~1996},
publisher = {IEEE Computer Society Press},
year = {1996},
abstract = {Object-oriented technology has become mature enough to
satisfy many new requirements coming from areas like
computer-aided design (CAD) computer-integrated
manufacturing (CIM) or software engineering (SE). However a
competetive information management infrastructure often
demands to merge data from CAD- CIM- or SE-systems with
business data stored in a relational system. In addition
complex dependencies between those data stored in the
different systems might exist and should be maintained. One
approach for seamless integration of object-oriented and
relational systems is to migrate the data (and the
corresponding schema) from a relational to an
object-oriented system. In this paper we describe an
integrated design environment that supports the migration
process and overcomes major drawbacks of comparable
approaches.},
class = {Alteration, Re-Design, Database_Migration }
}
Generic Fuzzy Reasoning Nets as a Basis for Reverse Engineering Relational Database Applications, J.-H. Jahnke and W. Schäfer and A. Zündorf
@Book{ jahnke.schäfer.ea:generic,
author = {J.-H. Jahnke and W. Schäfer and A. Zündorf},
title = {Generic Fuzzy Reasoning Nets as a Basis for Reverse
Engineering Relational Database Applications},
booktitle = {Proceedings of the European Conference on Software
Engineering 1997},
publisher = {Springer Verlag},
year = {1997},
month = {September},
abstract = {Object-oriented technology has become mature enough to
satisfy many new requirements coming from areas like
computer-aided design (CAD) computer-integrated
manufacturing (CIM) or software engineering (SE). However a
competitive information management infrastructure often
demands to merge data from CAD- CIM- or SE-systems with
business data stored in a relational system. One approach
for seamless integration of object- oriented and relational
systems is to migrate from a relational to an object-
oriented system. The first step in this migration process
is reverse engineering of the legacy database. In this
paper we propose a new graphical and executable language
called Generic Fuzzy Reasoning Nets for modelling and
applying reverse engineering knowledge. In particular this
language enables to define and analyse fuzzy knowledge
which is usually all what is available when an existing
database schema has to be reverse engineered into an
object-oriented one. The analysis process is based on
executing a fuzzy petri net which is parameterized with the
fuzzy knowledge about a concrete data base application.},
class = {Alteration, Re-Design, Database_Migration }
}
Managing Uncertainty and Inconsistency in Database Reengineering Processes, Jens-Holger Jahnke
Available as .
@PhDThesis{ jahnke:managing,
author = {Jens-Holger Jahnke},
title = {Managing Uncertainty and Inconsistency in Database
Reengineering Processes},
school = {University of Paderborn, Department of Mathematics and
Computer Science},
year = {1999},
address = {33095 Paderborn, Germany},
month = {August},
abstract = {This dissertation tackles one of the most urgent problems
in today's information technology, namely the renovation
and migration of legacy information systems to modern
platforms and net-centric architectures. In this context,
several methods, tools, and processes have been proposed to
support reengineering and modernizations of legacy database
applications. This can be a complex task because many
legacy databases have grown over several generations of
programmers and lack a sufficient documentation.
Computer-aided reengineering methods and processes have a
great potential to reduce the complexity and risks involved
in database design recovery and migration projects. Still,
current reengineering tools are hardly adopted for
practical problems in industry because they often make
idealistic assumptions about the structure of legacy
systems and the characteristics of reengineering processes.
The goal of this thesis is to provide concepts and
techniques to overcome these severe limitations. In
particular, our focus is on developing mechanisms to manage
uncertainty and inconsistency in computer-aided databases
reengineering processes. In practice, uncertain knowledge
plays an important role in activities aiming to recover
conceptual design documents for large idiosyncratic
implementation structures. This fact is neglected in
current database reengineering methods and tools. In this
dissertation, we identify and extend a theory that provides
a suitable basis to deal with uncertain reengineering
knowledge and allows to implement practical tools and
environments to support reengineering processes. The
requirement for consistency management considers the fact
that it is unrealistic to presume that database
reengineering processes can be executed in a number of
sequential phases or steps without iterations. In practice,
larger reengineering projects comprise many process
iterations due to various reasons like incomplete knowledge
about legacy implementation structures or necessary
"on-the-fly" modifications of the legacy system. Detecting
and removing inconsistencies caused by such iterations
significantly increase costs and durations of current
reengineering projects. In this thesis, we employ graph
transformation theory to develop mechanisms which allow to
detect and eliminate inconsistencies between legacy schema
implementations and their abstract representation,
automatically. Our results have been implemented in the
database reengineering environment Varlet and evaluated
with an industrial project. They are suitable to complement
many existing approaches in the domain of information
system reengineering and migration. As an example, we
describe the integration of Varlet with an existing
middleware product for data integration.},
class = {Using_graphs Database_Migration Re-Design
Data_Reverse_Engineering Alteration
Software_Reverse_Engineering
Intermediate_Representations_of_Source_Code },
url = {http://www.csr.uvic.ca/~jens/Docs/thesis.pdf}
}
Towards the reverse engineering of denormalized relational databases, J-M. Petit and F. Toumani and J. Boulicaut and J. Kouloumdjian
@InProceedings{ petit.toumani.ea:towards,
author = {J-M. Petit and F. Toumani and J. Boulicaut and J.
Kouloumdjian},
title = {Towards the reverse engineering of denormalized relational
databases},
booktitle = {Proc. 12th International Conference on Data Engineering},
publisher = {S. Su},
year = {1996},
editor = {IEEE Computer Society},
pages = {218-227},
address = {New Orleans},
month = {Feb},
class = {Database_Migration Re-Design Alteration }
}