An Enhanced Framework for Object-Relational Database Design - An Experimental Study

Object-relational conceptual modeling tools do not support all new concepts available in SQL4. This study presents an enhanced empirical research framework for object-relational database design based on conceptual modeling. This paper describes a proposal for heuristic rules for designing an object-...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:2024 International Symposium of Systems, Advanced Technologies and Knowledge (ISSATK) s. 1 - 6
Hlavní autoři: Bohalfaya, Huda M., Elakeili, Salwa M., Abdelnabi, Esra A., Maatuk, Abdelsalam A.
Médium: Konferenční příspěvek
Jazyk:angličtina
Vydáno: IEEE 02.11.2024
Témata:
Data visualization
Database Design
Guidelines
Object-Relational Database Design
Proposals
Semantics
Software
Software design
Unified modeling language
Visual databases
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Popis
Shrnutí:Object-relational conceptual modeling tools do not support all new concepts available in SQL4. This study presents an enhanced empirical research framework for object-relational database design based on conceptual modeling. This paper describes a proposal for heuristic rules for designing an object-relational database and translating data and relationship semantics from the conceptual schema generated by a UML class diagram to its logical schema counterpart by SQL:2008. A set of rules has been proposed that help visualize and implement object-relational databases, allowing the user to create a script model of a database using SQL. The study explains the importance of these guidelines and gives a detailed explanation of the proposed rules with an illustrative example. The proposed method was evaluated by applying it to a case study and comparing the results with other methods and proposals. This study confirms that modern technologies and new databases play an important role in the success of software design, so it attempts to facilitate the design process and help software developers understand this type of database and save them time and effort.
DOI:10.1109/ISSATK62463.2024.10808665