Skip to Main content Skip to Navigation
Conference papers

DBA Companion: a Tool for Database Analysis

Abstract : Extracting information about data semantics from existing databases is essential in any re-engineering process. Several sources of information can be relevant for tackling this task, e.g. physical schema, database extension or application programs. In this paper, we present a tool called DBA Companion which can be an help to deal with the understanding of existing relational databases. The tool is based on the notion of agree sets. Agree sets allow to devise a framework dealing with a wide range of design problems. Agree sets are seen as a common data centric step of several algorithms useful for database analysis. These algorithms are: functional and approximate dependency inference, minimal key inference, example relation generation and normal form tests. We show how the framework is integrated in a tool which can provide some help to database administrators or analysts. We consider two problems: functional dependency inference and approximate functional dependency inference.
Document type :
Conference papers
Complete list of metadatas

https://hal.archives-ouvertes.fr/hal-00286629
Contributor : Stéphane Lopes <>
Submitted on : Tuesday, June 10, 2008 - 10:44:43 AM
Last modification on : Monday, January 20, 2020 - 12:12:05 PM

Identifiers

  • HAL Id : hal-00286629, version 1

Citation

Stéphane Lopes. DBA Companion: a Tool for Database Analysis. International Conference on Reverse Engineering for Information Systems (RETIS), 2001, Lyon, France. ⟨hal-00286629⟩

Share

Metrics

Record views

155