Dissertation > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems

Design and Implementation for Decision Support System of Drug Administration Based on Data Warehouse

Author HuangGuoJun
Tutor HaoPing
School Zhejiang University of Technology
Course Control Theory and Control Engineering
Keywords Drug regulatory Data warehouse ETL Data Mining OLAP
CLC TP311.13
Type Master's thesis
Year 2011
Downloads 43
Quotes 1
Download Dissertation

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 .

Related Dissertations
More Dissertations