New Approach for the Modeling and the Implementation of the Object-Relational Databases

Conception is the primordial part in the realization of a computer system. Several tools have been used to help inventors to describe their software. These tools knew a big success in the relational databases domain since they permit to generate SQL script modeling the database from an Entity/Association model. However, with the evolution of the computer domain, the relational databases proved their limits and object-relational model became used more and more. Tools of present conception don't support all new concepts introduced by this model and the syntax of the SQL3 language. We propose in this paper a tool of help to the conception and implementation of object-relational databases called «NAVIGTOOLS" that allows the user to generate script modeling its database in SQL3 language. This tool bases itself on the Entity/Association and navigational model for modeling the object-relational databases.

Authors:

• Amel Grissa-Touzi
• Minyar Sassi

Keywords:

• Abstract Data Table
• Navigational model
• Objectrelational databases
• References.

References:

[1] P. Daehne, and P. Leutert, "Object and relational models", High School
specialized of Switzerland Occidental, November 2001.
[2] A. Gamache, "Book on the databases ", Department of data processing
and software genius, University Laval.
[3] E. Meylan, "Theoretical introduction to the object-relational model",
High School specialized of Switzerland Occidental, June 2001.
[4] C. SOUTOU, "Of UML in SQL" , Eyrolles,2002.
[5] T. Quatrani, "Modélisation sur Rational Rose", Eyrolles, 2000.
[6] G. Godin, "Database management systems by example", Montréal,
Canada, 2003.
[7] C. SOUTOU,"Object - relational under Oracle 8. Modelling with UML
" Eyrolles, 1999.
[8] R.G.G. Catell., "Object-Oriented Data Management: Object-Oriented
and Extended Relational Database Sytems", Addison-Wesley
Publishing, Inc., 1994.
[9] M. Makowski, "A structured modeling technology", European Journal of
Operational Research, Vol. 166, Issue 3, 1 November 2005.