Herramienta libre de monitoreo y control para PostgreSQL
Fecha
2011-07-11
Autores
Flores Pérez, Dayani
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central “Marta Abreu” de Las Villas
Resumen
El desarrollo y perfeccionamiento de herramientas que complementan la utilización de
las bases de datos ha marcado, sin dudas, un hito en la revolución tecnológica en que
está inmerso el mundo. Sin embargo el privilegio de usar estas herramientas ha sido solo
un sueño para muchos pues los precios a pagar son muy altos. Cuba, incluida en esta
lista, ha tomado algunas alternativas, como la creación de aplicaciones autóctonas que
garanticen una independencia tecnológica. Como parte de esta estrategia se han
necesitado herramientas que además de gestionar las bases de datos, monitoreen el
funcionamiento de estas, es por ello que el objetivo central de esta tesis es el desarrollo
de una aplicación que, aparte de resolver esta problemática, funcione sobre la web 2.0 y
permita identificar los problemas de rendimiento del gestor. Durante su confección se
estudiaron y caracterizaron las herramientas más utilizadas para el monitoreo y control
de bases de datos en PostgreSQL. Para conocimiento de los lectores se describen y
justifican las tecnologías y herramientas de software libre que fueron utilizadas durante
el desarrollo de la aplicación. Se muestran en varias imágenes los Casos de Uso del
sistema, diagramas de clase y de componentes más significativos y se detalla el
diagrama de despliegue que documenta la implantación del sistema. Finalmente y con el
objetivo de facilitar la interacción de los usuarios con la herramienta, se realiza una
descripción de las funcionalidades que posee a través de un esbozo del Manual de
Usuario.
The development and refinement of tools that complement the use of databases has made, no doubt, a milestone in the technological revolution the world is immersed. However, the privilege of using these tools has been a dream for many because prices are too high to pay. Cuba included in this list, has taken some alternatives, like creating native applications guaranteeing technological independence. As part of this strategy it has been needed tools are to manage databases, monitor the operation of these, which is why the main objective of this thesis is to develop an application that besides solving this problem, work on web 2.0 and allows to identify performance issues of the database manager. During its development the most used tools for monitoring and control of PostgreSQL databases were studied and characterized. As additional information for readers the free software technologies and tools that were used during the development of the application are described and their used is justified.. Multiple images are shown in the Use Cases of the system, class diagrams and most significant components and is also detailed the deployment diagram that documents the implementation of the system. Finally and in order to facilitate user interaction with the tool, there is a description of the functionality held through an outline of the User Manual.
The development and refinement of tools that complement the use of databases has made, no doubt, a milestone in the technological revolution the world is immersed. However, the privilege of using these tools has been a dream for many because prices are too high to pay. Cuba included in this list, has taken some alternatives, like creating native applications guaranteeing technological independence. As part of this strategy it has been needed tools are to manage databases, monitor the operation of these, which is why the main objective of this thesis is to develop an application that besides solving this problem, work on web 2.0 and allows to identify performance issues of the database manager. During its development the most used tools for monitoring and control of PostgreSQL databases were studied and characterized. As additional information for readers the free software technologies and tools that were used during the development of the application are described and their used is justified.. Multiple images are shown in the Use Cases of the system, class diagrams and most significant components and is also detailed the deployment diagram that documents the implementation of the system. Finally and in order to facilitate user interaction with the tool, there is a description of the functionality held through an outline of the User Manual.
Descripción
Palabras clave
Herramienta Libre, Monitoreo y Control, PostgreSQL, Web 2.0