Object-Relational Database Design Approaches: A Survey of Approaches and Techniques

Object-Relational Database Design Approaches: A Survey of Approaches and Techniques

연구 분야: Databases

학회: International Conference for Information and Communication Technologies

The primordial part of realizing a computer system is conceptual modelling, which has met with great success in relational database design using an ER model. Unfortunately, with the development of the computer field, relational databases confronted shortcomings in their applications and the object-relational model became used more and more. The tools of presenting conceptual modelling do not support all new concepts introduced by such models and the syntax of the SQL4 language. This paper aims to survey the previous works and various proposals on how to create rules for designing the object-relational (O-R) database to indicate their strengths and limitations. The paper provides a comprehensive explanation and evaluation of the existing approaches and the possibility of transferring all data semantics and relationships. This work demonstrates the importance and difficulty of these guidelines and discusses many previous works in this field. This paper confirms that modern technologies and new databases play an important role in the success of software design.