| Chinese medicine's complete theoretical system and rich experience in clinical practice have made outstanding contributions to health care for the Chinese nation.Science of prescriptions occupies an important position in Chinese medicine.Prescription is crystallization of the experience that famous old TCM doctors combine Chinese medicine's basic theory,previous experience with practice to resolve the clinical problems.Prescription is an important component of Chinese medicine's theory,methods,prescription and herbs,its pair of herb and prescription compounding have a profound scientific connote.For thousands of years,the numerous theory researches and clinical practices of Chinese medicine has accumulated massive prescription.How to effectively use these valuable resources on the prescription has become a problem that develops Chinese medicine has to face.With the rapid development of information technology,database,data warehouse and data mining technologies are widely used in banking,retail, telecommunications,medicine and other industries,research and analysis of their massive data have been made fruitful.Using these technologies to do scientific research and analysis on massive prescription may be able to help us to find interesting knowledge.Overview of related literature,at present,the use of programming software to research prescription is basically a single database,data warehouse or management application system.And there is no other developing research on a disease based on a prescription dictionary.The research's main purpose is to make data warehouse modeling of prescription as the core.And to build an integrated application system that combines prescription database,data warehouse with management application system and that it reflects the management concept and the characteristics of Chinese medicine.It can help medical workers to learn and improve the efficiency of research and statistical analysis of prescription services.The research uses software such as Excel,PowerBuilder8.0,SQL Server 2000, Analysis Services 2005 and so on.It is in accordance with the Software Engineering modeling and to model database,data warehouse and management application system for the prescription.This research attempts to have done these work:(1)It bases on prescription of treatment of epigastric pain from the dictionary called "Dictionary of Chinese Medicine Prescription".To convert 502 prescription of about 80 thousand words to a two-dimensional table.(2)Using Excel's simple and rapid data processing function instead of complex procedures to pre-process prescription data.(3)It's core is data warehouse modeling of prescription. It is an integrated application system that combines prescription database, prescription data warehouse with prescription management application system and that it reflects the management concept and the characteristics of Chinese medicine,and integrates comfortable and rapid data transplanting function.(4)Prescription database,prescription data warehouse and prescription management application system complement each other. Prescription management application system can supply new data for prescription database,prescription database can supply new historical data for prescription data warehouse,and prescription management application system can make statistical and mining analysis of data from the prescription data warehouse and it can supply daily management operation for prescription.The research also did not extend the temporary development of disease data warehouse and data mining features,but it will be better in subsequent studies. Although this is only applies to the point of epigastric pain,with the rapid development of information technology and research continue to explore,some years later it can be extended to other types of disease and more advanced. The research can provide informationization research and management of the prescription and even the Chinese medicine with a degree of reference. |
PDF Full Text Request