Este trabalho apresenta o desenvolvimento de um Framework de persistência que utiliza banco de dados objeto-relacional como mecanismo de persistência. Tendo por objetivo usar os conceitos de orientação a objetos descritos na norma SQL:2008, conceitos como: objeto (atributos e métodos), herança, agregação, composição, referências (REF) e estruturas multivaloradas (arrays e multiset). Para tanto se desenvolveu e formalizou (XSD) um arquivo XML que representa um esquema de objetos através da norma SQL:2008. Da mesma forma definiu-se um conjunto de anotações Java, com o intuito de facilitar a utilização e configuração do Framework, o qual é chamado de O-ODBM (Object Object-Relational Database Management). / Persistent Frameworks have been used to aid developers, managing all access to DBMS. This kind of tool maps objects from OO applications to relational databases. Besides, allow developers to persist objects without solid knowledge about DBMSs and specific languages, making better the developers productivity, mainly when different DBMS is used. On the other hands, since 1999 the SQL specification has introduced new features to manipulate objects in relational databases which since then has been called Object-Relational Database (ORDB). At present, many DBMS offer resources to manipulate objects in database, but the most of the application developers just map class to relations tables, failing to exploit the strength of O-R model. The lack of the tools that aid the project of database contributes to this situation. Considering the vantages of use of the persistent frameworks and the ORDBs, this article introduces the O-ODM (Object-Object Database Mapping) a persistent framework for relational object databases.

Este trabalho apresenta o desenvolvimento de um Framework de persistência que utiliza banco de dados objeto-relacional como mecanismo de persistência. Tendo por objetivo usar os conceitos de orientação a objetos descritos na norma SQL:2008, conceitos como: objeto (atributos e métodos), herança, agregação, composição, referências (REF) e estruturas multivaloradas (arrays e multiset). Para tanto se desenvolveu e formalizou (XSD) um arquivo XML que representa um esquema de objetos através da norma SQL:2008. Da mesma forma definiu-se um conjunto de anotações Java, com o intuito de facilitar a utilização e configuração do Framework, o qual é chamado de O-ODBM (Object Object-Relational Database Management). / Persistent Frameworks have been used to aid developers, managing all access to DBMS. This kind of tool maps objects from OO applications to relational databases. Besides, allow developers to persist objects without solid knowledge about DBMSs and specific languages, making better the developers productivity, mainly when different DBMS is used. On the other hands, since 1999 the SQL specification has introduced new features to manipulate objects in relational databases which since then has been called Object-Relational Database (ORDB). At present, many DBMS offer resources to manipulate objects in database, but the most of the application developers just map class to relations tables, failing to exploit the strength of O-R model. The lack of the tools that aid the project of database contributes to this situation. Considering the vantages of use of the persistent frameworks and the ORDBs, this article introduces the O-ODM (Object-Object Database Mapping) a persistent framework for relational object databases.

This diploma work deals with design and implementation of the database neutral object-relational (OR) layer in C++ language over inherited database. The goal is to create the layer to encase the access to database from the application layer. Suggested layer will stem from the object-relation mapping technology, which is currently available for many object-programming language, such as C#, Java or Visual Basic. The work consists of three main parts. The forepart is focused on clearing object-relation mapping technology. It briefly overviews differences in capabilities and levels of implementation of various approaches. The next part describes significant properties of databases considered as back-ends for data storage in the project. The aim of this part is to present enough information to support database neutral design of the OR layer. The rest of the document deals with design and implementation of OR layer for the considered environment followed by the summarization of results and overall evaluational.