|
|
|
| Application analysis of hospital disease and operation statistics based on SQL |
| Yang Yechun |
| Statistic Room of the First Affiliated Hospital of Guangzhou University of Traditional Chinese Medicine, Guangzhou 510405, China |
|
|
|
|
Abstract Objective To explore the application methods, advantages and disadvantages, and matters needing attention of SQL in hospital statistics and to improve work efficiency and check wrong data quickly and conveniently.Methods Through the examples of SQL in statistical monitoring of diseases, operations and disease spectrum and surgical spectrum, the application of SQL in hospital statistics was showed . Meanwhile, the advantages and disadvantages and matters needing attention were showed by inducing the differences in SQL module in eighteen key diseases and eighteen key operations.Results The use of SQL in database of medical records directly improves the efficiency of statistical work and reduces repetitive work especially in statistical monitoring. Meanwhile, SQL can be used to help check and revise original data. However, SQL is not appropriate when the statistics is more complicated such as building statistical model in hospital statistics. We should be familiar with database structure, the meaning of variables and statistical caliber because it is the premise for the application of SQL.ConclusionSQL will be a good statistical tool to help statistic monitoring and revise wrong data to improve work efficiency and because of its flexibility, it can be used as a tool to analyze data initially.
|
|
Received: 19 October 2018
|
|
|
|
|
［1］刘国柱.数据挖掘技术在广东省统计病案数据库中的运用［J］.中国医院统计,2017,24(3):179-183.
［2］RYAN KS,RONALD RP.SQL自学通［M］.陈津利,王昱,李金岭,等,译.北京:机械工业出版社,1998.
［3］广东省政务服务中心.广东省医疗机构病案统计管理系统(2012年)［EB/OL］.(2012-08-01)［2018-01-01］.https://tjzb.gdwst.gov.cn/meta/CommonData/public/login/login.
［4］中国医院协会．三级综合医院评审标准实施细则［M］．北京：人民卫生出版社,2012:214-218．
［5］岳卫萍,孙兆泉. 医院统计信息工作的转变及量化管理对策［J］.中国医院统计,2016,23(4):244-246.
［6］宋蓉.HIS环境下医院统计的数据质量问题及解决措施［J］. 中国医院统计,2016,23(2):135-137.
［7］许泽杰,丁赞.基于 Microsoft SQL Server 存储过程的院内医疗报表统计分析［J］．中国医院统计,2017,24(6):401-404．
［8］刘国柱,杨振宇,殷堰．SQL Select 语句在医院统计查询中的应用实例［J］．中国医院统计,2010,17(1):88-90．
［10］广东省政务服务中心.广东省ICD-9-CM-3 手术与操作代码(2017) ［EB/OL］. (2018-01-01)［2018-02-01］. https://tjzb.gdwst.gov.cn/meta/CommonData/public/login/login. |
| [1] |
Xia Yongmei, Li Caixia, Yu Ling, Ye Honghui. Disease spectrum of inpatients admitted to the Neurology Department in a hospital of the coastal area from 2014 to 2018[J]. journal1, 2019, 26(4): 283-285. |
| [2] |
. [J]. journal1, 2018, 25(4): 315-317. |
| [3] |
. [J]. journal1, 2018, 25(2): 158-160. |
| [4] |
. [J]. journal1, 2018, 25(1): 75-76. |
| [5] |
Xu Zejie, Ding Zang. The statistical analysis of using Microsoft SQL Server stored procedure to making hospital business statements and reports[J]. journal1, 2017, 24(6): 401-403. |
| [6] |
. [J]. journal1, 2017, 24(3): 231-233. |
|
|
|
|
