SQL查询技术在全样本处方点评中的应用

Application of SQL Query Technology in Full Sample Size Prescription Reviews

目的研究建立可操作性、灵活性和实用性的处方评价方法。方法利用SQL查询技术在医院信息系统中提取特定时间段内的处方信息,对全样本处方数据进行多项指标的统计分析。结果共查询2010年全年处方74 366张,执行Select查询语句7次,统计处方评价核心指标6项。统计结果的真实性和工作效率均大大优于传统统计方法。结论 SQL查询技术可用于全样本处方点评,具有快速准确高效的优点。

Objective To establish an operational flexible and practical method of prescriptions evaluation.Methods The prescription information in a given time period was extracted from hospital information system by SQL query technology.The indexes of full sample size prescriptions were analysized.Results A total of 74 366 prescriptions in 2010 were retrieved,7 SQL queries were executed and 6 core indexes of prescriptions evaluation were analysed.The average response time of queries was less than 0.175 seconds.This method was more authentic and efficient than the traditional one.Conclusion SQL query technology can be applied in full sample size prescription reviews,which is quick,exact and efficient.