AN APPROACH TO ANALYZING THE INFORMATION CONTENT OF EXISTING DATABASES

0
88

Authors: Danielle Boulanger, Prof. Salvatore T. March

Tags: 1989, conceptual modeling

Traditionally, application databases have bee n developed for efficiency of computer operations . The logical structure of the data is buried in the databas e schemas, application programs, and users ‘ and programmers’ minds. To manage information as a corporate resource th e logical data structures must be made explicit. In this wa y organizational databases can be conceptually integrated . The magnitude and complexity of corporate databases make s a manual approach to this task infeasible. We propose a computer aided approach. The approach is based o n extracting implicit functional dependencies from existin g database schemas and forming an Entity-Relationshi p representation . Where the semantics of the schema are unclear, rules are applied and additional input sought fro m the Data Administrator. Because of its widespread use i n production systems, we focus on CODASYL Networ k DBMSs in this paper . The approach also has applications in databases from one DBMS to another .

Read the full paper here: https://dl.acm.org/doi/pdf/10.1145/1017914.1017915