Dissertation > Excellent graduate degree dissertation topics show

Traffic Analysis Based on Data Warehouse and OLAP

Author: MaZuo
Tutor: HuangGuoXing
School: East China Normal University
Course: Software Engineering
Keywords: Data Warehouse(DW) On-Line Analytical Processing (OLAP) Traffic analysis Dimension
CLC: TP311.13
Type: Master's thesis
Year: 2008
Downloads: 54
Quote: 1
Read: Download Dissertation

Abstract


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.

Related Dissertations

  1. Study of Data Reduction Technique Based on Manifold Learning,TP311.13
  2. Research on Multi-dimensional Migrant Workers’ Employment Management System of Jiamusi,F249.2
  3. Dual dimension of scientific concept of development review,D61
  4. Analysis from the historical dimension of holistic education philosophy for sports development impact,G80-05
  5. The Experiment of Normal Bond Properties between FRP and Concrete,TU528.572
  6. Cultural differences in the cultural dimension Perspective,H0-05
  7. The Unity of Logic and History: An Important Dimension of Technology Foresight,G301
  8. Research on Locally Features Aggregating and Indexing Algorithm in Large-scale Image Retrieval,TP391.3
  9. Research Oncognitive Radio Cooperate Spectrum Sensing,TN925
  10. The Study on Endogenous Mechanism of the Rural Public Culture Services in China,D422.6
  11. Subject classification based on social tagging and sorting optimization methods,TP391.1
  12. Click -based network traffic research honeypot system,TP393.08
  13. Dongguan Mobile Group Customer Relationship Evaluation System and Application Study,F626
  14. Cantor centralized approach can be a good measure of the nature of point sets,O156.7
  15. Jiangsu Unicom MAN traffic monitoring and analysis system applied research,TN915.06
  16. High-speed detection and bayonet vehicle license identification information,TP391.41
  17. Based on synchrotron radiation CT imaging of breast cancer quantitative study of microvascular,R318
  18. The Study of Text Classification and Retrieval for Chinese Patent,TP391.1
  19. The Study of Artificial Target Detection Based on Fractal Feature,TP391.41
  20. Research on the Balance Model of Work-Family Conflict for Women Entrepreneurs: Based on Grounded Theory,F272
  21. The Influence of Social Capital on Personal Knowledge Being Organized,F272.92

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile