Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

evaluating relationship Implementations performance in Object-relational Databases

evaluating relationship Implementations performance in Object-relational Databases
View Free PDF
Author(s): María Fernanda Golobisky (Universidad Tecnológica Nacional, Argentina)and Aldo Vecchietti (Universidad Tecnológica Nacional, Argentina)
Copyright: 2007
Pages: 7
Source title: Managing Worldwide Operations and Communications with Information Technology
Source Editor(s): Mehdi Khosrow-Pour, D.B.A. (Information Resources Management Association, USA)
DOI: 10.4018/978-1-59904-929-8.ch210
ISBN13: 9781599049298
EISBN13: 9781466665378


In this work we make an evaluation of the object-relational schema implementation representing different relationships of an UML class diagram, against the relational approach. To perform this test we have implemented both schemas from a UML class diagram in a commercial database leader in the market. The main goal has been to prove the competitiveness of the object-relational technology. The methodology used for this work was to present several schema implementations of association, composition, aggregation and inheritance relationships, propose a set of representative queries to evaluate their behavior, compare the results and make an analysis based on response times. Four alternatives implementations of the schema diagram were made for a composition relationship presented in the proposed UML class diagram. The queries have been executed with no flush to the database buffer pool among runnings to simulate a real situation. In some object-relational queries several built-in functions and operations have been used. As a consequence of this work we are proposing some extensions to the relational schema diagram to add the object-relational alternatives (references, arrays, multisets, etc.) proposed by the SQL:2003 standard. The object-relational technology has shown to be competitive compared the relational approach.

Body Bottom