References of Database_Migration

    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 }
    }
    

koschke@informatik.uni-stuttgart.de (Feedback).
Copyright © 1998-2000 University of Stuttgart, Germany. $Revision: 1.5 $
Date: Sun Nov 22 00:23:40 CET 2009