A Research on SQL Server Association Rules in Data Mining forZhizichi Decoction Analogous Prescriptions / 中国中医药信息杂志

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.