基于数据库管理结构的医疗卫生统计工作模式探讨  

Work mode of medical and health statistics based on database management structure

作　　者：田琪 Tian Qi(Guangzhou Health Information Center,Guangzhou 510180,China)

机构地区：[1]广州市卫生信息中心,广东广州510180

出　　处：《中国医院统计》2020年第3期242-245,共4页Chinese Journal of Hospital Statistics

摘　　要：目的快速、准确地解决医院统计工作中遇到的问题。方法通过数据库管理结构建立数据中心仓库,运用SQL语句查询及统计指标。结果建立数据库可快速、准确地获取统计工作需要的数据及指标。结论基于数据库管理结构的卫生统计工作模式可操作性强,可解决医院信息系统各自为营的困境;操作数据库的SQL语言简单易学,普及性强,故该工作模式可推广应用到各个医院的统计工作中。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.

关 键 词：数据库 SQL 自动化 本地数据库 工作模式 数据中心 医院统计 

分 类 号：R195.1[医药卫生—卫生统计学]