Abstract
This paper describes an algorithmic method for transforming a relational database schema to a binary-relationship one. The source schema may consist of relations that are at any level of normalization, and the designer may add semantic information on the source schema, such as the definition of candidate keys, foreign keys, functional dependencies of various types, multi-valued dependencies, many-to-many constraints, inclusion dependencies, and others. Based on this information, the multi-stage transformation algorithm applies mapping rules to generate object-types, binary-relationships and constraints in the target conceptual schema. The method is implemented as a PC-based tool, utilizing Ingres, SQL and C, and is part of a comprehensive database design tool for both forward and reverse engineering.
| Original language | English |
|---|---|
| Pages (from-to) | 293-315 |
| Number of pages | 23 |
| Journal | Data and Knowledge Engineering |
| Volume | 10 |
| Issue number | 3 |
| DOIs | |
| State | Published - 1 Jan 1993 |
Keywords
- CASE tools
- Database reverse engineering
- binary-relationship model
- conceptual schema
- database design
- re-engineering
- relational model
- schema transformation
- software engineering
ASJC Scopus subject areas
- Information Systems and Management