Thumbnail
Access Restriction
Open

Author Andersson, Martin
Source CiteSeerX
Content type Text
Publisher Springer
File Format PDF
Language English
Subject Domain (in DDC) Computer science, information & general works ♦ Data processing & computer science
Subject Keyword Distributed Computer ♦ Possible Key ♦ Entity Relationship Schema ♦ Relational Schema ♦ Data Manipulation Statement ♦ Telecommunication Domain ♦ Relational Dbms ♦ View Definition ♦ Link Table ♦ Reverse Engineering ♦ Selective Manner ♦ Information System ♦ Database Extension ♦ Join Condition ♦ Current Rapid Progress ♦ Rudimentary Information ♦ Possible Solution ♦ Relational Database ♦ Conceptual Schema
Description . This paper presents a method for extracting a conceptual schema from a relational database. The method is based on an analysis of data manipulation statements in the code of an application using a relational DBMS. Attributes representing references between tables in the relational schema, and possible keys are determined by an analysis of join conditions in queries and view definitions. Knowledge about which attributes link tables is used to investigate the database extension in a selective manner. When the keys cannot be unambiguously determined, possible solutions are generated by the system under guidance of the user. The approach makes it possible to efficiently construct a conceptual schema from only rudimentary information. 1 Introduction The current rapid progress in the telecommunications domain will allow geographically distributed computers to interact more closely than today. However, this evolution is slowed down by existing information systems (IS) based on old-fashione...
Educational Role Student ♦ Teacher
Age Range above 22 year
Educational Use Research
Education Level UG and PG ♦ Career/Technical Study
Learning Resource Type Article
Publisher Date 1994-01-01
Publisher Institution In Proc. of the 13th Int. Conference of the Entity Relationship Approach