Evaluating relationship implementations performance in object-relational databases
- Autores
- Golobisky, María Fernanda; Vecchietti, Aldo
- Año de publicación
- 2007
- Idioma
- inglés
- Tipo de recurso
- parte de libro
- Estado
- versión publicada
- Descripción
- In this work an evaluation of an object-relational schema implementation representing different relationships of an UML class diagram against the relational approach was made. To perform this test we have implemented both object-relational and relational 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.
Fil: Golobisky, María Fernanda. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; Argentina
Fil: Vecchietti, Aldo. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; Argentina - Materia
-
Object-Relational Database
Implementation
Relationships - Nivel de accesibilidad
- acceso abierto
- Condiciones de uso
- https://creativecommons.org/licenses/by-nc-sa/2.5/ar/
- Repositorio
- Institución
- Consejo Nacional de Investigaciones Científicas y Técnicas
- OAI Identificador
- oai:ri.conicet.gov.ar:11336/192574
Ver los metadatos del registro completo
id |
CONICETDig_9fcc51a453ca65bbe5d550a5459df399 |
---|---|
oai_identifier_str |
oai:ri.conicet.gov.ar:11336/192574 |
network_acronym_str |
CONICETDig |
repository_id_str |
3498 |
network_name_str |
CONICET Digital (CONICET) |
spelling |
Evaluating relationship implementations performance in object-relational databasesGolobisky, María FernandaVecchietti, AldoObject-Relational DatabaseImplementationRelationshipshttps://purl.org/becyt/ford/2.4https://purl.org/becyt/ford/2In this work an evaluation of an object-relational schema implementation representing different relationships of an UML class diagram against the relational approach was made. To perform this test we have implemented both object-relational and relational 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.Fil: Golobisky, María Fernanda. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; ArgentinaFil: Vecchietti, Aldo. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; ArgentinaIGI Global2007info:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/bookParthttp://purl.org/coar/resource_type/c_3248info:ar-repo/semantics/parteDeLibroapplication/pdfapplication/pdfapplication/pdfhttp://hdl.handle.net/11336/192574Golobisky, María Fernanda; Vecchietti, Aldo; Evaluating relationship implementations performance in object-relational databases; IGI Global; 2007; 929-935978-1-59904-929-8CONICET DigitalCONICETenginfo:eu-repo/semantics/altIdentifier/url/https://www.irma-international.org/proceeding-paper/evaluating-relationship-implementations-performance-object/33217/info:eu-repo/semantics/openAccesshttps://creativecommons.org/licenses/by-nc-sa/2.5/ar/reponame:CONICET Digital (CONICET)instname:Consejo Nacional de Investigaciones Científicas y Técnicas2025-09-03T10:07:50Zoai:ri.conicet.gov.ar:11336/192574instacron:CONICETInstitucionalhttp://ri.conicet.gov.ar/Organismo científico-tecnológicoNo correspondehttp://ri.conicet.gov.ar/oai/requestdasensio@conicet.gov.ar; lcarlino@conicet.gov.arArgentinaNo correspondeNo correspondeNo correspondeopendoar:34982025-09-03 10:07:50.507CONICET Digital (CONICET) - Consejo Nacional de Investigaciones Científicas y Técnicasfalse |
dc.title.none.fl_str_mv |
Evaluating relationship implementations performance in object-relational databases |
title |
Evaluating relationship implementations performance in object-relational databases |
spellingShingle |
Evaluating relationship implementations performance in object-relational databases Golobisky, María Fernanda Object-Relational Database Implementation Relationships |
title_short |
Evaluating relationship implementations performance in object-relational databases |
title_full |
Evaluating relationship implementations performance in object-relational databases |
title_fullStr |
Evaluating relationship implementations performance in object-relational databases |
title_full_unstemmed |
Evaluating relationship implementations performance in object-relational databases |
title_sort |
Evaluating relationship implementations performance in object-relational databases |
dc.creator.none.fl_str_mv |
Golobisky, María Fernanda Vecchietti, Aldo |
author |
Golobisky, María Fernanda |
author_facet |
Golobisky, María Fernanda Vecchietti, Aldo |
author_role |
author |
author2 |
Vecchietti, Aldo |
author2_role |
author |
dc.subject.none.fl_str_mv |
Object-Relational Database Implementation Relationships |
topic |
Object-Relational Database Implementation Relationships |
purl_subject.fl_str_mv |
https://purl.org/becyt/ford/2.4 https://purl.org/becyt/ford/2 |
dc.description.none.fl_txt_mv |
In this work an evaluation of an object-relational schema implementation representing different relationships of an UML class diagram against the relational approach was made. To perform this test we have implemented both object-relational and relational 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. Fil: Golobisky, María Fernanda. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; Argentina Fil: Vecchietti, Aldo. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; Argentina |
description |
In this work an evaluation of an object-relational schema implementation representing different relationships of an UML class diagram against the relational approach was made. To perform this test we have implemented both object-relational and relational 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. |
publishDate |
2007 |
dc.date.none.fl_str_mv |
2007 |
dc.type.none.fl_str_mv |
info:eu-repo/semantics/publishedVersion info:eu-repo/semantics/bookPart http://purl.org/coar/resource_type/c_3248 info:ar-repo/semantics/parteDeLibro |
status_str |
publishedVersion |
format |
bookPart |
dc.identifier.none.fl_str_mv |
http://hdl.handle.net/11336/192574 Golobisky, María Fernanda; Vecchietti, Aldo; Evaluating relationship implementations performance in object-relational databases; IGI Global; 2007; 929-935 978-1-59904-929-8 CONICET Digital CONICET |
url |
http://hdl.handle.net/11336/192574 |
identifier_str_mv |
Golobisky, María Fernanda; Vecchietti, Aldo; Evaluating relationship implementations performance in object-relational databases; IGI Global; 2007; 929-935 978-1-59904-929-8 CONICET Digital CONICET |
dc.language.none.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
info:eu-repo/semantics/altIdentifier/url/https://www.irma-international.org/proceeding-paper/evaluating-relationship-implementations-performance-object/33217/ |
dc.rights.none.fl_str_mv |
info:eu-repo/semantics/openAccess https://creativecommons.org/licenses/by-nc-sa/2.5/ar/ |
eu_rights_str_mv |
openAccess |
rights_invalid_str_mv |
https://creativecommons.org/licenses/by-nc-sa/2.5/ar/ |
dc.format.none.fl_str_mv |
application/pdf application/pdf application/pdf |
dc.publisher.none.fl_str_mv |
IGI Global |
publisher.none.fl_str_mv |
IGI Global |
dc.source.none.fl_str_mv |
reponame:CONICET Digital (CONICET) instname:Consejo Nacional de Investigaciones Científicas y Técnicas |
reponame_str |
CONICET Digital (CONICET) |
collection |
CONICET Digital (CONICET) |
instname_str |
Consejo Nacional de Investigaciones Científicas y Técnicas |
repository.name.fl_str_mv |
CONICET Digital (CONICET) - Consejo Nacional de Investigaciones Científicas y Técnicas |
repository.mail.fl_str_mv |
dasensio@conicet.gov.ar; lcarlino@conicet.gov.ar |
_version_ |
1842270020099375104 |
score |
13.13397 |