Mapping Considerations in the Design of Schemas for the Relational Model

Sabah Al-Fedaghi, Peter Scheuermann

Research output: Contribution to journalArticlepeer-review

7 Scopus citations

Abstract

The typical design process for the relational database model develops the conceptual schema and each of the external schemasseparately and independently from each other. This paper proposes a new design methodology that constructs the conceptual schema in such a way that overlappings among external schemas are reflected. If the overlappings of external schemas do not produce transitivity at the conceptual level, then with our design method, the relations in the external schemas can be realized as a join over independent components. Thus, a one-to-one function can be defined for the mapping between tuples in the external schemas to tuples in the conceptual schema. If transitivity is produced, then we show that no such function is possible and a new technique is introduced to handle this special case.

Original languageEnglish (US)
Pages (from-to)99-111
Number of pages13
JournalIEEE Transactions on Software Engineering
VolumeSE-7
Issue number1
DOIs
StatePublished - Jan 1981

Keywords

  • Conceptual schema external schema
  • functional de`
  • interferences
  • logical database design
  • mapping functions
  • pendencies independent components
  • relational database mode

ASJC Scopus subject areas

  • Software

Cite this