The performance of relational and object-relational SQL queries when using Oracle
En este artIculo se muestra por medio de consultas especIficas el comportamiento del modelo relacional y obleto- 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 cláusulas GROUP BY, subc...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Universidad Nacional de Colombia
2005-09-01
|
| Series: | Ingeniería e Investigación |
| Subjects: | |
| Online Access: | https://revistas.unal.edu.co/index.php/ingeinv/article/view/14658 |
| _version_ | 1818035874772811776 |
|---|---|
| author | Francisco Javier Moreno Arboleda Guillermo Ospina Romero Rafael Larios Restrepo |
| author_facet | Francisco Javier Moreno Arboleda Guillermo Ospina Romero Rafael Larios Restrepo |
| author_sort | Francisco Javier Moreno Arboleda |
| collection | DOAJ |
| description | En este artIculo se muestra por medio de consultas especIficas el comportamiento del modelo relacional y obleto- 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 cláusulas GROUP BY, subconsultas (con las cláusulas IN y EXISTS), y reuniones (joins). |
| first_indexed | 2024-12-10T07:02:00Z |
| format | Article |
| id | doaj.art-ff920aac211a4604947443d7e3e06d2b |
| institution | Directory Open Access Journal |
| issn | 0120-5609 2248-8723 |
| language | English |
| last_indexed | 2024-12-10T07:02:00Z |
| publishDate | 2005-09-01 |
| publisher | Universidad Nacional de Colombia |
| record_format | Article |
| series | Ingeniería e Investigación |
| spelling | doaj.art-ff920aac211a4604947443d7e3e06d2b2022-12-22T01:58:19ZengUniversidad Nacional de ColombiaIngeniería e Investigación0120-56092248-87232005-09-0125341213567The performance of relational and object-relational SQL queries when using OracleFrancisco Javier Moreno ArboledaGuillermo Ospina RomeroRafael Larios RestrepoEn este artIculo se muestra por medio de consultas especIficas el comportamiento del modelo relacional y obleto- 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 cláusulas GROUP BY, subconsultas (con las cláusulas IN y EXISTS), y reuniones (joins).https://revistas.unal.edu.co/index.php/ingeinv/article/view/14658relational and object-relational databasestuningSQLOracle |
| spellingShingle | Francisco Javier Moreno Arboleda Guillermo Ospina Romero Rafael Larios Restrepo The performance of relational and object-relational SQL queries when using Oracle Ingeniería e Investigación relational and object-relational databases tuning SQL Oracle |
| title | The performance of relational and object-relational SQL queries when using Oracle |
| title_full | The performance of relational and object-relational SQL queries when using Oracle |
| title_fullStr | The performance of relational and object-relational SQL queries when using Oracle |
| title_full_unstemmed | The performance of relational and object-relational SQL queries when using Oracle |
| title_short | The performance of relational and object-relational SQL queries when using Oracle |
| title_sort | performance of relational and object relational sql queries when using oracle |
| topic | relational and object-relational databases tuning SQL Oracle |
| url | https://revistas.unal.edu.co/index.php/ingeinv/article/view/14658 |
| work_keys_str_mv | AT franciscojaviermorenoarboleda theperformanceofrelationalandobjectrelationalsqlquerieswhenusingoracle AT guillermoospinaromero theperformanceofrelationalandobjectrelationalsqlquerieswhenusingoracle AT rafaellariosrestrepo theperformanceofrelationalandobjectrelationalsqlquerieswhenusingoracle AT franciscojaviermorenoarboleda performanceofrelationalandobjectrelationalsqlquerieswhenusingoracle AT guillermoospinaromero performanceofrelationalandobjectrelationalsqlquerieswhenusingoracle AT rafaellariosrestrepo performanceofrelationalandobjectrelationalsqlquerieswhenusingoracle |