Correo Electrónico
DNINFOA - SIA
Bibliotecas
Convocatorias
Identidad U.N.
Published
The performance of relational and object-relational SQL queries when using Oracle
Desempeño de consultas SQL relacionales y objeto-relacionales en Oracle
Keywords:
relational and object-relational databases, tuning, SQL, Oracle (en)bases de datos relacionales y objeto-relacionales, optimización, SQL, Oracle (es)
Downloads
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).
Downloads
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.
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.
License
Copyright (c) 2005 Francisco Javier Moreno Arboleda, Guillermo Ospina Romero, Rafael Larios Restrepo
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.
