SQL查询在妇产科医院统计工作中的应用

Application of SQL query in statistical work in an obstetrics and gynecology hospital

大数据背景下的医院统计工作中,结构化查询语言(SQL)查询能快速实现数据的深层检索。研究通过横向关联、纵向提取、不同时间、不同对象间4个角度的实例分析,展示应用SQL技术协助统计人员完成当下统计工作的新挑战,为医院统计方法应用提供参考。

Statistics data can be deep retrieved through SQL query in hospital statistics in the era of big data.This paper shows the application of SQL in the new challenge of hospital statistics by analyzing four examples of horizontal correlation,vertical extractions,different time correlation,and different subject correlation,to provide references for the application of hospital statistical methods.