A Research on SQL Server Association Rules in Data Mining forZhizichi Decoction Analogous Prescriptions
10.3969/j.issn.1005-5304.2015.01.013
- VernacularTitle:关联规则在栀子豉汤类方数据挖掘中的应用
- Author:
Jingxian ZHU
;
Qianmin SU
;
Dexing CHEN
;
Jinglei GUO
;
Xiaoping WEN
- Publication Type:Journal Article
- Keywords:
Zhizichi Decoction;
compatibility law;
association rules;
data mining
- From:
Chinese Journal of Information on Traditional Chinese Medicine
2015;(1):43-46
- CountryChina
- Language:Chinese
-
Abstract:
Objective To discuss the specific role of association rules in the compatibility of herbs and the relationship between herbs and symptoms by analyzing ancient analogous prescriptions Zhizichi Decoction with SQL Server software.Methods The prescriptions which contain Gardenia and Semen Sojae Preparatum were searched in the database of “Ancient Prescriptions for Epidemic Disease”, and they were imported to software with the standardized data of their symptoms and ingredients, then the proper association rules were found. The laws between parameter setting and rule generation were searched through parameter adjustment.Results Many laws of the drug compatibility and relationship between herbs and symptoms were obtained effectively in data mining by adjusting the parameters:The support setting was good for finding common used drug compatibility, and the confidence was good for finding specific drug compatibility and relationship between herbs and symptoms;the item set which had high frequency, sometimes made the rule’s importance low.Conclusion The laws of compatibility of herbs and the relationship between herbs and symptoms for data mining of analogous prescriptions are discovered by analyzing the support, confidence and importance of the association-rules and the clinical magnificence between symptoms and herbs.