Thursday 28th of March 2024
 

Fundamentals for the Automation of Object-Relational Database Design



In the market there is a wide amount of CASE tools for the design of relational databases. Object-relational database management system (ORDBMS) emerged at the end of the 90s to incorporate the object technology into the relational databases, allowing the treatment of more complex data and relationships than its predecessor. The design for this database model is not straightforward. Most of the works proposed in the literature fail because they do not provide consistent transformation formalization such that the mappings from the conceptual model to the logical schema can be automated to generate an ORDB design toolkit. This is one of the goals of this paper. For this purpose, UML class diagram metamodel for the conceptual design and SQL:2003 standard metamodel for logical schemas are considered. A characterization of the components involved in the ORDB design is made in order to propose mapping rules that can be further automated. The architecture of a CASE tool prototype is presented. Model Driven Architecture for software design and XML for the model definitions and transformations are employed.

Keywords: ORDBMS, SQL 2003, UML, database design, MDA, XML

Download Full-Text

IJCSI Published Papers Indexed By:

 

 

 

 
+++
About IJCSI

IJCSI is a refereed open access international journal for scientific papers dealing in all areas of computer science research...

Learn more »
Join Us
FAQs

Read the most frequently asked questions about IJCSI.

Frequently Asked Questions (FAQs) »
Get in touch

Phone: +230 911 5482
Email: info@ijcsi.org

More contact details »