Access数据库在药对关联规则分析中的应用  

Application of Access Database in Drug Pairs Association Rules Analysis

作　　者：于静[1] 杨继萍[2] 沈俊辉[3] 马星光[3] 

机构地区：[1]上海中医药大学,上海200032 [2]北京联合大学,北京100029 [3]北京中医药大学,北京100029

出　　处：《中华中医药学刊》2015年第6期1515-1518,共4页Chinese Archives of Traditional Chinese Medicine

摘　　要：目的:探索Access数据库在药对关联规则分析中应用的可行性及方法。方法:选取部分临床数据,共计122首处方,并对样例数据进行标准化处理。以Access 2013为工具,依据关联规则的Apriori算法,通过多次选择查询,生成药对项集。分别计算药对的支持度、置信度和重要性,并对产生结果进行评价。结果:通过与中医理论及临床对比,计算结果基本符合临床实际,该方法有效。结论:以Access为工具,结合相应的数据挖掘算法,通过多次查询可以完成药对的关联规则分析。建议将计算结果与临床实际结合,以获得更准确、有效的信息。Objective： To explore the feasibility and methods of the application of Access database in drug pairs association rules analysis. Methods： Randomly selected clinical data about 122 prescriptions in total,and the data was standardized. By using the Access2013 and Apriori algorithm,we generated the drug pair item sets and association rules through creating select query. And then calculated three parameters for the item sets and rules： support,probability and importance. And then evaluated them. Results： Comparing the theory of Traditional Chinese medicine and clinical data,the results are compatible with the clinical practice,and this research is effectively. Conclusions： By using the Access database,combining with proper data mining algorithm,the drug pairs association rules analysis can be accomplished.

关 键 词：药对 关联规则 ACCESS 

分 类 号：R222.19[医药卫生—中医基础理论]