|
|
|
| Work mode of medical and health statistics based on database management structure |
| Tian Qi. |
| Guangzhou Health Information Center,Guangzhou 510180,China |
|
|
|
|
Abstract Objective To solve the problems in hospital statistical work quickly and accurately. Methods Data Center warehouse was established by using database management structure, and SQL statement was used for query and statistical indicators. Results Data warehouse can quickly and accurately obtain the data and indicators needed for statistical work. Conclusion Health statistical work mode based on database management structure is highly operable, It can solve the problem that the hospital information system is operated by its own business and the SQL language of database is easy to learn and popularized.The working mode can be popularized and copied for the statistical work of each hospital.
|
|
Received: 03 March 2020
|
|
|
|
[1]王珊，萨师爐.数据库系统概论[M].北京：高等教育出版社，2006.
[2]屠海波.应用SQL语言进行数据查询与统计[J].中国卫生统计，2007,24（4)：424425.
[3]吴晓云，郑银雄，冯笑玲.基于数据库的医院病案信息SQL查询[J].中国卫生统计，2014，31(1):144.
[4]许泽杰，丁赞.运用SQL语言对病案首页数据质量进行监控的实例分析[J].中国卫生统计，2018，35(3):1-2.
[5]王芳，宋蓉.医院统计分析要抓好五方面工作[J].中国医院统计.2017，24(2)：159-160.
[6]顾晓鸣.运用Select编写锁定警示语句审核病案首页信息[J].中国医院统计，2008,15（2):117-119.
[7]周琴.掌握SQL查询提高统计效率[J].中国医院统计.2008，15（2):100-101.
[8]刘冬生，欧阳菊香，王尔笑，等.基于SQL的重点疾病和重点手术查询统计[J].中国卫生统计，2015，32(5)：863-864.
[9]李向红，高月华.提高医院统计工作质量促进医院科学管理水平中国卫出统计201128/3)，352
|
| [1] |
Shi Wenzong, Liu Ruiji, Yang Yi. . Discussion on the management mode of the statistical work of the hospital in the new situation of the medical reform[J]. journal1, 2020, 27(2): 153-155. |
| [2] |
Chen Jing, Zhang Jing. Performance appraisal of automated outpatient pharmacy based on the balanced score card principle[J]. journal1, 2019, 26(3): 204-206. |
| [3] |
Yang Yechun. Application analysis of hospital disease and operation statistics based on SQL[J]. journal1, 2019, 26(2): 111-114. |
| [4] |
. [J]. journal1, 2018, 25(4): 315-317. |
| [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] |
Liu Guozhu. Application of data mining technology in medical record database of Guangdong[J]. journal1, 2017, 24(3): 179-182. |
|
|
|
|
