Diseño e implementación de un sistema de soporte de decisiones para el Centro de Documentación Regional “Juan Bautista Vázquez”
Abstract
RESUMEN
El volumen de datos en bibliotecas ha aumentado enormemente en los últimos años, así como también la complejidad de sus fuentes y formatos de información, dificultando su gestión y acceso, especialmente como apoyo en la toma de decisiones. Sabiendo que una buena gestión de bibliotecas involucra la integración de indicadores estratégicos, la implementación de un Data Warehouse (DW), que gestione adecuadamente tal cantidad de información, así como su compleja mezcla de fuentes de datos, se convierte en una alternativa interesante a considerar. El artículo describe el diseño e implementación de un sistema de soporte de decisiones (DSS) basado en técnicas de DW para la biblioteca de la Universidad de Cuenca. Para esto, el estudio utiliza una metodología holística, propuesto por Siguenza-Guzman et al. (2014) para la evaluación integral de bibliotecas. Dicha metodología evalúa la colección y los servicios, incorporando importantes elementos para la gestión de bibliotecas, tales como: el desempeño de los servicios, el control de calidad, el uso de la colección y la interacción con el usuario. A partir de este análisis, se propone una arquitectura de DW que integra, procesa y almacena los datos. Finalmente, estos datos almacenados son analizados y visualizados a través de herramientas de procesamiento analítico en línea (OLAP). Las pruebas iniciales de implementación confirman la viabilidad y eficacia del enfoque propuesto, al integrar con éxito múltiples y heterogéneas fuentes y formatos de datos, facilitando que los directores de bibliotecas generen informes personalizados, e incluso permitiendo madurar los procesos transaccionales que diariamente se llevan a cabo.
Palabras clave: Data warehouse, sistema de soporte a aecisiones, OLAP, Hefesto, Pentaho.
ABSTRACT
In recent years, volume of library-related data has increased tremendously, as well as complexity of data sources and formats have been escalating. This information explosion has created a big challenge for data managing, archiving and accessing, especially in support of library decision-making. Knowing that a good library management involves integrating a number of strategic indicators, the implementation of a Data Warehouse (DW), that properly manages such amount of information and the complex mix of data sources, becomes an interesting alternative to be considered. This article describes the design and implementation of a decision support system based on a DW approach for the Regional Documentation Centre “Juan Bautista Vazquez”. To assure that all relevant data sources are included during the data analysis, the study utilizes a holistic methodology, previously proposed by Siguenza-Guzman et al. (2014) for an integrated library evaluation. This methodology assesses the library collection and services by incorporating important elements for library management, such as service performance analysis, service quality control, collection usage analysis, and information retrieval quality. Based on this data analysis, the study proposes a DW architecture to integrate, process and store the relevant data. These stored data are finally analyzed and visualized by the so-called online analytical processing (OLAP) tools. Initial tests of the implemented decision support system confirm the feasibility and effectiveness of the DW based approach, by successfully integrating multiple and heterogeneous sources, formats and varieties of information, permitting library managers to generate personalized reports, and even allowing to debug the day-to-day transactional processes.
Keywords: Data warehouse, decision support system, OLAP, Hefesto, Pentaho
Downloads
Metrics
References
Chang, C., R. Chen, 2006. Using data mining technology to solve classification problems: A case study of the Campus Digital Library. The Electronic Library, 24(3), 307-21.
Dietz, B., L. Singh. 2009. Open source BI reporting tool review. Open Source Business Resource, No. Septiembre 2009. Disponible en http://timreview.ca/article/288.
Ecuador, 2008. Decreto de La Ley de La República Del Ecuador. Decreto 1014 para establecer como política pública la utilización de software libre en el Ecuador. Descargado de http:// www.espoch.edu.ec/Descargas/programapub/Decreto_1014_software_libre_Ecuador_c2d0b.pdf.
Golfarelli, M., 2009. Open source BI platforms: A functional and architectural comparison. En: Data warehousing and knowledge discovery. Bach Pedersen, T., K. Mukesh Mohania, A. Min Tjoa (Eds.). Lecture Notes in Computer Science 5691, 287-97. Springer Berlin Heidelberg. Disponible en http://link.springer.com/chapter/10.1007/978-3-642-03730-6_23.
Haro Valle, V., W. Pérez Rocano, 2014. Data warehouse para el Centro de Documentación Regional ‘Juan Bautista Vázquez’. Tesis de Pregrado, Universidad de Cuenca, Ecuador. Disponible en http://dspace.ucuenca.edu.ec/handle/123456789/19878.
Inmon, W.H., 2005. Building the data warehouse (4a ed.). John Wiley & Sons.
Jaspersoft Corporation, 2014. Jaspersoft Studio User Guide. Release 5.6. Disponible en http://d2553lapexsdrl.cloudfront.net/sites/default/files/docs/jaspersoft-studio-user-guide_0.pdf.
Kimball, R., M. Ross, 2002. The data warehouse toolkit: The complete guide to dimensional modeling (2a ed.). John Wiley & Sons.
Luan, X.M., H. Jiang, 2014. Design of books analysis system in university library based on data warehouse. Applied Mechanics and Materials, 513-517, 2121-24.
Siguenza-Guzman, L., V. Saquicela, D. Cattrysse, 2014. Design of an integrated decision support system for library holistic evaluation. In: Proceedings of IATUL Conferences, 1, 12 pp. Espoo, Finland.
Siguenza-Guzman, L., A. Van Den Abbeele, J. Vandewalle, H. Verhaaren, D. Cattrysse, 2015. A holistic approach to supporting academic libraries in resource allocation processes. The Library Quarterly: Information, Community, Policy (in Press).
Wah, T.Y., N.H. Peng, C.S. Hok, 2007. Building data warehouse. En: Proceedings of the 24th South East Asia Regional Computer Conference, 15, 51–56. No. SP4. Bangkok, Thailand. Disponible en http://pdf.aminer.org/000/307/364/acquiring_and_integrating_external_data_ into_data_warehouses_are_you.pdf.
Zucca, J., 2003. Traces in the clickstream: Early work on a management information repository at the University of Pennsylvania. Information Technology and Libraries, 22 (4), 175-78.
Downloads
Published
How to Cite
Issue
Section
License
Copyright © Autors. Creative Commons Attribution 4.0 License. for any article submitted from 6 June 2017 onwards. For manuscripts submitted before, the CC BY 3.0 License was used.
You are free to:
Share — copy and redistribute the material in any medium or format |
Adapt — remix, transform, and build upon the material for any purpose, even commercially. |
Under the following conditions:
Attribution — You must give appropriate credit, provide a link to the licence, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licenser endorses you or your use. |
No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the licence permits. |