论文部分内容阅读
目的 挖掘医院局域网中的数据信息 ,为医院统计和管理决策提供依据。方法 利用 SQL 数据查询语言得到统计指标 ,用 Delphi或 Excel等工具进行结果显示。结果 以某医院 2 0 0 1年 10～ 5月出院者数据为样本 ,给出了平均住院日、日均费用、占床比等逐日指标的图形结果。结论 SQL 查询是一种易学有效的工具 ,以图形的方式提供诊疗过程信息 ,直观明了 ,便于发现奇异点
Objective To excavate the data of hospital LAN and provide the basis for hospital statistics and management decision-making. Methods Using SQL data query language to obtain statistical indicators, Delphi or Excel and other tools for the results show. Results Based on the data of discharged patients from October to May in 2001 in a certain hospital, the daily results of average daily hospitalization days, average daily expenses, and bed occupancy were given. Conclusion SQL query is an easy-to-learn and effective tool to graphically provide information on the process of diagnosis and treatment, intuitive and easy to find singularities