Dissertation > Excellent graduate degree dissertation topics show

Query Execution Plan Cache Based on DM Embedded Database

Author: WangZhuFeng
Tutor: WuHengShan
School: Huazhong University of Science and Technology
Course: Computer Software and Theory
Keywords: Embedded database Query Optimization Execution plan Cache
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 9
Quote: 1
Read: Download Dissertation

Abstract


With the development of embedded technology , users are increasingly looking for more effective management of embedded products . The embedded database is an effective tool for data management , but due to the limited resources of the embedded database system , the efficiency of the system is that people are very concerned about the problem . In-depth study in order to improve the operating efficiency of the embedded database , the embedded database DaMeng virtual machine and query optimization mechanisms , a new query optimization function expansion on the basis of up to Dream existing embedded database query optimizer - execution plan reuse mechanism . The mechanism includes the same SQL statement reuse and similar SQL statement reuse method for the determination and implementation plan to reuse the hash key generation algorithm ; cache district-level and file-level execution plan . Execution plan reuse judgment , if it is exactly the same SQL statement , you only need to do simple ASCII compare ; reuse of SQL statements , you need by segmentation algorithm processing is a different case , invalid characters , constant value . If you find reusable buffer plan is to do the appropriate processing performed directly after . Limited capacity for query reuse plan cache execution plan reuse rate is not high , designed and implemented a document management mechanisms in the execution plan , it is the execution plan is stored in the memory buffer to the file , or file execution The program loaded into memory buffer , this can increase the rate of execution plan reuse . Execution plan file loaded when stored opportunity open database and close the database , it will not be an additional burden to the system . Experimental verification for the same SQL statement and a situation similar to the SQL statement , the experimental results show that the execution plan reuse mechanism the efficiency of the implementation of the system can be significantly improved .

Related Dissertations

  1. Design and Development of Application Programme for Fault Analyzer Based on Wince Platform,TP311.52
  2. Query Processing and Optimization in Massive Multi-Database Integration,TP311.13
  3. Adaptive multi-application environment prefetching Strategy,TP333
  4. Design and Implementation of the Instruction Fetch Unit and Multiple Instruction Flows Extension in the YHFT-Matrix DSP,TP368.1
  5. Study and Implementation of Performance Optimization SAN Cluster File System,TP316.7
  6. CUSUM algorithm based on improved DNS cache attack detection,TP393.08
  7. Research on Some Key Techniques of Context-aware Based on RFID,TP391.1
  8. Research of DB2 Database Query Optimization for Management Information Systems,TP311.13
  9. Development of the Real-Time Netwok Interface Card Baseed on Reflective Memory Technology,TP334.7
  10. Implementation of Parser of Embedded Browser Based on Cache Strategy,TP393.092
  11. Optimization Design of Internet Based on P2P Cache Techology,TP393.02
  12. The Design and Implementation of High-performance Distributed Data Cache System,TP393.09
  13. Design and Implementation of the logistics management information system based on B / S mode,TP311.52
  14. Research on Query Optimization of Data Warehouse Based on Improved Ant Colony Algorithm,TP311.13
  15. The Pause Research During Writing in Pupils,G444
  16. Distributed File System Metadata Management Research and Implementation,TP338.8
  17. Chip multi-threaded processor thread scheduling performance testing and optimization studies,TP332
  18. Embedded forest area flame monitoring system based on DM642,TP277
  19. Many of the Massive Data Format Unification Access Efficiency Optimizes,TP311.13
  20. Research on Abstraction for Model Checking Cache Coherence Protocol,TP332

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