Dissertation > Excellent graduate degree dissertation topics show

Research on Query Optimization in Dameng OLAP

Author: YinShuBin
Tutor: FengYuCai
School: Huazhong University of Science and Technology
Course: Computer Software and Theory
Keywords: dameng OLAP forecast management data cache cold start
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 10
Quote: 0
Read: Download Dissertation

Abstract


Currently,Storing the large amount of historical data in the data warehouse for decision analysis,and data warehouse must support a variety of OLAP queries.But,the rapid expansion in the number of information,and these OLAP queries usually involve vast amounts of data,but also those data for a large number of complex operations,this is a very time-consuming process.Especially Dameng OLAP system is a Rolap system based on relational database,there are many deficiencies in its performance in dealing with multidimensional data,such as to conduct a large number of table join and aggretion opertions,so it is a serious problem to improve the query speed of Dameng OLAP system.In order to improve the system’s performance,data cache technique and forecase management technology are applied to the Dameng OLAP system.and a cold start process brings aggregations from the relational database to cache,subsequently reducing the response time.Firstly, the problems of the current Dameng OLAP system are analyed,and the framework of the Dameng OLAP system based on management forecast,a cold start process and data cache technique is given out,then every part of this framework is described in detail.Secondly,three key techniques in the framework is studied:prediction management technology based on multi-dimensional data cold start process and cache management technology based on the result set.The system can capture knowledge about the query behavior of Dameng OLAP users by predict management system and learn the pattern of behavior that OLAP user executes MDX query,with the pattern of behavior ,it can predict which query results set is likely to use next and thus keep the most useful of them in the cache.In the system initialization and restarts,a cold start process is applied to load data into the cache system so that Dameng OLAP users can get alaways rapid response.at the same time the system design level cache management mechanism to cache OLAP user’s query result set,select a reasonable cache object according to characteristics of Dameng OLAP system ,then give out a cache data management algorithms,and discusses the problem of cache consistency.Experiment shows that data cache technique and forecase management technology which are applied to the Dameng OLAP system can effectively solve the problem of performance bottlenect as the rapid growth of data warehouse,and the introduction of a cold start process when the system initialization process improves overall performance of the Dameng OLAP system.

Related Dissertations

  1. Collaborative filtering recommendation system Research and Implementation of Key Issues,TP311.52
  2. OLAP Query Optimization Research and Implementation,TP311.13
  3. Way-Access Track and Way-Doze Based Low Power Cache,TP333
  4. Based on the random walk model personalized information recommendation,TP391.3
  5. Experimental Study on Combustion & Emissions of SI Engine Powered by Different Methanol-Gasoline Fuels,TK411.5
  6. Development of the Real-Time Netwok Interface Card Baseed on Reflective Memory Technology,TP334.7
  7. Research on Data Buffering and Scheduling Technology Used in Spatial Database System,TP311.13
  8. The Research of Data Cache Consistency and Decision Consensus in Decision Support Systems of Mobile Ad Hoc Networks,TN929.5
  9. The Design and Implementation of Network Performance Optimization at High-Performance Video Retrieval Platform,TP393.09
  10. The Design and Implementation of High-performance Distributed Data Cache System,TP393.09
  11. Design and Application of Rich Clients Based on EXTJS,TP311.52
  12. The Research of Calf-Chymosin Gene Soluble Experssion in E.coli,Q78
  13. Research on Caching Technology of Mobile Database Based on Data Broadcast,TP311.13
  14. Research and Application of OLAM Based on Work Warehouse in Decision Support System,TP311.52
  15. The Optimization and Test of Distributed Cache System MCACHE,TP311.13
  16. The Design and Implementation of Data Cache Subsystem for the Next Generation Network Security Situation Assessment System,TN915.08
  17. Research of Engine Start Simulation for Hardware in the Loop Test of ECU,TK407
  18. Automated Test Framework and Essential Technology Research for Distributed Data Cache System,TP333
  19. Hardware Design and Implementation of Software Radio CPCI signal processing board,TN925
  20. The Research and Implementation of Product Inspection Information System Based on Mobile Smart Client,TP311.52
  21. Study on Live Migration Protocol for Virtual Cluster over WAN,TP393.2

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