| Title |
Išsamios loginės schemos atstatymas iš liktinių informacijos sistemų / |
| Translation of Title |
Recovery of complete logical schema from legacy information systems. |
| Authors |
Truncaitė, Anna ; Paulavičius, Sigitas |
| Full Text |
|
| Pages |
129 |
| Keywords [eng] |
database reverse engineering ; logical schema ; legacy information system ; implicit constructs ; joined entities |
| Abstract [eng] |
In order for maintenance or migration of a legacy system to be efficient and safe, complete documentation is required, which might be non-existent, lost or out-dated. Recovery of this information from legacy system itself is possible through the proceses of reverse engineering. This work is concerned with reverse data engineering to recover of complete logical schema by first extracting explicitly declared database structure and constraints and then completing it by extarcting implicit constructs and constraints from source code and data analysis. The methology described in this work is sought to be simple to use and oriented mainly towards data migration efforts, which was found to be the field where reverse data engineering is used the most. The methodology is concerned with extraction of complete logical schema, although it is not always required for data migration proccess in its full extent. An issue of discovery and separation of joined entities is adressed in this work. Joined entity can be defined as multiple conceptual entities that were joined into single database table due to certain external limitations on number of entities. This situation is not rare in legacy systems especially and is not found to be adressed by any other method of database reverse engineering. |
| Type |
Master thesis |
| Language |
Lithuanian |
| Publication date |
2009 |
