Design and Implementation for Decision Support System of Drug Administration Based on Data Warehouse
|School||Zhejiang University of Technology|
|Course||Control Theory and Control Engineering|
|Keywords||Drug regulatory Data warehouse ETL Data Mining OLAP|
With the continuous development of the pharmaceutical industry , more and more data is accumulated in the pharmaceutical distribution market , making the drug regulatory difficulty is increasing, and traditional database system has been unable to meet increasing regulatory requirements . In response to this reality , through in-depth analysis of the characteristics of the real world demands of the drug regulatory data warehouse and data mining technology to the drug regulatory system , decision support . The main contents are as follows : 1 full analysis of the existing drug regulatory database structure , combined with the characteristics of the drug regulatory and related data warehouse technology principle , the detailed design of pharmaceutical data warehouse structure . 2 data based on the current drug database characteristics and structural features , combined with the designed drug data warehouse , ETL tools are designed and implemented , incremental data update solutions and similar repetitive data processing solutions . Completion of data warehousing , design the drug data cube model , OLAP operations . 3 drug sales data , in-depth study of the principles and application of the decision tree algorithm and the algorithm of association rules , and use these two algorithms for data mining of drug sales data , and found useful knowledge , and drug supervision departments to provide decision support . 4 based on previous theoretical support , systems analysis and design solutions using C # language and Microsoft Database Tools drug regulatory decision support system . Details of the system design , architecture and each module implementation details and functionality .