ScholarLens Back to search
2006•Computing LettersRequires access

Rules for Migrating from Entity Relationship (ER) Diagrams to Object Relationship (OR) Diagrams

Sikha Bagui

Open publisher page 1 citations

Abstract

In this paper, we provide detailed mapping rules (a methodology) to convert an ER schema into an object relationship (OR) schema. The mapping rules are presented in a manner that will keep as much of the semantics of the database intact, in order to smoothen the important step of data migration from an ER schema to an OR schema. This OR schema should also serve as a conceptual design tool for object-oriented data models, very much like the ER diagrams are a conceptual design tool for relational databases. Since we are mainly discussing the conversion from an ER model to an OR model, we are limiting the discussion in this paper to the structural aspects of the OR model.

About this research paper

What this paper is about

In this paper, we provide detailed mapping rules (a methodology) to convert an ER schema into an object relationship (OR) schema. The mapping rules are presented in a manner that will keep as much of the semantics of the database intact, in order to smoothen the important step of data migration from an ER schema to an OR schema. This OR schema should also serve as a conceptual design tool for object-oriented data models, very much like the ER diagrams are a conceptual design tool for relational databases. Since we are mainly discussing the conversion from an ER model to an OR model, we are limiting the discussion in this paper to the structural aspects of the OR model.

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

In this paper, we provide detailed mapping rules (a methodology) to convert an ER schema into an object relationship (OR) schema. The mapping rules are presented in a manner that will keep as much of the semantics of the database intact, in order to smoothen the important step of data migration from an ER schema to an OR schema. This OR schema should also serve as a conceptual design tool for object-oriented data models, very much like the ER diagrams are a conceptual design tool for relational databases. Since we are mainly discussing the conversion from an ER model to an OR model, we are limiting the discussion in this paper to the structural aspects of the OR model.

Key concepts: Conceptual schema, Semi-structured model, Entity–relationship model, Computer science, Schema (genetic algorithms), Database schema, Schema migration, Star schema

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Rules for Migrating from Entity Relationship (ER) Diagrams to Object Relationship (OR) Diagrams — Research Paper | ScholarLens