Design And Implement Of Business Intelligence System In QHSE

In the view of the specific project of PetroChina,the design and implement progress of BI in the QHSE environment is discussed in detail. And so does the QHSE project.1. The information system condition and the practical requirement of PetroChina is analyzed. And the concept and character of Data Warehouse(DW) are introduced. According to the experience of the construction of DW,the establishment progress of DW is concluded.2. Briefly,the research areas and methods of Data Mining are introduced. There are enormous data accumulated accompanying with the application of QHSE. Interested patterns are more imperative in the field of database. A feasible design of Data Mining in the QHSE is introduced.3. The concepts and peculiarity of the OLAP are discussed in the field. Combined with the realization method of the OLAP,the framework of DW and OLAP is concluded. And the multi-dimension model is discussed specifically.4. The paper introduces a new BI applied-architecture which integrates multidimensional data-analysis services and report-sharing services. Based on the feature sets and logical structures of the architecture's components such as multidimensional-analysis platform,analysis-report server and so on.5. Taking QHSE report system as an example, the paper discusses the business analysis and the building process of the business intelligence in details,and gives the design and implement method of the project:first,determine the topic field according to the requirement analysis,and get the meaning of data sources of the system,then completed logical and physical module design for two typical business subject, the OLAP results also showed in the chapter.