Revista 25 - 3

Published

2005-09-01

The performance of relational and object-relational SQL queries when using Oracle

Desempeño de consultas SQL relacionales y objeto-relacionales en Oracle

DOI:

https://doi.org/10.15446/ing.investig.v25n3.14658

Keywords:

relational and object-relational databases, tuning, SQL, Oracle (en)
bases de datos relacionales y objeto-relacionales, optimización, SQL, Oracle (es)

Downloads

Authors

  • Francisco Javier Moreno Arboleda Universidad Nacional de Colombia
  • Guillermo Ospina Romero Universidad Nacional de Colombia
  • Rafael Larios Restrepo Universidad Nacional de Colombia

This article presents a study in which the performance of several queries involving GROUP BY clause, sub-queries (using IN and EXISTS clauses) and joins are measured and compared by means of specific queries. The behavior of relational and object-relational models is also shown.

En este artículo se muestra por medio de consultas específicas el comportamiento del modelo relacional y objeto-relacional, y se presenta así un estudio en el que se mide y a la vez se compara la eficiencia (tiempo, uso de recursos del sistema) de operaciones que involucran clausulas GROUP BY, subconsultas (con las cláusulas IN y EXISTS), y reuniones (joins).

References

Aronoff, E., EXPLAIN PLAN: Everything you wanted to know and had no-one to ask. Quest Software, 1995.

Bodnar, R., "Modeling Customers, an Object Lesson", Oracle Magazine, Vol. XIV, No. 4, Jul/Ago 2000, pp.91-98.

Burleson, D., "Physical DB Design Using Oracle", CRC Press, 2004, pp. 154-196. DOI: https://doi.org/10.1201/9780203506233

Date, C., "Introducción a los sistemas de bases de datos", Pearson Educación, 2001, pp. 554-560.

Harrison, G., "Oracle SQL High-Performance Tuning", 2a ed., Prentice Hall, 2000, pp. 107-113, 134-159.

Kyte, T., "Use of Bind Variables on 8.1.6", Pagina electrónica Ask Tom, 2000.

Niemiec, R., "Comunicación privada a través de correo electrónico", febrero 2005.

Nyffenegger, R., Shared Pool [Oracle], http://www.adpgmbh.ch/ora/concepts/shared_pool.html, 2000.

Nyffenegger, R., Oracle SQL Hints, http://www.adpgmbh.ch/ora/sql/hints.html, 2001.

Oracle Corporation, Oracle DB Application Developer's Guide Object Relational Features, 2003, pp. 27-106.

Oracle Corporation, Oracle DB Performance Tuning Guide, 2003, pp.303-307, 411-544.

Raghavan, G., Oracle Tips, Comunicación electrónica con usuario, http://www.arikaplan.com/oracle/ari52499c.html, 1999.

Stonebraker, M., "Object-Relational DBMSs: The Next Great Wave", Morgan Kauffman, 1996, pp. 18-39.

How to Cite

APA

Moreno Arboleda, F. J., Ospina Romero, G. and Larios Restrepo, R. (2005). The performance of relational and object-relational SQL queries when using Oracle. Ingeniería e Investigación, 25(3), 4–12. https://doi.org/10.15446/ing.investig.v25n3.14658

ACM

[1]
Moreno Arboleda, F.J., Ospina Romero, G. and Larios Restrepo, R. 2005. The performance of relational and object-relational SQL queries when using Oracle. Ingeniería e Investigación. 25, 3 (Sep. 2005), 4–12. DOI:https://doi.org/10.15446/ing.investig.v25n3.14658.

ACS

(1)
Moreno Arboleda, F. J.; Ospina Romero, G.; Larios Restrepo, R. The performance of relational and object-relational SQL queries when using Oracle. Ing. Inv. 2005, 25, 4-12.

ABNT

MORENO ARBOLEDA, F. J.; OSPINA ROMERO, G.; LARIOS RESTREPO, R. The performance of relational and object-relational SQL queries when using Oracle. Ingeniería e Investigación, [S. l.], v. 25, n. 3, p. 4–12, 2005. DOI: 10.15446/ing.investig.v25n3.14658. Disponível em: https://revistas.unal.edu.co/index.php/ingeinv/article/view/14658. Acesso em: 10 apr. 2025.

Chicago

Moreno Arboleda, Francisco Javier, Guillermo Ospina Romero, and Rafael Larios Restrepo. 2005. “The performance of relational and object-relational SQL queries when using Oracle”. Ingeniería E Investigación 25 (3):4-12. https://doi.org/10.15446/ing.investig.v25n3.14658.

Harvard

Moreno Arboleda, F. J., Ospina Romero, G. and Larios Restrepo, R. (2005) “The performance of relational and object-relational SQL queries when using Oracle”, Ingeniería e Investigación, 25(3), pp. 4–12. doi: 10.15446/ing.investig.v25n3.14658.

IEEE

[1]
F. J. Moreno Arboleda, G. Ospina Romero, and R. Larios Restrepo, “The performance of relational and object-relational SQL queries when using Oracle”, Ing. Inv., vol. 25, no. 3, pp. 4–12, Sep. 2005.

MLA

Moreno Arboleda, F. J., G. Ospina Romero, and R. Larios Restrepo. “The performance of relational and object-relational SQL queries when using Oracle”. Ingeniería e Investigación, vol. 25, no. 3, Sept. 2005, pp. 4-12, doi:10.15446/ing.investig.v25n3.14658.

Turabian

Moreno Arboleda, Francisco Javier, Guillermo Ospina Romero, and Rafael Larios Restrepo. “The performance of relational and object-relational SQL queries when using Oracle”. Ingeniería e Investigación 25, no. 3 (September 1, 2005): 4–12. Accessed April 10, 2025. https://revistas.unal.edu.co/index.php/ingeinv/article/view/14658.

Vancouver

1.
Moreno Arboleda FJ, Ospina Romero G, Larios Restrepo R. The performance of relational and object-relational SQL queries when using Oracle. Ing. Inv. [Internet]. 2005 Sep. 1 [cited 2025 Apr. 10];25(3):4-12. Available from: https://revistas.unal.edu.co/index.php/ingeinv/article/view/14658

Download Citation

CrossRef Cited-by

CrossRef citations0

Dimensions

PlumX

Plum Print visual indicator of research metrics
  • Captures
  • Mendeley - Readers: 3
-
see details

Article abstract page views

414

Downloads

Crossref
Scopus
Google Scholar
Europe PMC

License

Copyright (c) 2005 Francisco Javier Moreno Arboleda, Guillermo Ospina Romero, Rafael Larios Restrepo

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

The authors or holders of the copyright for each article hereby confer exclusive, limited and free authorization on the Universidad Nacional de Colombia's journal Ingeniería e Investigación concerning the aforementioned article which, once it has been evaluated and approved, will be submitted for publication, in line with the following items:

1.    The version which has been corrected according to the evaluators' suggestions will be remitted and it will be made clear whether the aforementioned article is an unedited document regarding which the rights to be authorized are held and total responsibility will be assumed by the authors for the content of the work being submitted to Ingeniería e Investigación, the Universidad Nacional de Colombia and third-parties;

2.    The authorization conferred on the journal will come into force from the date on which it is included in the respective volume and issue of Ingeniería e Investigación in the Open Journal Systems and on the journal's main page (https://revistas.unal.edu.co/index.php/ingeinv), as well as in different databases and indices in which the publication is indexed;

3.    The authors authorize the Universidad Nacional de Colombia's journal Ingeniería e Investigación to publish the document in whatever required format (printed, digital, electronic or whatsoever known or yet to be discovered form) and authorize Ingeniería e Investigación to include the work in any indices and/or search engines deemed necessary for promoting its diffusion;

4.    The authors accept that such authorization is given free of charge and they, therefore, waive any right to receive remuneration from the publication, distribution, public communication and any use whatsoever referred to in the terms of this authorization.

Most read articles by the same author(s)