Medical Systems BI Data Analysis Platform Of Design And Implementation

Nowadays most of the medical institutions of various medical data accumulatedappear surge, the surge in data behind many of the useful information. However,hospital cumulative data processing has remained mostly on the level of operationaltransaction processing based on database technology, generally in accordance with therelational structure is stored in the effective storage, update, delete, reduce redundantdata, outstanding performance, specific application services, data entry, query, simplestatistics, such as a lower level of function can be efficiently implemented. Is very lowin the efficiency of complex queries, you can not find the relationship that exists inthe data and rules can not predict the future development trend based on available data,unable to tap the data behind valuable information and knowledge. It is based on theneeds, business intelligence applications came into being in the hospital.Medical systems BI data analysis platform for practical for some large andmedium-sized hospitals decision support system, it provides the analysis of thematicanalysis of the data, reports and charts and other functions. This article is based on B/S structure, using the Java applet technology, the use of self-development platform toachieve system function to the constructor of data marts and OLAP multidimensionaldata analysis. Iterative analysis of the demand for hospital use prototype method, thetotal demand, determine the theme. Needs analysis that the core function of the ETLprocess and multidimensional data analysis and reporting. Build a data warehouse anddata mart in the system design, dimensional modeling, star schema data martdesign-based snow model, supplemented by design patterns, the use of the Javalanguage code the ETL process, multidimensional data analysis, the core engine of theOLAP Mondrian framework, and use of the MDX language to display the cube in theJava applets on the report using the report editor of the independent developmentplatform to achieve the printing functions, charts, use of self-development platformtools drawn from the application, by the way medical system BI data analysisplatform, basically meet the needs of the hospital.The results of this study show that, based on Java Applet technologycombined with independent development platform of business intelligence research inspecific industry is feasible, which have practical significance, it can be used in large and medium sized medical institutions, and low cost, short development time, so ithas good popularization value and commercial value.