Dissertation > Excellent graduate degree dissertation topics show

The Applications Research on Multidimensional Analysis Spread Technology of Data Warehouse

Author: YuXiuMei
Tutor: LiYeBai
School: North China University of
Course: Applied Computer Technology
Keywords: Data warehouse OLAP Middleware Materialized view
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 77
Quote: 0
Read: Download Dissertation

Abstract


The multi-dimensional analysis show system which is in the background of the electronic commerce system based on Web become important constitute of the electronic commerce system. It become an important problem needed to be solved that how to design the multi-dimensional analysis display system to satisfy enterprise’s practical requirements. Through the study the basic theory of data warehouse, online analytical processing (OLAP), XML technology and multidimensional expressions (MDX) syntax, this paper presents a solution for multi-dimensional analysis show system.As the speed of cube query processing in multi-dimensional analysis has direct impact on the efficiency of query of the system, in order to improve the performance, this project employs the method of materialized view and uses Mondrian as the multi-dimensional analysis server, which is an open source software. In query analysis process, Mondrian can match the materialized view and query, making the materialized view can also store the practical data. It also pre-calculates and saves results of time-consuming connection and aggregation, operating results. The data warehouse system of multi-dimensional analysis show is implemented based on the previous solution, which can achieve online analytical processing to conduct, rotation, drill down, slice, dice and other operations based on Web. The system improved the efficiency of query and integrated with office automation software seamlessly.Based on date warehouse, on-line analytical processing technology and specific business requirements, the development environment of enterprise systems is analyzed to design the data warehouse, cube are created for multi-dimensional analysis. This thesis mainly studied the query optimization of cube. In addition, through the 2D and 3D graphic presentation of the multi-dimensional analysis operation results, the system provides the support for enterprise decision makers.

Related Dissertations

  1. Data warehouse technology in the banking customer management systems research and implementation,TP315
  2. The Application of Association Rules Algorithm in Higher Vocational Colleges’ Endorsement of Impoverished Students,G717
  3. Research and Application of Home-School Education Platform Interactive Based on Warehouse,TP311.13
  4. Design and Implementation for Decision Support System of Drug Administration Based on Data Warehouse,TP311.13
  5. Based on RFID Prison Intelligent Management System Research and Implementation,TP315
  6. The Analysis and Application of Telecom Customer Retention System Based on Data Mining Technology,TP311.13
  7. PG steelworks MES system design and development of data mining,TP311.13
  8. Liupanshui City tobacco company's human resource management system integrated design and implementation,TP311.52
  9. Domain Ontology-based Marine Environmental Data Warehouse Design,TP311.13
  10. Design and Implementation of Distributed Video Storage System,TP333
  11. The Reader Equipment of RFID Middleware Mangement Research,TP391.44
  12. Research on Monitoring and Early-Warning of TBT Risk in Textile and Garment,TP311.13
  13. Research and Implementation of medical resources management decision support system,TP311.52
  14. Research and Implementation of RFID Middleware Based on SOA,TP391.44
  15. Design and Implementation of an Embedded RFID Middleware,TP391.44
  16. The Exploitation and Application of Customer-Action Analysis System on Date Mining,TP311.13
  17. Student Management Based on Data Warehouse Decision Support System Design and Implementation,TP311.52
  18. Adaptive middleware -based stock trading platform design and implementation,TP311.52
  19. Research on Middleware of Heterogeneous Data Integration Based on XML Schema,TP311.52
  20. The Research and Application of Data Middleware Based on OSGi in Digital Campus,TP393.18
  21. The Design and Implementation of RFID Middleware Base on OSGi Framework,TP311.52

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