• Corpus ID: 18713344

A novel ER model to relational model transformation algorithm for semantically clear high quality database design

@article{Pieris2013ANE,
  title={A novel ER model to relational model transformation algorithm for semantically clear high quality database design},
  author={Dhammika Pieris},
  journal={ArXiv},
  year={2013},
  volume={abs/1306.6734}
}
  • D. Pieris
  • Published 28 June 2013
  • Computer Science
  • ArXiv
Conceptual modelling using the entity relationship (ER) model has been widely used for database design for a long period of time. However, studies indicate that creating a satisfactory relational model representation from an ER model is uncertain due to the insufficiencies both in the transformation methods used and in the relational model itself. In an effort to solve the issue the original ER notation has been modified, and accordingly, a new transformation algorithm has been developed. This… 

Figures and Tables from this paper

ER Model Partitioning: Towards Trustworthy Automated Systems Development
TLDR
The ongoing research aiming to create a proof will show how a given ER model can be partitioned into a unique set of segments and use it to represent the ER model itself.
Extending the ER Model to relational Model novel transformation Algorithm: transforming relationship Types among Subtypes
TLDR
One of the objectives of this paper is to use the rest of the algorithm as a supportive document for ongoing empirical evaluations of the new approach being conducted using the cognitive engagement method and with the participation of different segments of the field as respondents.

References

SHOWING 1-10 OF 10 REFERENCES
Modifying the Entity relationship modelling notation: towards high quality relational databases from better notated ER models
TLDR
This paper has adapted the original ER notation and developed a new transformation algorithm based on the existing one and presents the modified ER notation with an ER diagram drawnbased on the new notation.
Logical database design with ontologically clear entity relationship models
  • D. Pieris, J. Rajapakse
  • Computer Science
    2012 IEEE 6th International Conference on Information and Automation for Sustainability
  • 2012
TLDR
The preliminary results of this ongoing research study shows that the quality of relational model developed from ontologically clear conceptual model is superior to its ontologically unclear counterpart.
Conceptual Database Design: An Entity-Relationship Approach
TLDR
This chapter discusses Conceptual Design, Logical Design, and Design Tools for Database Design, as well as Joint Data and Functional Analysis, and Improving the Quality of a Database Schema.
A relational model of data for large shared data banks
TLDR
A model based on n-ary relations, a normal form for data base relations, and the concept of a universal data sublanguage are introduced and certain operations on relations are discussed and applied to the problems of redundancy and consistency in the user's model.
Guidelines for representing complex cardinality constraints in binary and ternary relationships
TLDR
A practical method to motivate the designer’s use of ternary relationships in a methodological framework and to preserve the associated semantics until the implementation phase of the database development method is discussed.
Fundamentals of Database Systems
From the Publisher: Fundamentals of Database Systems combines clear explanations of theory and design, broad coverage of models and real systems, and excellent examples with up-to-date introductions
Modifying the entity relationship modeling notation: towards high quality relational databases from better notated ER models. arXiv preprint arXiv:1306.5690
  • 2013
Fundamentals of Database Systems, 5th Edition
The entity-relationship model—toward a unified view of data
TLDR
A data model, called the entity-relationship model, is proposed that incorporates some of the important semantic information about the real world and can be used as a basis for unification of different views of data: the network model, the relational model, and the entity set model.
Accordingly, we have already created a reverse transformation algorithm, and in the future we will present it as well
  • Accordingly, we have already created a reverse transformation algorithm, and in the future we will present it as well