Dynamics of the air passenger transportation market in Colombia (2016)

Today, IT professionals are challenged with the task of ongoing improvements to achieve goals of businesses. Unfortunately, some factor/Resources, skill environment does not dynamically grow as fast as business needs. That sequence of events creates major obstacles for DB infrastructure, deployment, administration and maintenance. This paper discusses the performance issues, different bottlenecks such as CPU bottlenecks, Memory structures, Input output capacity issue, Database Design issues and Indexing issues. Also this paper address Tuning stages and how SQL queries can be optimized for better performance. In this paper we are focusing on query tuning tips & tricks which can be applied to gain immediate performance gain by creating Query Execution Flow Chart. We demonstrate the application of this technique in an Employee Biometric Attendance Management System

• Autores: Lis-Gutierrez, Jenny Paola; Muñoz Segura, Jessica Paola; Gaitan, Mercedes; Carolina Henao, Linda; Viloria, Amelec; Malagón, Luz Elena; Aguilera-Hernandez, Doris
• Tipo de recurso: Article of journal
• Fecha de publicación: 2018
• Institución: Corporación Universidad de la Costa
• Repositorio: REDICUC - Repositorio CUC
• Idioma: eng
• OAI Identifier: oai:repositorio.cuc.edu.co:11323/3321
• Acceso en línea: https://hdl.handle.net/11323/3321; https://repositorio.cuc.edu.co/
• Palabra clave: Database management system; RDBMS; Database tuning query optimization; Database performance; Optimization techniques; Sistema de gestión de base de datos; RDBMS; Ajuste de base de datos; Optimización de consultas; Técnicas de optimización de rendimiento de base de datos
• Rights: openAccess
• License: Attribution-NonCommercial-ShareAlike 4.0 International