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)

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: 28 mar. 2024.

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 March 28, 2024. 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 2024 Mar. 28];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

Article abstract page views

394

Downloads

Download data is not yet available.

Most read articles by the same author(s)