Análisis Comparativo entre los Motores de Base de Datos Postgresql y Firebird Aplicando al Gobierno Autónomo Descentralizado Municipal de San José de Chimbo.

Abstract

The purpose of this research is a comparative analysis between database engines and free data PostgreSQL 9.2.3 Firebird 2.5.2 stable versions in order to render performance, where would select the best for use in a web application for the guarantees control in the contracts of public works, applied to the Autonomous Decentralized Government (GAD) of Chimbo Canton, in Bolivar Province. Through the scientific method the results of the data obtained in different test scenarios were analyzed. The parameters for performance analysis that represents the response times in data management and resource consumption that is the use of hardware. PgAdmin III as the software tools that will handle the data in PostgreSQL, IBExpert for Firebird data control and an external tool the DBTools Manager Professional will control both databases were used. While resource consumption for the Windows Task Manager was used. Obtaining as final results on performance rather resource consumption PostgreSQL with 77.6% and 76.4% Firebird. Therefore both receive a good equivalence. Manifesting as conclusion that PostgreSQL exceeds a minimum value of 1.2% in difference in Firebird, which the PostgreSQL database engine data was selected, to create the guarantees system of Chimbo Government. It is recommended that specialist’s procurement process GAD Chimbo Cantón the use of the guarantee system for optimal performance of the activities. In addition to the development of future applications an alternative is PostgreSQL because it has proved variability in robustness and data manipulation.