Herramienta para la administración del gestor PostgreSQL
Fecha
2011-07-11
Autores
Guzmán Fernández, Ismary
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central “Marta Abreu” de Las Villas
Resumen
Para nuestro país obtener la soberanía tecnológica es un reto grandioso, por lo que cada día
es mayor la necesidad de contar con herramientas libres que faciliten a los usuarios la
aceptación del software libre. Respecto a esto, el tema de las bases de datos posee amplia
documentación y herramientas, aunque las mismas en su mayoría carecen de interfaces de
trabajo amigables e intuitivas y de una amplia gama de servicios integrados a las mismas.
Es por ello que en el presente trabajo se aborda el diseño e implementación de una
herramienta libre, que funciona sobre la Web 2.0 y administra con eficiencia el gestor de
base de datos PostgreSQL. Para su elaboración se partió del estudio y caracterización de las
herramientas de software libre más utilizadas para la administración de bases de datos en
PostgreSQL. Además se fundamentan las tecnologías y herramientas de software libre que
fueron utilizadas durante el desarrollo de la aplicación. Se describen 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.
For our country gaining technological sovereignty is a great challenge, so every day increases the need of free tools that can facilitate users the acceptance of free software. In this regard, the issue of databases has extensive documentation and tools, although they mostly lack of friendly and intuitive interfaces and a wide range of integrated services. That is why the aim of this research work is to design and implement a free tool that works on Web 2.0 and efficiently manages the database manager PostgreSQL. In order to start with development they were studied and characterized the most widely used free software tools for managing PostgreSQL databases. In addition, they were argued the underlying technologies and free software tools that were used during the development of the application. We describe the system use cases, class diagrams and most significant components and it was detailed the deployment diagram which documents the implementation of the system. Finally, with the aim of facilitate user interaction with the tool, it was performed a description of its functions through an outline of the User Manual.
For our country gaining technological sovereignty is a great challenge, so every day increases the need of free tools that can facilitate users the acceptance of free software. In this regard, the issue of databases has extensive documentation and tools, although they mostly lack of friendly and intuitive interfaces and a wide range of integrated services. That is why the aim of this research work is to design and implement a free tool that works on Web 2.0 and efficiently manages the database manager PostgreSQL. In order to start with development they were studied and characterized the most widely used free software tools for managing PostgreSQL databases. In addition, they were argued the underlying technologies and free software tools that were used during the development of the application. We describe the system use cases, class diagrams and most significant components and it was detailed the deployment diagram which documents the implementation of the system. Finally, with the aim of facilitate user interaction with the tool, it was performed a description of its functions through an outline of the User Manual.
Descripción
Palabras clave
Gestor PostgreSQL, Administración, Herramienta, Web 2.0