Istituto di Scienza e Tecnologie dell'Informazione     
Signore O., Loffredo M., Gregori M., Cima M. Reconstruction of ER schema from database applications: a cognitive approach. In: ER '94 - Thirteenth International Conference on the Entity-Relationship Approach (Manchester, December 13-16 1994). Proceedings, pp. 387 - 402. (Lecture Notes in Computer Science, vol. 881). Springer Verlag, 1994.
In the Forward Engineering phase, the designer modifies the database conceptual schema and produces a logical and physical schema containing some "spurious" relations dictated by design tricks and DBMS's limitations. Therefore the rebuilding of the database conceptual schema from the physical database structure is a fundamental issue in the re-engineering and design recovery processes. Some proposed methodologies try to get the necessary information from the schema and from the content of the database, paying little attention to the analysis of the usage that the programs make of the data, while this can be thought as the most reliable source of information. In this paper we present an approach to the reverse engineering based on the identification of schema, primary key, SQL and procedural indicators that lead to the assertion of Prolog facts and, by some heuristic rules, to the rebuilding of the conceptual schema.
Subject Design of presentations
H.5.2 User Interfaces

Icona documento 1) Download Document PDF

Icona documento Open access Icona documento Restricted Icona documento Private


Per ulteriori informazioni, contattare: Librarian http://puma.isti.cnr.it

Valid HTML 4.0 Transitional