Data warehouse para el Centro de Documentación Regional "Juan Bautista Vázquez"

El proceso de toma de decisiones en las bibliotecas universitarias es de suma importancia, sin embargo, se encuentra complicaciones como la gran cantidad de fuentes de datos y los grandes volúmenes de datos a analizar. Las bibliotecas universitarias están acostumbradas a producir y recopilar una gran cantidad de información sobre sus datos y servicios. Las fuentes de datos comunes son el resultado de sistemas internos, portales y catálogos en línea, evaluaciones de calidad y encuestas. Desafortunadamente estas fuentes de datos sólo se utilizan parcialmente para la toma de decisiones debido a la amplia variedad de formatos y estándares, así como la falta de métodos eficientes y herramientas de integración. Este proyecto de tesis presenta el análisis, diseño e implementación del Data Warehouse, que es un sistema integrado de toma de decisiones para el Centro de Documentación Juan Bautista Vázquez. En primer lugar se presenta los requerimientos y el análisis de los datos en base a una metodología, esta metodología incorpora elementos claves incluyendo el análisis de procesos, la calidad estimada, la información relevante y la interacción con el usuario que influyen en una decisión bibliotecaria. A continuación, se propone la arquitectura y el diseño del Data Warehouse y su respectiva implementación la misma que soporta la integración, procesamiento y el almacenamiento de datos. Finalmente los datos almacenados se analizan a través de herramientas de procesamiento analítico y la aplicación de técnicas de Bibliomining ayudando a los administradores del centro de documentación a tomar decisiones óptimas sobre sus recursos y servicios.The decision-making process in academic libraries is paramount; however highlycomplicated due to the large number of data sources, processes and high volumes ofdata to be analyzed. Academic libraries are accustomed to producing and gatheringa vast amount of statistics about their collection and services. Typical data sourcesinclude integrated library systems, library portals and online catalogues, and systemsof consortiums and quality surveys. Unfortunately, these heterogeneous datasources are only partially used for decision-making processes due to the wide varietyof formats, standards and technologies, as well as the lack of efficient methods ofintegration. This thesis presents the analysis, design and implement of Data Warehousefor an academic library \Juan Bautista Vázquez". Firstly, an appropriatemethodology documented in a previous study is used for data collection. This methodology incorporates key elements including process analysis, quality estimation, information relevance and user interaction that may influence a library decision. Based on the above mentioned approach, this study defines a set of queries of interestto be issued against the integrated system proposed. Then, relevant data sources,formats and connectivity requirements for a particular example are identified. Next,Data Warehouse architecture is proposed to integrate, process, and store the collecteddata transparently. Eventually, the stored data are analyzed through reportingtechniques of analytical processing and prototype of Bibliomining. By doing so, thethesis provides the design of an integrated solution that assists library managers tomake tactical decisions about the optimal use and leverage of their resources and ofservices.Ingeniero de SistemasCuenc

An automatic method for the enrichment of DICOM metadata using biomedical ontologies

This work is a novel contribution for enriching medical images using semantic annotations with a strategy for unifying different ontologies and instances of DICOM medical files. We present the L-MOM library (Library for Mapping of Ontological Metadata) as a tool for making an automatic mapping between instances of DICOM medical files and different medical ontologies (e.g., FMA, RadLex, MeSH). The main contributions are: i) the domain independent L-MOM library which is able to integrate DICOM metadata with ontologies from different domains; ii) a strategy to automatically annotate DICOM data with universally accepted medical ontologies, and provide values of similarity between ontologies and DICOM metadata; and iii) a framework to traverse ontological concepts that characterized clinical studies of patients registered in the framework catalog.Mila

Diseño e Implementación de un Sistema de Soporte de Decisiones para el Centro de Documentación Regional “Juan Bautista Vázquez”

In recent years, volume of library-related data has increased tremendously, as well as complexity of data sources and formats has 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. 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.status: publishe

Grid platform for medical federated queries supporting semantic and visual annotations

Grid computing has been successfully applied on teleradiology, leading to the creation of important platforms such as MEDICUS, VirtualPACS and mantisGRID, among others. These platforms are studied on the basis of their available documentation in order to compare and discuss differences and similarities, advantages and disadvantages between them. Then, a grid platform architecture is proposed, based on the best features of the surveyed platforms with an additional emphasis on general federated queries involving CBIR (Content-Based Image Retrieval) and Semantic Annotations.Ecuado

WebMedSA: A web-based framework for segmenting and annotating medical images using biomedical ontologies

Advances in medical imaging have fostered medical diagnosis based on digital images. Consequently, the number of studies by medical images diagnosis increases, thus, collaborative work and tele-radiology systems are required to effectively scale up to this diagnosis trend. We tackle the problem of the collaborative access of medical images, and present WebMedSA, a framework to manage large datasets of medical images. WebMedSA relies on a PACS and supports the ontological annotation, as well as segmentation and visualization of the images based on their semantic description. Ontological annotations can be performed directly on the volumetric image or at different image planes (e.g., axial, coronal, or sagittal); furthermore, annotations can be complemented after applying a segmentation technique. WebMedSA is based on three main steps: (1) RDF-ization process for extracting, anonymizing, and serializing metadata comprised in DICOM medical images into RDF/XML; (2) Integration of different biomedical ontologies (using L-MOM library), making this approach ontology independent; and (3) segmentation and visualization of annotated data which is further used to generate new annotations according to expert knowledge, and validation. Initial user evaluations suggest that WebMedSA facilitates the exchange of knowledge between radiologists, and provides the basis for collaborative work among them.Ecuado

Mobile teleradiology system suitable for m-health services supporting content and semantic based image retrieval on a grid infrastructure

Teleradiology systems tackle the problem of transferring radiological images between medical image workstations for facilitating different medical activities, e.g., diagnosis, treatment and follow up a patient, medical training, or consulting second opinion. Nowadays, m-Health (aka mobile health) is becoming popular because of high quality of mobile displays, although remains a work in progress. In this paper a mobile teleradiology system is reported, which main contribution is the development of a platform: (1) supported by a Grid infrastructure, (2) using biomedical ontologies for adding semantic annotations on medical images, and (3) supporting semantic and content-based image retrieval. Images are located physically in different repositories like; hospitals and diagnostic imaging centers. All these features make the system ubiquitous, portable, and suitable for m-Health services.Orlando Florid

Maskana. Revista Científica

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.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.CuencaVolumen 5 (2014

Maskana. Revista Científica

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.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.CuencaVolumen 5 (2014

Maskana. Revista Científica

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.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.CuencaVolumen 5 (2014

Medicina de Urgencias Tomo 1

Public health represents one of the greatest challenges in society, which is why it is essential to strengthen the links of scientific cooperation between the academy and the community under a common premise: guarantee the health of the population. In Ecuador, public health faces a historical challenge framed by two edges: the health crisis due to the Covid-19 pandemic and the shortcomings of the social system. This leads to thinking about both the importance of the problem and its possible solutions. Despite this, it is undeniable to affirm that all health personnel share a common ideology and the same commitment, guaranteeing the health of the population.Obviously it is not an easy task due to social uncertainty and the possible appearance of new diseases; however, it is based on a common denominator: basing decisions on the available scientific evidence or what is known as evidence-based medicine. The generation of new knowledge and the use of the best available scientific evidence is the only hope for solving the health problems that afflict the population. In this way, Emergency Medicine seeks to be a timely and practical clinical-therapeutic reference point for emerging regional circumstances, using updated international management guidelines as references and emphasizing evidence-based medicine. We are sure that it will be an invaluable contribution for health professionals.Emergency Medicine, in its two volumes, is a work carried out by teachers, students and medical and related specialists, from the Medicine and Nursing career of the Catholic University of Cuenca, Azogues Campus. In addition, it has the contribution of other medical specialists with extensive professional experience and contributes with 52 chapters that address clinical, surgical, pediatric, and gynecological-obstetric pathologies that require timely management in the emergency room. At the same time, this work addresses topics of current interest such as medicolegal aspects of emergency care, urgent complications in HIV infections, use of antimicrobials in emergencies, dose adjustment in patients with kidney failure; and, a special chapter on SARS-CoV-2: diagnostic-therapeutic management.La salud pública representa uno de los retos más grandes en la sociedad, razón por lo cual es fundamental que se robustezcan los vínculos de cooperación científica entre la academia y la colectividad bajo una premisa común: garantizar la salud de la población. En Ecuador, la salud pública afronta un reto histórico enmarcado en dos aristas: la crisis sanitaria debido a la pandemia por Covid-19 y las carencias del sistema social. Esto conduce a pensar tanto en la trascendencia del problema como en sus posibles soluciones. A pesar de aquello, resulta innegable afirmar que todo el personal sanitario comparte una ideología en común y el mismo compromiso, garantizar la salud de la población. Evidentemente no constituye una tarea fácil debido a la incertidumbre social y a la posible aparición de nuevas enfermedades; sin embargo, se basa en un denominador común: asentar las decisiones en la evidencia científica disponible o lo que se conoce como medicina basada en la evidencia. La generación de nuevo conocimiento y la utilización de la mejor evidencia científica disponible constituye la única esperanza para resolver los problemas de salud que aquejan a la población. De esta forma, Medicina de Urgencias busca ser un referente clínico- terapéutico, oportuno y práctico, de las circunstancias emergentes regionales, tomando como referencias guías de manejo internacionales actualizadas y haciendo hincapié en la medicina basada en la evidencia. Estamos seguros que será un aporte de carácter invaluable para los profesionales de la salud. Medicina de urgencias, en sus dos volúmenes, es una obra realizada por docentes, estudiantes y especialistas médicos y afines, de la carrera de Medicina y Enfermería de la Universidad Católica de Cuenca, Sede Azogues. Además, cuenta con el aporte de otros médicos especialistas con amplia trayectoria profesional y aporta con 52 capítulos que abordan patologías clínicas, quirúrgicas, pediátricas, y gíneco-obstétricas, que requieren manejo oportuno en la sala de emergencias.  Al mismo tiempo, la presente obra aborda temáticas de interés actual como aspectos médico legales de la atención en urgencias, complicaciones urgentes en las infecciones por VIH, uso de antimicrobianos en emergencias, ajuste de dosis en pacientes con insuficiencia renal; y, un capítulo especial sobre el SARS-CoV-2: manejo diagnóstico-terapéutico