DataX工具在新冠肺炎数据上报中的应用

Application of DataX Tool in Data Reporting of New Coronavirus Pneumonia

新冠肺炎疫情防控期间,精确的数据上报越发显得重要,国家医政医管局发文要求每天定时上传确诊和疑似患者全量医疗数据。该文重点讨论了利用DataX工具进行数据提取的方法以及该工具是否具有推广价值。搭建DataX运行环境,编写测试脚本并运行,检测输出数据各项指标,观测任务执行时间,并与之前手工模式进行对比。使用基于DataX的工具环境后,实际执行效率明显高于原先手工执行SQL语句导出数据的方式。DataX不仅能快速导出数据,而且能将不同数据库的数据抽取到目标库,实现数据的整合,此外,数据导出高效、准确,除了较好地完成本次上报任务外,还能满足医疗机构日常工作中各类数据上报的需求。

During the prevention and control of novel coronavirus pneumonia,accurate data reporting is becoming more and more important.The National Medical Administration and Hospital Authority issued a document requiring that full medical data of confirmed and suspected patients be uploaded regularly every day.We mainly discuss the method of data extraction using DataX tool and whether the tool is promoted.Set up DataX running environment,write test script and run it,test output data indicators,observe task execution time,and compare with previous manual mode.After using the tool environment based on DataX,the actual execution efficiency is significantly higher than the original way of manually executing SQL statements to export data.DataX can not only export data quickly,but also extract data from different databases to the target database to realize data integration.In addition,data export is efficient and accurate.Besides completing the reporting task,it can also meet the needs of various data reporting in the daily work of medical institutions.