Optimal design and application of information management system of biobank in hospitals / 中华医学科研管理杂志

Objective:To establish a standardized information management system (IMS) for preserving, managing, querying, and performing statistics on biospecimens and their clinical data, which is conducive to improving the utilization of biobank.Methods:Under the premise of ensuring operating environment and data security, a database-based data logic relationship model is created and applied to the IMS to manage and analyze biospecimens and their supporting clinical information of patients enrolled in the biobank of our center.Results:To ensure the establishment of the follow-up cohort, biospecimens and clinical information of inpatients and outpatients were continuously collected in the biobank of our center. Since December 2014, more than 270 000 biospecimens from inpatient, outpatient, and scientific research have been preserved. The IMS optimized by this model efficiently completes the basic work of the biobank. At the same time, the data can be queried jointly and in batches, and then converted into a report format for statistical analysis.Conclusions:The IMS of our center is suitable for application and popularization as a construction and management model for the hospital-level biobank, which meets the daily work of the biobank and diverse research needs, and provides a convenient platform and rich resources for the development of precision medicine.

Valoración de disparadores de consulta para optimizar la oportunidad de acceso a los cuidados paliativos en la UCI / Assessment of consultation triggers to optimize the opportunity to access palliative care in the ICU / Avaliação dos critérios de elegibilidade para otimizar a oportunidade de acesso aos cuidados paliativos na UTI

Resumen: Introducción: los cuidados paliativos (CP) son un marcador de calidad de asistencia en terapia intensiva; sin embargo, han sido poco evaluados en Uruguay. La detección proactiva de pacientes mediante disparadores de consultas es una estrategia que podría optimizar el acceso a los CP. Objetivos: determinar la prevalencia y las características de los disparadores de consulta de CP en pacientes críticos. Analizar la utilización de recursos en estos pacientes. Material y método: estudio de cohorte, retrospectivo, que incluyó pacientes ingresados a unidad de cuidados intensivos (UCI) entre marzo de 2016 y febrero de 2019. Los disparadores analizados fueron: a) presencia de tumor con metástasis; b) estadía en UCI 50% por encima de la media (14 días); c) >75 años con disfunción orgánica múltiple, y d) >80 años con dos o más comorbilidades graves. Resultados: se analizaron 2.850 pacientes. El 26% (734) presentó al menos un disparador de consulta con CP. El más prevalente: estadía en UCI 50% por encima de la media (18%). Estos pacientes presentaron mayor edad: 61 (43-75) vs 54 (36-65) años (p < 0,001) y mayor gravedad, SAPSIII de 60 (48-74) vs 47 (35-61) puntos (p<0,001). Requirieron más asistencia respiratoria mecánica (ARM) 87% vs 55% (p <0,001), vasopresores 48% vs 24% (p< 0,001) y hemodiálisis 8% vs 4% (p<0,001). Presentaron mayor estadía 18 (9-27) vs 4 (2-8) días, (p<0,001) y tiempo en ARM 14 (7-23) vs 3 (1- 6) días (p<0,001). Conclusiones: la cuarta parte de los pacientes en UCI activaron al menos un criterio de CP, presentaron mayor gravedad y utilizaron más sostén de soporte vital.

Summary: Introduction: palliative care (PC) constitutes a marker of the quality of intensive care assistance. However, it has not been thoroughly assessed in Uruguay. Proactive detection of patients by means of "consultation triggers" should be considered a strategy to optimize access to PC. Objetives: to determine the prevalence and characteristics of Palliative Care consultation triggers in critical patients. To analyse the use of resources in these patients. Method: retrospective cohort study of patients admitted in the ICU between March 2016 and February 2019. The following triggers were identified: a) a tumor with metastasis; length of stay at the ICU 50% over the average (14 days), c) >75 years old with multiple organic dysfunction and d) >80 years old with 2 or more severe comorbidities Results: 2.850 patients were analysed. 26% (734) presented at least one consultation trigger with PC. Length of stay at the ICU 50% over average (18%). These patients presented higher average age 61 (43-75) versus 54 (36-65) years old (p < 0.001), and increased severity, SAPSIII of 60 (48-74) compared to 47 (35-61) points (p<0.001); 87% required mechanical ventilation compared to 55% (p <0.001), vasopressors 48% compared to 24% (p< 0.001) and hemodialysis 8% compared to 4% (p<0.001). 18 presented a longer stay (9-27) compared to 4 (2-8) days, (p<0.001) and time on mechanical ventilation 14 (7-23) compared to 3 (1- 6) days (p<0.001). Conclusions: 25 percent of patients in the ICU activated at least one criterion for PC, they were in a more severe condition and used more mechanical ventilation.

Resumo: Introdução: os cuidados paliativos (CP) são um marcador de qualidade da atenção em Terapia Intensiva, porém, pouco avaliados no Uruguai. A detecção proativa de pacientes usando "gatilhos de consulta" é uma estratégia que pode otimizar o acesso aos CP. Metas: determinar a prevalência e as características dos critérios de elegibilidade de CP em pacientes críticos. Analisar o uso de recursos nesses pacientes. Materiais e métodos: estudo de coorte retrospectivo, incluindo pacientes internados na UTI entre março de 2016 e fevereiro de 2019. Os critérios analisados foram: a) presença de tumor com metástase, b) permanência na UTI 50% acima da média (14 dias), c ) >75 anos com disfunção de múltiplos órgãos e d) >80 anos com 2 ou mais comorbidades graves. Resultados: 2.850 pacientes foram analisados. 26% (734) apresentaram pelo menos 1 critério de elegibilidade para CP. O mais prevalente foi a permanecia na UTI 50% superior à média (18%). Esses pacientes tinham mais de 61 anos (43-75) vs 54 (36-65) anos (p <0,001) e condições mais graves, SAPSIII de 60 (48-74) vs 47 (35-61) pontos (p <0,001). Necessitaram mais ventilação mecânica assistida (AVM) 87% vs 55% (p <0,001), vasopressores 48% vs 24% (p <0,001) e hemodiálise 8% vs 4% (p <0,001). Tiveram uma permanência mais prolongada 18 (9-27) vs 4 (2-8) dias, (p <0,001) e tempo em AVM 14 (7-23) vs 3 (1-6) dias (p <0,001). Conclusões: um quarto dos pacientes internados na UTI ativou pelo menos um critério de elegibilidade para CP, apresentou maior gravidade e utilizou mais suporte vital.

Analysis of Disaster Prescriptions Received at a Pharmacy after the Kumamoto Earthquake / 医薬品情報学

Objective: Soon after two massive earthquakes in Kumamoto, Japan, on April 14 and 16, 2016, the Shirakawasuigen pharmacy located in the Minamiaso village received prescriptions for disaster medications. Since prescriptions for disaster medications are typically used at temporary emergency shelters, pharmacies usually do not receive requests for them. On checking the content of these prescriptions, we found numerous prescription errors and queries. This study aimed to assess issues with dispensing medications after disasters.Methods: We reviewed all disaster medication prescriptions received by the pharmacy from April 20 to May 28, 2016 and the medication histories of these patients. We confirmed each patient’s data and medical and medication histories. Furthermore, we classified disaster prescription errors and queries into five categories according to their content and summed them in each category.Results: We obtained patients’ medical and medication histories from 100 (77.5%) of the 129 prescriptions received. Of the 129 prescriptions, a total of 158 prescription errors and queries pertaining to 96 (74.4%) prescriptions were confirmed: 88 (55.7%) for unclear medication usage and dosages, 22 (13.9%) for incorrect medication names, 34 (21.5%) for pharmaceutical queries, 8 (5.1%) for exceeding fixed prescription days (within seven days), and 6 (3.8%) for other issues.Conclusion: Nearly 80% of the prescriptions for disaster medications had prescription errors and queries. Therefore, we evaluated that the prescription’s format and entry method can be improved. Furthermore, to ensure a smooth drug supply and to reduce prescription entry deficiencies and formal prescription queries, pharmacists need to effectively manage disaster prescriptions.

Teleodontología para la atención de pacientes durante la pandemia de la COVID-19. Revisión de literatura / Teleodontology for patient care during the COVID-19 pandemic. Literature review

Objetivo: describir las aplicaciones de la teleodontología para la atención de pacientes durante y posterior a la pandemia de la COVID-19. Método: la búsqueda de artículos sobre teleodontología se realizó en las bases de datos PubMed, EMBASE, EBSCO, SCOPUS, ClinicalKey y LILACS, para identificar estudios publicados en inglés, español y portugués; se incluyeron estudios que contenían las palabras claves teleodontología y COVID-19, publicados desde enero a diciembre de 2020 y que estuvieran completos. La calidad de los artículos se evaluó según las directrices PRISMA-P. Resultados: se identificaron 49 artículos y se incluyeron 14 para la evaluación. De estos estudios, dos eran descriptivos (test de diagnóstico), seis eran estudios descriptivos de corte transversal, cinco eran pruebas pilotos; se identificó, además, un estudio de diseño retrospectivo. Se presenta la teleodontología como alternativa para diagnósticos y tratamientos de enfermedades bucales en tiempos de pandemia, mediante uso de dispositivos móviles, teleorientación y fotografías. La mayoría de los estudios presentaron un riesgo de sesgo de moderado a alto. Conclusión: la teleodontología es una herramienta tecnológica remota para apoyar la orientación, educación y tratamiento, que permite consolidar información de manera sincrónica y asincrónica sin la necesidad del contacto directo entre odontólogo y paciente.

Objective: to describe the applications of teleodontology for patient care during and after the COVID-19 pandemic. Method: the search for articles on teleodontology was carried out in the PubMed, EMBASE, EBSCO, SCOPUS, ClinicalKey and LILACS databases to identify studies published in English, Spanish and Portuguese; Studies that contained the keywords teleodontology and COVID-19, published from January to December 2020 and that were complete, were included. The quality of the articles was evaluated according to the PRISMA-P guidelines. Results: 49 articles were identified and 14 were included for evaluation. Of these studies, two were descriptive (diagnostic tests), six were descriptive cross-sectional studies, five were pilot tests; In addition, a retrospective design study was identified. Teleodontology is presented as an alternative for diagnosing and treating oral diseases in times of pandemic, through the use of mobile devices, remote orientation and photographs. Most of the studies were at moderate to high risk of bias. Conclusion: teleodontology is the remote tool to support remote guidance, education and treatment through technology, allowing the consolidation of information synchronously and asynchronously without the need for direct contact between dentist and patient

Calibration of Portable Particulate Matter–Monitoring Device using Web Query and Machine Learning

BACKGROUND: Monitoring and control of PM(2.5) are being recognized as key to address health issues attributed to PM(2.5). Availability of low-cost PM(2.5) sensors made it possible to introduce a number of portable PM(2.5) monitors based on light scattering to the consumer market at an affordable price. Accuracy of light scattering–based PM(2.5) monitors significantly depends on the method of calibration. Static calibration curve is used as the most popular calibration method for low-cost PM(2.5) sensors particularly because of ease of application. Drawback in this approach is, however, the lack of accuracy.METHODS: This study discussed the calibration of a low-cost PM(2.5)-monitoring device (PMD) to improve the accuracy and reliability for practical use. The proposed method is based on construction of the PM(2.5) sensor network using Message Queuing Telemetry Transport (MQTT) protocol and web query of reference measurement data available at government-authorized PM monitoring station (GAMS) in the republic of Korea. Four machine learning (ML) algorithms such as support vector machine, k-nearest neighbors, random forest, and extreme gradient boosting were used as regression models to calibrate the PMD measurements of PM(2.5). Performance of each ML algorithm was evaluated using stratified K-fold cross-validation, and a linear regression model was used as a reference.RESULTS: Based on the performance of ML algorithms used, regression of the output of the PMD to PM(2.5) concentrations data available from the GAMS through web query was effective. The extreme gradient boosting algorithm showed the best performance with a mean coefficient of determination (R²) of 0.78 and standard error of 5.0 μg/m³, corresponding to 8% increase in R² and 12% decrease in root mean square error in comparison with the linear regression model. Minimum 100 hours of calibration period was found required to calibrate the PMD to its full capacity. Calibration method proposed poses a limitation on the location of the PMD being in the vicinity of the GAMS. As the number of the PMD participating in the sensor network increases, however, calibrated PMDs can be used as reference devices to nearby PMDs that require calibration, forming a calibration chain through MQTT protocol.CONCLUSIONS: Calibration of a low-cost PMD, which is based on construction of PM(2.5) sensor network using MQTT protocol and web query of reference measurement data available at a GAMS, significantly improves the accuracy and reliability of a PMD, thereby making practical use of the low-cost PMD possible.

Complex query in hospital information system based on database intermediate table / 医疗卫生装备

Objective To improve the timeliness of complex query in hospital information system and to reduce excessive use of database resources.Methods Instead of using multi table joint query,an intermediate table was established to store the acquired results periodically,and the user realized complex query by accessing the intermediate table.Results Client inquiry software was used to execute query on statistical data,and it's found the inquiry speed was enhanced greatly after optimization by the intermediate table so that high-precision and-efficiency inquiry could be implemented in big data.Conclusion The intermediate table contributes to executing complex query in hospital information system,and thus is worthy promoting for the precision management in hospital data center.

Comparative Analysis of Linguistic Features in Medical Knowledge Base / 医学信息学杂志

Taking Physician Data Query (PDQ(R)),which is provided for doctors and patients by National Cancer Institute (NCI),for example,the paper carries out comparative analysis on professional and public editions of PDQ from the perspective of vocabulary and syntax to make clear the significant statistical difference between the knowledge bases facing patients and doctors.

Design and implementation of Chinese materia medica resources survey results display system / 中国中药杂志

From the beginning of the fourth national census of traditional Chinese medicine resources in 2011, a large amount of data have been collected and compiled, including wild medicinal plant resource data, cultivation of medicinal plant information, traditional knowledge, and specimen information. The traditional paper-based recording method is inconvenient for query and application. The B/S architecture, JavaWeb framework and SOA are used to design and develop the fourth national census results display platform. Through the data integration and sorting, the users are to provide with integrated data services and data query display solutions. The platform realizes the fine data classification, and has the simple data retrieval and the university statistical analysis function. The platform uses Echarts components, Geo Server, Open Layers and other technologies to provide a variety of data display forms such as charts, maps and other visualization forms, intuitive reflects the number, distribution and type of Chinese material medica resources. It meets the data mapping requirements of different levels of users, and provides support for management decision-making.

Cytospace-based parameterized SPARQL query system for biomedical ontology / 中华医学图书情报杂志

It is necessary to provide a SPARQL query tool for biomedical researchers due to the massive data of bi-omedical ontology. However, manual input of SPARQL query statements is quite complicated and easy to produce errors. A Cytospace-based parameterized SPARQL query system was thus developed for biomedical ontology, which can generate a module with SPARQL query conditions used as parameters. Biomedical researchers can thus rapidly, easily and directly retrieve the data in several biomedical ontology knowledge libraries instead of manual input of SPARQL query statements.

Use of Graph Database for the Integration of Heterogeneous Biological Data

Understanding complex relationships among heterogeneous biological data is one of the fundamental goals in biology. In most cases, diverse biological data are stored in relational databases, such as MySQL and Oracle, which store data in multiple tables and then infer relationships by multiple-join statements. Recently, a new type of database, called the graph-based database, was developed to natively represent various kinds of complex relationships, and it is widely used among computer science communities and IT industries. Here, we demonstrate the feasibility of using a graph-based database for complex biological relationships by comparing the performance between MySQL and Neo4j, one of the most widely used graph databases. We collected various biological data (protein-protein interaction, drug-target, gene-disease, etc.) from several existing sources, removed duplicate and redundant data, and finally constructed a graph database containing 114,550 nodes and 82,674,321 relationships. When we tested the query execution performance of MySQL versus Neo4j, we found that Neo4j outperformed MySQL in all cases. While Neo4j exhibited a very fast response for various queries, MySQL exhibited latent or unfinished responses for complex queries with multiple-join statements. These results show that using graph-based databases, such as Neo4j, is an efficient way to store complex biological relationships. Moreover, querying a graph database in diverse ways has the potential to reveal novel relationships among heterogeneous biological data.

Design and Implementation of Online Medical Examination Report Query System / 医学信息学杂志

The paper introduces the design and implementation of residents online medical examination report query system based on cloud platform,including the system architecture,process,data structure,security and necessary controls,etc.This system makes it able for the residents to check their medical examination reports and corresponding video pictures whenever and wherever possible on the Internet.

Research on Information Organization Mode of Chinese Medicine Based on Multidimensional Data Model / 世界科学技术-中医药现代化

The information organization mode of Chinese medicine is a key factor of meeting informational or analytical demands on Chinese medicine. This paper summarized the research status on information organization mode of Chinese medicine by using the basic principle of multidimensional data model, designing basic dimensions of Chinese medicine and its concept hierarchies. Finally, with an example of information query, this paper designed the multidimensional data model of Chinese medicine based on the star pattern and a multidimensional query system of Chinese medicine information. Based on the multidimensional data model, the information organization mode of Chinese medicine can provide powerful supports for the multi-angle and multi-level query using of Chinese medicine information.

The ASP .NET-based Hospital Integrated Query System for Graphic Reports / 医学信息学杂志

The paper elaborates the utilization status of the graphic reports system in hospitals, proposes that ASP .NET technology should be applied to realize the web-based hospital integrated query system for graphic reports, analyzes the advantages of applying ASP .NET technology and introduces the concrete realization of the integrated query system.This system solves the problem that graphic reports are unable to be queried simultaneously, resulting from differences between various internal reporting systems in hospitals.

Design and establishment of poisoning and rescue database query system / 中国药学杂志

OBJECTIVE: To design and establish poisoning and rescue database query system, realize the fast query of poison and rescue drug information, accumulate poisoning case information, provide the reference for clinical treatment of poisoning patients. METHODS: Using Delphi 7.0 as the development platform, Microsoft Access as database management system, ADO data access mode and OLE automation technology. RESULTS: Design and establish the poisoning and rescue database query system successfully. CONCLUSION: In addition to the traditional query function, the database query system also provides poisoning reports upload, poison information announcement and poison database links. The system operation is simple and convenient, it's expected to become a good helper for clinical medical workers, and play a role in prevention and control of poisoning.

Research on the design and accomplishment of the system of computing and storing wound area / 中国医学装备

Objective:To design a system of computing and storing wound area. Methods:Visual C++6.0 platform has been used to develop the application.With image processing and by means of ADO, the wound area can be calculated and stored in the Access 2003 databse. Results:The system has achieved the expected effect which can be proved by measuring animal model and saving reaults. It can calculate the wound area and save the relative information fast. Conclusion:This system is qualified for computing and storing wound area and can search the information stored as well. Not only can it provide doctors with accurate information,but also bring patients convenience.

Research on the Development of Translation Disambiguation Technology in Cross - language Information Retrieval / 医学信息学杂志

The paper introduces the connotation and development of cross - language information retrieval (CLIR), furthermore, ten kinds of translation disambiguation techniques are demonstrated as following. In addition it carries out contrastive analysis and expla-nation of disambiguation from four aspects, including core foundation, application status, potential improvement and development pros-pects. On this base it summarizes the status and development trends and proposes several directions of future research.

Development and Evaluation of Classification Codes and Retrieval Program of the Interpretation of Nuclear Medicine Imaging Studies / 대한의료정보학회지

OBJECTIVE: To evaluate usefulness of the classification codes and retrieval program of the interpretation of nuclear medicine imaging studies. METHODS: We retrieved specific results of the interpretation of 3,613 nuclear medicine imaging studies from database server of the Chonnam National University Hwasun Hospital using classification code retrieval program or by searching narrative phrases using structured query language(SQL). Accuracy of the retrieved results as well as retrieval time in each group were compared. RESULTS: Retrieved results using SQL showed lower accuracy than those using classification codes. There was no delay of response or overload of network traffic whether we used either retrieval program or SQL. CONCLUSION: Retrieval of specific results from database of the interpretation of nuclear medicine imaging studies using classification codes with retrieval program was more accurate and convenient than searching narrative phrases using SQL.

Design and realization of medical information query system based on three-tier architecture / 医疗卫生装备

Three-tier architecture develops the traditional C/S architecture and stands for application's future.This paper compares C/S architecture with three-tier architecture and designs one medical information query system using three-tier architecture technique.

Implementation of Multi-condition Combination Query Based on PowerBuilder Datawindow / 医疗卫生装备

Objective To perform multi -condition combination query in the browse window based on PowerBuilder datawindow technology. Methods After the interested combination of query conditions specified on certain columns in datawindow was constructed by if...then statement, the setfilter () and filter () function was used to retrieve and display data which met the filter criteria. Results A flexible query object was incorporated into the data browsing window. Conclusion The datawindow-based query is suitable for situations where batch of data are filtered against not so many columns.

Development and Application of Medical Equipment Management Information System / 医疗卫生装备

Objective To develop medical equipment management information system for medical engineering department. Methods Under PowerBuilder9.0/SQL and Server2000 development environment, the C/S mode system structure was adopted, and the system function modules, such as data input, browsing, querying, statistical analyzing, report generating, were designed. Results Data exchange between client and server was realized. Meanwhile, the designed function modules achieved normal operation. Conclusion The system structure and functions meet the requirements of working practice in medical engineering department.