Establishment Of A Stomatology Hospital Decision Support System Based On Data Warehouse

The Data Warehouse is a subject-oriented, integrated, relatively stable, time-varyingdata sets; Decision support system is a tool what based on management science,operations research, cybernetics and behavioral science, using of computer technology, theexisting data, information and model implementation decision support process. To build adata warehouse based on the stomatology hospital decision support system is in full use ofthe data warehouse core technology, what based on the established various managementsystems integrated hospital information collection, integration, statistics, analysis, decisionsupport system. Data warehouse technology is essentially an information integrationtechnology. Its emerged from that corporation gradually increased demand for decisionsupport functions, its goal is to complete data integration, become the basis of front-endquery analysis for the enterprise management decision support.In the different sizes, different disciplines Role of various types of stomatologyhospitals are distinctive, so the stomatology hospital decision support system requirements are not the same. In the type of architecture and decision programs, both general hospitalsin common, but also meet the needs of stomatology specialty of personality, It also makesstomatology hospital data warehouse decision support system in the establishment has acertain degree of particularity and originality.At present, some hospitals, especially among the tertiary level of some large generalhospital construction or have already begun construction of its own hospital completed aset of decision support systems. Through literature queries and research we found thatvarious types of hospital-based business process information management system hasbeen widely established, but these decision support systems is not necessarily based ondata warehouse, domestic hospitals more is first established operational data store or datamarts, so that in the short term in order to provide a fraction of the cost directlydepartment or some intuitive statistical needs. If in the future and then think of otherprojects or needs, and then build a new data marts. This can constitute a data mart starstructure, eventually forming a data warehouse. But the result is that hospitals are unableto carry out integrated management of nosocomial lack of information among the variousfunctional departments sharing, collaboration, leading to operate independently of eachsystem, the formation of islands of information.In the foreign medical and health fields, based on data warehouse decision supportsystems research and applications have been developed to a very high level. The abroadhospital has different business model and medical security system. Decision supportsystems are facing the object is also more abundant. In Canada, the Netherlands, Japan,the United States and other countries, the data warehouse technology has been widelyapplied to medical technology, clinical trials, experimental pharmacology, biomedicalengineering and other aspects of translational medicine, and made great achievements inthe platform inter-connection, information exchange has also made great progress. Inrecent years, the development of more focused on the entire clinical, laboratory, research,business process into a complete medical system, the complete system is built by amedical data warehouse, decision-making support, can play a more powerful role.Based on the above conditions and our practical work experience, the development of decision support systems have been severely affected by the hospital’s laggingdevelopment of information technology and management decision-making efficiency,thereby affecting hospital productivity. So we designed a stomatology hospital based datawarehouse decision support system for the various departments of the hospitalmanagement and provide a variety of information to support decision-making.Stomatology hospital decision support system framework used is based on DW (DataWarehouse)+OLAP (On-Line Analytical Processing)+DM (Data Mining). Which, DWis to achieve data management, organization and storage, OLAP data is mainly focusedon analyzing, DM mainly automatic knowledge discovery. Architecture is divided intofour lowest level of direct access to the data layer, the data source contains a patientinformation, drug information, patient information. These direct access to the datathrough the clean-up, extraction, conversion, etc. After processing, data storage layer intothe second layer. Data storage layer is mainly about data processing, the decision toprovide comprehensive data and decision-making theme based on the actual needs, andthen reorganized to provide a lot of data to support decision-making support. The thirdlayer is the data processing layer, data processing layer mainly through DM and OLAP,which the DW obtain the desired knowledge and information. Last layer is the data accesslayer, data access layer is to provide access to decision-makers interact with the system.Through man-machine interface, the data processing layer in which knowledge andinformation obtained to show the user’s eyes, which contains formatting query, the userinteraction and generate charts and reports and so on. This architecture can streamlinebusiness database load, reducing operational system maintenance and upgrade costs andworkload, improve efficiency in the use of business systems.Through the development and construction of the system in improving the quality ofmedical management, but also the history of the hospital data were structured,complementary and finishing. Analysis of management decision-making at all levels ofthe hospital particularity, and accordingly proposed for the stomatology hospital decisionsupport systems overall model and system framework. According to various department ofthe national standards and their own recommendations, including hospital admissions integration, operation, cost, disease, antimicrobial drug use and other aspects, and itsanalysis were assessed. Various departments and sectors as a hospital everyday utilitysoftware to promote and well received, the implementation of their management decisionshave a greater impact and improve the quality of care in the hospital, the workingefficiency and management level.Throughout the entire course of the study, also had a lot of difficulties and problems.For example, the basic information is not completely; the lack of information on the wholeprocess of management and control; the main index and data standardization for decisionsupport system plays an important role in the foundation conditions are not complete;intelligent, humane, information integration show insufficiency, presented by the user’sidentity could not be more concerned about their personalized information interface. In thefuture, taking into account the construction of decision support systems characteristicspiral gradually building, Taking into account the Stomatology Hospital and the medicalindustry information system status, the complete decision support system, we will learnfrom different departments managers suggested that in future work to optimize the systemcomponents, highlighting the protection of privacy of patients and physicians for thefuture regional development of decision support platform as a foundation. Re-design theuser interface make it more concise, and gives more user-defined functions, and improvethe stomatology knowledge management system security features of decision support.