OLAP Clinical Analysis Of Occupation Diseases In The Applied Research

With the extensive application of information management systems and the surge in the amount of data, it is hoped to provide a higher level of data analysis for this data warehouse came into being. Therefore, the data warehouse concept has been proposed on the subject from.the industry's concern, its rapid development momentum and strong market potential for the world's major research institutions, concerned about the computer. Data Warehouse and its associated data analysis techniques through the re-organization and intelligence analysis, rapid and efficient mass data extracted from the valuable information for management decision-making use. Although the data warehouse technology has become more sophisticated, but the data warehouse technology into the data warehouse technology into occupational health in the work of the still relatively small, so the passage of this issue can help the medical staff can be found in hundreds of medical data of disease common features, thus speeding up the pace of exploration of the work of occupational health care.The subject is on the Microsoft SQL 2000 Data Warehousing Framework familiar with the master on the basis of the occupational therapy as an object of study, put forward a data warehouse used in the work of occupational health care solutions First, occupational health issues for the characteristics of work carried out a feasibility analysis and needs analysis, put forward the theory of occupational analysis of the data warehouse based on the building of ideas and the establishment of steps; then use the SQL Server 2000 carried out the data extraction, transformation, the establishment of a data warehouse models and multi-dimensional data sets; Finally, the occupational data warehouses on-line analytical-processing, and carried out the work of the client display.