Construction Of Data Warehouse And Preliminary Association Analysis Based On The Standards Of Chinese Medicinal Materials In Yunnan Province

With the development of database technology and data analysis technology,information technology has permeated all fields. Many places are to commonly usedmedicines and national medical herbs, meanwhile write the Chinese standard, theconstant research of medicinal materials, these standards is more and more perfect,more authoritative, guidance, and representative. This topic is proposed to build upYunnan province standard data warehouse based on traditional Chinese medicinalmaterials, to research the basic information and data in data warehouse, Chineseherbal medicine medicinal properties and functions of data. All is to explore providesnew train of thought and method for study on traditional Chinese medicinal materialsin Yunnan province.This paper aims to analysis the "standard of Chinese medicinal materials inYunnan province" concluding306taste the effect of commonly used medicinalmaterials and medicinal information, and standardization of data processing throughthe system of collecting, sorting. Using the cutting edge of data warehouse technology,medicinal herbs in the standard data analysis, extraction, and establish the theme,based on the Windows Server2003operating system, Use the Microsoft SQL Server2008database management platform for organizing data effectively, and build thedata warehouse model.Based on the built data warehouse system, we studied the association rulesbetween the potency and efficacy of Chinese medicine by means of data mining. Ittakes the Microsoft SQL Server2008database management platform for statisticalanalysis and data mining, basic information, and then summing rules, based on theknown empirical knowledge, verification, implementation of data analysis andresearch, by means of traditional Chinese medicine statistical analysis, correlationanalysis, association analysis, medicinal efficacy with correlation analysis.This paper mainly studies the following aspects:1. It mainly collects and sorts out the data in the "standard of Chinese medicinalmaterials in Yunnan province", then analyses and preprocesses a large number of data,to extract the theme of building a data warehouse.2. It takes the SQL Server2008integrated Business Intelligence DevelopmentStudio platform to create and use the data mining model. 3. It introduces and takes the SQL Server2008to provide the algorithm ofassociation rules from the multi-level and multi-angle basic information, medicinalproperties, efficacy of Chinese herbal medicine for data mining and analysis.