Validación de un marco ETL para migración de Koha en el Sistema de Bibliotecas de la Universidad de Panamá.

Edgar Joel Pérez-Rivera

doi:10.48204/j.colonciencias.v9n2.a3595

Submitted June 28, 2022

Published 2022-07-28

Artículos

Vol. 9 No. 2 (2022): Revista Colón Ciencias, Tecnología y Negocios

Validation of an ETL framework for the migration of Koha in the University of Panama Library System..

Edgar Joel Pérez-Rivera⁺⁻

DOI https://doi.org/10.48204/j.colonciencias.v9n2.a3595

PDF (Español (España))

References

DOI: 10.48204/j.colonciencias.v9n2.a3595

Published: 2022-07-28

How to Cite

Pérez-Rivera, E. J. (2022). Validation of an ETL framework for the migration of Koha in the University of Panama Library System. Revista Colón Ciencias, Tecnología Y Negocios, 9(2), 92–100. https://doi.org/10.48204/j.colonciencias.v9n2.a3595

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Abstract

The automated management of bibliographic resources in higher education institutions relies structurally on integrated library systems (ILS), whose relational architecture supports critical processes of cataloging, circulation, and the long-term preservation of information. In open-source software environments, technological flexibility can coexist with scenarios of cumulative obsolescence when updates are not performed on a regular basis. This study empirically validates a methodological framework based on ETL (Extract, Transform, Load) processes applied to the Koha library management system, migrating from the obsolete version 3.12 to version 20.11. The research adopts an applied approach using an instrumental case study design conducted at a Latin American public university. The implemented strategy consisted of a database-to-database migration using open-source data engineering tools and an iterative structural transformation model. The results show an approximate recovery of 98% of the historical information capital, preserving referential integrity and institutionally validated functionality. It is concluded that the iterative ETL approach constitutes a viable methodological alternative for overcoming generational barriers in critically obsolete ILS systems, especially in academic contexts with budgetary constraints.

Downloads

Download data is not yet available.

References

Breeding, M. (2015). Library systems report 2015: Operationalizing innovation. Library Technology Reports, 51(4). URL: https://librarytechnology.org/document/20535
Date, C. J. (2019). Database design and relational theory: Normal forms and all that jazz (2nd ed.). O’Reilly Media. URL: https://www.oreilly.com/library/view/database-design-and/9781484255407/
Kimball, R., & Caserta, J. (2011). The data warehouse ETL toolkit: Practical techniques for extracting, cleaning, conforming, and delivering data. Wiley. URL: https://www.wiley.com/en-br/The+Data+Warehouse%C2%A0ETL+Toolkit%3A+Practical+Techniques+for+Extracting%2C+Cleaning%2C+Conforming%2C+and+Delivering+Data-p-9781118076802
Kruchten, P., Nord, R. L., & Ozkaya, I. (2012). Technical debt: From metaphor to theory and practice. IEEE Software, 29(6), 18–21. DOI: 10.1109/MS.2012.167
Laudon, K. C., & Laudon, J. P. (2020). Management information systems: Managing the digital firm (16th ed.). Pearson. URL: https://www.pearson.com/en-us/subject-catalog/p/management-information-systems-managing-the-digital-firm/P200000003135/9780136106414
Batini, C., & Scannapieco, M. (2016). Data and information quality: Dimensions, principles and techniques. Springer. URL: https://link.springer.com/book/10.1007/978-3-319-24106-7
Engard, N. C. (2014). Koha 3.12 manual. Sin URL/DOI verificable.
Koha Community. (2020, November 27). Koha 20.11 released. https://koha-community.org/koha-20-11-released/
Koha Community. (2012). Koha 3.12 release information. https://koha-community.org/koha-3-12-12-released/
Huo, L., Verner, J. M., Zhu, L., & Babar, M. A. (2004). Software maintenance through open source: A case study of Koha library software. Journal of Systems and Software, 74(1), 63–72. DOI: 10.1016/S0164-1212(04)00109-4
Dempsey, L. (2006). The library catalogue in a networked environment. Ariadne,(48). URL: https://www.webjunction.org/content/dam/research/publications/library/2008/dempsey-portal.pdf
Nicholson, D. R. (2008). Integrating open-source library systems in academic libraries. The Journal of Academic Librarianship, 34(2), 123–130. DOI: 10.1016/j.acalib.2007.11.006
Wodon, M. (2018). Open source integrated library systems and academic libraries. Library Hi Tech News, 35(3), 18–22. Sin DOI/URL verificable.
Tansley, R., & Houghton, J. (2003). The role of repositories in scholarly communication. Ariadne,(37). URL: https://www.ariadne.ac.uk/issue37/tansley/
Connaway, L. S., & Dickey, T. J. (2010). The digital information seeker. Library & Information Science Research, 32(2), 88–91. DOI: 10.1016/j.lisr.2009.11.007
O’Brien, J. A., & Marakas, G. M. (2010). Management information systems (10th ed.). McGraw-Hill. Sin URL/DOI verificable.
Stair, R., & Reynolds, G. (2017). Principles of information systems (13th ed.). Cengage. Sin URL/DOI verificable.
Golmohammadi, R., & Zahedi, F. (2012). Data quality management in information systems. Information Systems Management, 29(2), 89–101. DOI: 10.1080/10580530.2012.664478