Alternativa tecnológica para la integración de información: Estudio de caso de proyectos de Biocubafarma

Dalila Kindelán Castro; Carlos Ramón López Paz

Autores/as

Dalila Kindelán Castro Empresa Laboratorios Farmacéuticos AICA
Carlos Ramón López Paz Empresa Laboratorios Farmacéuticos AICA

Palabras clave:

bus de servicios empresariales, inteligencia de negocio, integración de datos, virtualización de datos, Mule ESB

Resumen

La Inteligencia de Negocios (BI) implica el conjunto de procesos que se realizan para convertir datos sin procesar en información significativa, para respaldar la toma de decisiones. La integración de información y las técnicas asociadas representan la base para crear una vista unificada de los datos provenientes de diferentes fuentes. Entre las técnicas se destaca la virtualización de datos, que propone como una de las alternativas para su implementación, los Bus de Servicios Empresariales (ESB). Este artículo presenta un estudio de caso en el contexto de tres áreas de procesos de la Empresa Laboratorios Farmacéuticos AICA. El estudio interviene 97 flujos de integración desarrollados con tecnología ESB, como una alternativa tecnológica que permite crear una capa de virtualización, que brinda acceso a la información integrada en tiempo real, y facilita el proceso de análisis y toma de decisiones en diferentes niveles. Toda la evidencia recolectada permite argumentar las experiencias adquiridas en el desarrollo de este tipo de soluciones y constituyen los hallazgos del estudio de caso.

Citas

Aziz, O. et al. (2020). Research Trends in Enterprise Service Bus (ESB) Applications: A Systematic Mapping Study. IEEE Access, (8): 31180-31197.

Barros Justo, J. L., F. B. V. Benitti & S. Matalonga (2019). Trends in software reuse research: A tertiary study. Computer Standards and Interfaces, 66.

Berna Martínez, J. et al. (2018). Method for the Integration of Applications based on Enterprise Service Bus Technologies.

Chen, F., L. Zhang & X. Lian (2021).A systematic gray literature review: The technologies and concerns of microservice application programming interfaces. Software-Practice and Experience, 51(7): 1483-1508.

Costa, D. I. C. et al. (2020). Microservice architecture: A tertiary study. in 14th Brazilian Symposium on Software Components, Architectures, and Reuse, SBCARS 2020, co-located with the Brazilian Conference on Software: Theory and Practice, CBSoft 2020. Association for Computing Machinery.

Dubé, L. & G. Paré (2003). Rigor in information systems positivist case research: Current practices, trends, and recommendations. MIS Quarterly: Management Information Systems, 27(4): 597-635.

El Ghalbzouri, H. & J. El Bouh (2021). Integrating Business Intelligence with Cloud Computing: State of the Art and Fundamental Concepts, in 4th International Conference on Networking, Intelligent Systems and Security, NISS 2021, M. Ben Ahmed, et al., Editors, Springer Science and Business Media Deutschland GmbH. 197-213.

Elsahn, Z. et al. (2020). Are rigor and transparency enough? Review and future directions for case studies in technology and innovation Management. In R and D Management. Blackwell Publishing Ltd.

Kitchenham, B. A., D. Budgen & O. Pearl Brereton (2011). Using mapping studies as the basis for further research-A participant-observer case study. Information and Software Technology, 53(6): 638-651.

Kitchenham, B. A., D. Budgen & P. Brereton (2015). Evidence-Based Software Engineering and Systematic Reviews. Evidence-Based Software Engineering and Systematic Reviews. CRC Press, 1-391.

Kitchenham, B.A., L. Madeyski & D. Budgen (2022). How Should Software Engineering Secondary Studies Include Grey Material. IEEE Transactions on Software Engineering.

Liang, T. P. & Y. H. Liu (2018). Research Landscape of Business Intelligence and Big Data analytics: A bibliometrics study. Expert Systems with Applications, (111): 2-10.

Maciá Pérez, F. et al. (2018). Conceptualising it consulting services: An approach from it-business alignment models and design sciences. Journal of Theoretical and Applied Information Technology, 96.

Manik, L.P. (2022).Performance Factors Effect on the Performance Metrics of the Enterprise Service Bus. International Journal of Computing and Digital Systems, (11): 107-115.

Mousa, A.H. & N. Shiratuddin (2015). Data Warehouse and Data Virtualization Comparative Study. in Proceedings-2015 International Conference on Developments in eSystems Engineering, DeSE 2015. Institute of Electrical and Electronics Engineers Inc.

Nawaz, M. S. et al. (2022). A study on application programming interface recommendation: state-of-the-art techniques, challenges and future directions. Library Hi Tech.

Ofoeda, J., R. Boateng & J. Effah (2019). Application programming interface (API) research: A review of the past to inform the future. International Journal of Enterprise Information Systems, 15(3): 76-95.

Paradza, D. & O. Daramo (2021).Business intelligence and business value in organisations: A systematic literature review. Sustainability (Switzerland), 13(20).

Pérez, F. M., et al. (2018).Conceptualising it consulting services: An approach from it-business alignment models and design sciences. Journal of Theoretical and Applied Information Technology, 96(16): 5363-5384.

Pontes, L. & A. Albuquerque (2021). Business Intelligence Development Process: A Systematic Literature Review, in World Conference on Information Systems and Technologies, WorldCIST 2021, A. Rocha, et al., Editors, Springer Science and Business Media Deutschland GmbH. , 560-569.

Rashid, A. & M. M. Khurshid (2022). A Descriptive Literature Review and Classification of Business Intelligence and Big Data Research, in Computing Conference, 2022, K. Arai, Editor, Springer Science and Business Media Deutschland GmbH, 865-879.

Reeve, A. (2013). Chapter 20-Data Virtualization, in Managing Data in Motion, A. Reeve, Editor, Morgan Kaufmann: Boston, 135-140.

Runeson, P. et al. (2012). Case Study Research in Software Engineering: Guidelines and Examples. Case Study Research in Software Engineering: Guidelines and Examples. John Wiley and Sons.

Santos, K. S. S., L. B. L. Pinheiro & R. S. P. Maciel (2021). Interoperability Types Classifications: A Tertiary Study. in 17th Brazilian Symposium on Information Systems: Intelligent and Ubiquitous Information Systems: New Challenges and Opportunities, SBSI 2021. Association for Computing Machinery.

Schönreiter, I. M. (2018). Methodologies for process harmonization in the post merger integration phase - a literature review. Business Process Management Journal.

Sreemathy, J. et al. (2021). Data Integration and ETL: A Theoretical Perspective. In 2021 7th International Conference on Advanced Computing and Communication Systems (ICACCS).

Van der Lans, R. F. (2012). Chapter 1-Introduction to Data Virtualization, in Data Virtualization for Business Intelligence Systems, R. F. van der Lans, Editor, Morgan Kaufmann: Boston, 1-26.

Yin, R. K. (2018). Case Study Research and Applications: Design and Methods. Sixth Edition ed., Thousand Oaks, California 91320: SAGE Publications, Inc.

Young Lee, S. (2018). Architecture for Business Intelligence in the Healthcare Sector. in IOP Conference Series: Materials Science and Engineering. Institute of Physics Publishing.

Zhang, H. et al. (2021). Processes, challenges and recommendations of Gray Literature Review: An experience report. Information and Software Technology, 137.