A method for transforming relational schemas into conceptual schemas
- 17 December 2002
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 190-201
- https://doi.org/10.1109/icde.1994.283030
Abstract
A major problem with currently existing database systems is that there often does not exist a conceptual understanding of the data. Such an understanding can be obtained by describing the data using a semantic data model, such as the ER model. Consequently, there is a need for methods that translate a schema in a traditional data model into a conceptual schema. We present a method for translating a schema in the relational model into a schema in a conceptual model. We also show that the schema produced has the same information capacity as the original schema. The conceptual model used is a formalization of an extended ER model, which also includes the subtype concept.Keywords
This publication has 7 references indexed in Scilit:
- Semantic enrichment of database schemes: an object oriented approachPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2002
- Implementation and critique of an algorithm which maps a relational database to a conceptual modelPublished by Springer Nature ,1991
- Identifying extended entity-relationship object structures in relational schemasIEEE Transactions on Software Engineering, 1990
- A personal chronicle: creating better information systems, with some guiding principlesIEEE Transactions on Knowledge and Data Engineering, 1989
- On Domain Independent DatabasesPublished by Elsevier ,1988
- Relative Information Capacity of Simple Relational Database SchemataSIAM Journal on Computing, 1986
- Logic and Databases: A Deductive ApproachACM Computing Surveys, 1984