Consultas hipotéticas: la cláusula model en sql


Authors

  • Francisco Javier Moreno
  • Jaime Alberto Echeverry
  • Anderson Franco García

DOI:

https://doi.org/10.22517/23447214.2909

Abstract

Con el objetivo de hacer análisis históricos y predictivos mediante consultas de tipo what-if (qué pasaría si), Oracle ha adicionado al lenguaje SQL la cláusula MODEL. Aunque este tipo de consultas se pueden plantear también en SQL estándar, su planteamiento se facilita con esta cláusula. En este artículo se comparan ambas aproximaciones. Para ello se plantea un conjunto de consultas planteadas con la cláusula MODEL y con SQL estándar. Los resultados evidencian las ventajas de la cláusula MODEL: su simplicidad en el planteamiento de las consultas y el ahorro computacional que se logra al evitar reuniones (joins), subconsultas correlacionadas y union

Downloads

Download data is not yet available.

Downloads

Published

2009-05-30

How to Cite

Moreno, F. J., Echeverry, J. A., & Franco García, A. (2009). Consultas hipotéticas: la cláusula model en sql. Scientia Et Technica, 1(41). https://doi.org/10.22517/23447214.2909

Issue

Vol. 1 No. 41 (2009)

Section

Sistemas y Computación

License

The undersigned authors declare that the article submitted to the journal Scientia et Technica is an original work and that all its content is free of third-party copyright restrictions or has the corresponding authorizations. Consequently, the authors assume responsibility for any litigation or claim related to intellectual property rights, releasing the Technological University of Pereira and the journal Scientia et Technica from any liability.

If the submitted work is accepted for publication, the authors retain copyright to the article and grant the journal Scientia et Technica the right of first publication, as well as a non-exclusive, perpetual license to reproduce, edit, distribute, display, and publicly communicate the article in any medium or format, including print, electronic, databases, repositories, the Internet, or other scientific dissemination systems. The authors agree that the article will be published in open access and distributed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License (CC BY-NC-SA 4.0).

The journal Scientia will respect in all cases the moral rights of the authors, in accordance with the provisions of article 30 of Law 23 of 1982 of the Republic of Colombia, recognizing the authorship of the work, the right to integrity and the right of disclosure, which are inalienable and non-waivable.