Research And Implementation Of Data Warehouse Multi-granularity Model Of Transport Equipment Management

As the oil transportation enterprise information develops rapidly and the data which different department device management business produce increases, on the one hand, according to the enterprise requirement, a large amount of the independent data need to be managed and organized effectively. On the other hand, they need to help the business managers to make decisions and analysis. The technology concerning data warehouse model of multi-granularity is utilized, and the construction of oil transportation enterprise equipment management particle analysis system is proposed, which provides a environment for management decisions and statistical analysis. The main jobs and innovations will be demonstrated just as follows:LA adaptable model of multi-granularity analysis concerning oil transportation enterprise information is proposed. Through analyzing the characteristics of the device management of oil transportation enterprise and taking concept and knowledge of data warehouse granularity into account, the subject field and theme of warehouse is determined, at the same time, the model of multi-structure granularity is constructed.2.The warehouse ETL concerning oil transportation enterprise device management is proposed. A large amount of history and business data which is in the device management is organized and integrated effectively. Based on SSIS components of SQL Server 2005, the re-organization and algorithms, such as the data extraction, transformation, load, which is concerning the theme of warehouse, is proposed. These help decision-makers to solve the problem which come from different data source.3.The structure model of device management data warehouse granularity is analyzed and designed. The structure concerning the model of transportation enterprise device management multi-granularity is analyzed and designed in detail. The algorithm about designing granularity model which is the integrated data bout different subjects and different levels, so that decision-makers find the internal pattern to provide support for decision-making environment, from various angles and multi-level observational data.4.The method about the implement of granularity analysis system is researched and demonstrated. Through combining SQL Server 2005 data base with C# language, which is based on.NET environment, the system concerning vehicle equipment management data warehouse of multi-granularity is designed, at the meanwhile, the result is displayed graphically in the form of visual analysis.