Dissertation > Excellent graduate degree dissertation topics show

OLAP Query Optimization Research and Implementation

Author: XiaoHengYong
Tutor: QiuHuiZhong
School: University of Electronic Science and Technology
Course: Computer Software and Theory
Keywords: Mondrian OLAP system Forecast management Cache management Cold start process
CLC: TP311.13
Type: Master's thesis
Year: 2012
Downloads: 76
Quote: 0
Read: Download Dissertation

Abstract


As time goes on, the data in the data warehouse, which contains a wealth of information, will expand rapidly. The data warehouse technology just solves the problem of the storage of the data and improves its efficiency. Only by combining with the data analysis techniques, can we abstain the decisional information from the large and complex data environment. But the data analysis dealing with mass data needs a large complex operation with those data, time-consuming are very serious. Specifically Mondrian OLAP system is based on ROLAP system, which results in many deficiencies in handing multi-dimensional data, so we have to decrease the system’s response time by optimizing it.This thesis focuses on studying in depth to how to improve the query performance of Mondrian OLAP system, and proposes to bring forecast management and data-caching technology into the Mondrian OLAP system, in additional, adds a cold start process to obtain aggregation data from the relational database to the cache. Those would reduce the response time.Firstly, this thesis analyses the existing problems of the Mondrian OLAP system, and puts forward the overall framework of cache management proposal, which is based on forecast management and cold start process Then,discusses its three key technologies in-depth: forecast management technology, management techniques based on the result set cache and cold start process. Forecast management system can abstain the user’s pattern of query multi-dimensional data behaviors by tracking their query logs, and base on these behaviors to predict the user’s query behavior in the future, making the cache system always save the best result set for the future query. In additional, considering the characteristics of Mondrian OLAP system, this thesis chooses the best cached object and the algorithm of cache management, and designs the L2 cache to store the user’s query result set. The cold-start process loads the data result set to the cache system when the OLAP system initials start-up or when restart, making the system user’s query could always have a faster response time. Experimental results show that, after improved the Mondrian OLAP system, the performance bottleneck due to the rapid growth of data warehouse to some extent is solved indeed, and the overall Mondrian OLAP system’s query performance is improved.

Related Dissertations

  1. Prediction of Gas Emission and Technology of Preventing Measures at -850m Elevation of Kailuan Qianjiaying Mine,TD712.52
  2. Research on Predicting Management Model of Geological Disasters of Debris Flow in Taihang Mountainous Areas, HeBei Province,P642.23
  3. The Construction of College Human Resource Management Information Decision Support System,G647.2
  4. Heating Load Forecasting Based on MIS,TM769
  5. Study of Housing Market Administration in Tianjin,F293.35
  6. Study of Optimizing Petrol and Diesel Oil Sale System in the Huabei Petrol and Diesel Oil Sale Company,F426.22
  7. Study on the City Car Rent Trade Developing Network Management,F572
  8. Exchange rate risk and management of multinational,F830.7
  9. On the multinational trading company in China Logistics Management,F276.7
  10. Research on Cache Replacement Algorithm in Data Broadcast Environment,TN929.5
  11. Distributed parallel system cache management mechanisms and user consistency,TP338.6
  12. Study and Application for the Cache Management of Client in Mobile Database,TP311.13
  13. Research and Implementation of Adaptive Dynamic Translation,TP391.2
  14. Cluster Streaming Caching Proxy Server Research of Cache Management System,TP393.05
  15. Research on Routing Protocol in Delay Tolerant Networks,TN92
  16. Research and Analysis of Code Cache Management Policy in Dynamic Binary Translator,TP314
  17. Target Emulation Integration and Cache Policy of Instruction Emulation,TP337
  18. System Optimization and Performance Testing of Color Ring Back Tone Service Management System,TP311.52
  19. Packet switching system shared cache management strategy research,TP333
  20. Research and Application of SSD,TP333.35
  21. A High Performance Network Content Reconstruction System,TP393.08

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