Consultas hipotéticas: la cláusula model en sql
DOI:
https://doi.org/10.22517/23447214.2909Abstract
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 unionDownloads
Downloads
-
Vistas(Views): 318
- PDF (Español (España)) Descargas(Downloads): 350
Published
How to Cite
Issue
Section
License
Copyrights
The journal is free open access. The papers are published under the Creative Commons Attribution / Attribution-NonCommercial-NoDerivatives 4.0 International - CC BY-NC-ND 4.0 license. For this reason, the author or authors of a manuscript accepted for publication will yield all the economic rights to the Universidad Tecnológica of Pereira free of charge, taking into account the following:
In the event that the submitted manuscript is accepted for publication, the authors must grant permission to the journal, in unlimited time, to reproduce, to edit, distribute, exhibit and publish anywhere, either by means printed, electronic, databases, repositories, optical discs, Internet or any other required medium. In all cases, the journal preserves the obligation to respect, the moral rights of the authors, contained in article 30 of Law 23 of 1982 of the Government Colombian.
The transferors using ASSIGNMENT OF PATRIMONIAL RIGHTS letter declare that all the material that is part of the article is entirely free of copyright. Therefore, the authors are responsible for any litigation or related claim to intellectual property rights. They exonerate of all responsibility to the Universidad Tecnológica of Pereira (publishing entity) and the Scientia et Technica journal. Likewise, the authors accept that the work presented will be distributed in free open access, safeguarding copyright under the Creative Commons Attribution / Recognition-NonCommercial-NoDerivatives 4.0 International - https://creativecommons.org/licenses/by-nc-nd/4.0/deed.es license.