En nuestra última edición

Low-cost meteorological platform based on zigbee technology

Computer- assisted analysis for e-portfolio learning strategy

Smart home control by voice using neural networks

Application software as global marketing strategy

Methodology used in the design and construction of a computer numerical control machine

Exergy analysis for a furnace in the production of panela

Reflection on the requirements specification in a university context

Digital social networks: an approach to risk management information systems

Analysis of the current system of a clay block dryer and an improvement proposal

Algorithms and systems based on patterns of stem cell and artificial cloning for automation and control in an assembly operation in metalworking processes

Development of a software to apply zoometria in bovine cattle

Design and simulation of a prototype of machine for signaling of ways, automated through a mechanical system

Modelation of modal election for urban public transport based on the introduction of a new mode

Evaluation of resistance to flexion in glazed ceramic tile in terms of ice and thaw cycles

A look at the onto- epistemic fundamentals of the career of system engineering as a basis for rethinking the social impact in times of changing

Structural analysis of a pressing machine for production of solid brick for small craft industries of ceramic materials in Ocaña, Norte de Santander, and in the region

Identification of vegetable coverages from satellite images over the middle and lower basin of the Catatumbo river

Aplication of lattice boltzmann equation method to the bidimensional simulation of typical fluids mechanic problem

The historical references of professional. development case study of teachers teaching in the basic primary education in Colombia

Critical thinking of students using facebook like new technology learning

Resumen

 

OPTIMIZATION OF RELATIONAL JOIN ALGORITHMS FOR DATABASE TECHNOLOGIES

OPTIMIZACIÓN DE ALGORITMOS DE JOIN RELACIONAL PARA TECNOLOGÍAS DE BASES DE DATOS
Ing. Bell Manrique Losada.
MSc. Francisco Javier Moreno.
MSc. Jaime Alberto Guzmán Luna.

Abstract: In the following paper we present the Relational Join Algorithms more frequently utilized for the optimization in databases systems, by specifying the performance of each one of them, their determinant characteristics and demonstratives examples of their application in real cases. We also describe the influence of the interesting orders in query optimization and its exemplification, to utilize theirs explicitly in the Databases Management Systems.

Resumen: En este artículo se presentan los algoritmos de Join Relacional más utilizados en el procesamiento y optimización en Bases de Datos, especificando el comportamiento de cada uno de ellos, sus características determinantes y ejemplos demostrativos de su aplicación en casos reales. Además, se describe la influencia de los órdenes interesantes en la optimización de consultas y su ejemplificación, con miras en utilizarlos explícitamente en la optimización en Sistemas de Gestión de Bases de Datos.

Keywords: Query Optimization, Interesting Orders, Join Algorithms, Relational Join, Database Technologies.