Traffic Analysis Based On Data Warehouse And OLAP

In a global environment of fierce competition, along with the popularity of enterprise information, the data of load information keep accumulating and increasing with the passage of time, making it difficult to find real useful information for decision-making from large amounts of data. Therefore, how to statistical and analytical the massive data at various levels in the round, become more and more important for an enterprises.The paper, based on the actual needs of the enterprises current, and in-depth research data warehouse and OLAP technology, combination Business Intelligence Development Studio tools of SQL SERVER, make use of the original traffic data that existing network switch of center, research enterprises traffic data analysis techniques and implementation methods. My work includes:1. Investigating the characteristics of original traffic data of exchanger, the requirements of analysis and query.2. Having accomplished ETL. Extracting data from heterogeneous data sources, and loading it into data warehouse after transform.3. Creating a multidimensional cube model for traffic data warehouse. The traffic data is brought forth by way of the many-dimensions, and the dimension degree of data is defined.4. Having accomplished traffic On-Line analytical processing. Creating a multidimensional data model based on integrated data of DW. Providing decision support through compares and analyses multidimensional data from all sides using the way of multidimensional analysis.5. Having accomplished the intelligent report using SSAS tool. The users can analyze data neatly by way of the unified WEB Browser interface, need not consider the operation system.Through this research, this paper to provide a powerful traffic analysis system for enterprise. The technology of OLAP and DW is used for data analysis. Not only extract large number of potential information, but also can improve the scientific of the decision-making enterprises.