Design And Implementation Of Data Query System Of Guangyuan First People's Hospital

With the continuous expansion of the hospital,more and more hospitals need a more convenient and fast query mode to meet the needs of the daily work,so with the help of the data warehouse and on-line analytical technology can achieve the integration of a number of hospital business analysis and modeling,and will result in visual way of intuitive and easy to read.At the same time,along with the advance of the current information technology,the hospital a great deal of data has not been used to mining and analysis,make full use of such a large amount of historical data,makes the hospital can effective utilization of resources,optimizing allocation,the and can give full play to the functions of different positions,thus improve the hospital overall working efficiency and create more value.This paper is aiming at these problems,the first people's hospital in guangyuan city as the main research object,in the thorough analysis the theory of data warehouse and OLAP technology principle,on the basis of every department and the department of the hospital business has carried on the detailed investigation and research,and designed a set of efficient query system,help the hospital staff better management activities,improve work efficiency.The main contents are:1.This paper studies data warehouse technology and OLAP technology and constructs a multidimensional data model and data warehouse suitable for the first people's hospital of guangyuan city.This method builds a data warehouse on the existing large amount of historical data of the hospital,which enables the hospital to build a more intelligent query and analysis system on the basis of HIS system,so as to help hospital managers to query the required data quickly and make more accurate and reasonable decisions.2.Conducted research on the first people's hospital of guangyuan city,completed the demand analysis,and determined that its foreground functions mainly include the whole hospital inquiry statistics,outpatient inquiry statistics,inpatient inquiry statistics,drug comprehensive inquiry statistics,material inquiry statistics,equipment inquiry statistics,custom inquiry statistics;Background functions mainly include department basic information,outpatient information,hospitalization management information,drug information,material information,equipment information,file upload,etc.3.Completed the data warehouse design and modeling of the query system,and established business model,domain conceptual model,logical model and physical model successively.This design and modeling method oriented by requirements and results greatly improved the practicability of the system.4.Realized the front and back functions of the query system,and showed it in a more intuitive way,and finally through the system test,guaranteed the stability of the system.