Dissertation > Excellent graduate degree dissertation topics show

Research of Main Memory Database Parallel Query Processing on SMP

Author: LiuWei
Tutor: HuangBenXiong
School: Huazhong University of Science and Technology
Course: Communication and Information System
Keywords: Memory Database Inquiry T -tree index parallelization Spinlock
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 17
Quote: 0
Read: Download Dissertation

Abstract


Memory database with a lot of traditional database systems do not have the advantage of the memory database, and uses traditional disk library, the architecture design for memory storage structure, to achieve much higher (10 times more) than the disk database data handling capacity. Despite a high performance in-memory database, but the face of the increasing amount of data processing performance is also stretched. In recent years with the advent of the symmetric multi-processor-memory databases continue to improve the performance of the program is to achieve query parallelism in multi-processor platform. Parallelization common platform shared-memory and shared disk; memory database systems based on shared memory platform suitable for OpenMP parallel programming optimization. The memory database query parallelization faces several challenges: parallel process optimization, concurrency control problem, parallel determine the extent of the problem, the problem of concurrent execution of strategy. Way for a variety of query parallelization, including inter-query parallelism, parallel query operation, and operating in parallel query parallel can not improve response performance for complex queries while operating between parallel operand less coupling relationship, and the operating room larger unable to obtain a better performance boost, operating within parallel optimization will become the primary means of optimized parallel memory database query within the transaction. A query process, including the index, the middle of the operation, the result set processing, query parallel optimization processes T-tree indexes for the query process, the middle of the operation, the result set processing design specific parallel processing strategy. OpenMP lock efficiency is not high enough for the concurrency control problem, by using an improved spin lock to extend the scope of application of the spin lock can replace the OpenMP lock and spinlock error rate theoretical analysis to verify its feasibility; determine the degree of concurrency problems, OpenMP uses a number of core system as the degree of parallelism on a dual-core machine, this approach may well be a simple and practical way to simplify parallel design; strategy for concurrent execution current for concurrent execution of operations research, including data partitioning techniques, parallel sorting, parallel connection, parallel aggregation function computing research and learning through the existing research, it can be implemented in-memory database query parallelism Optimization. Through simulation and test the effectiveness of the parallel optimization improvements found improvements spinlock larger performance gains than OpenMP lock parallel sort of operating performance, as well as the result set of parallel processing are greatly improved performance .

Related Dissertations

  1. The Application of Mind Map in Science Teaching,G633.98
  2. The Applied Research on Inquiry Teaching in Wushu Courses of Physical Education,G852-4
  3. Webquest -based inquiry teaching high school physics Case Study,G633.7
  4. Junior Middle School Physics Research-style Teaching Implementation Status and Propulsion Strategy Research,G633.7
  5. Inquiry Teaching of Mathematics in High School and Case Analysis,G633.6
  6. The Research of Memory Database Query Optional in Multi-core System,TP311.13
  7. Research on distributed-memory database storage,TP311.13
  8. Analysis of the Legislative Boundaris of Local Laws and Regulation from the Perspective of Legal Inquiry Reply,D920.0
  9. Junior high ideological and moral lesson inquiry Classroom Research,G633.2
  10. Based on GIS/GPS Police DispatchSystem Design and Implementation,TN967.1
  11. Comparative Study of the Teaching Behavior of Physics Inquiry Classes in Urban and Rural Middle School of HuNan,G633.7
  12. Narrative Inquiry into the Formation of New Teachers’ Professional Ethics,G451.1
  13. The Design and Implementation of EPG Backend in Campus IPTV System,TN949.292
  14. The Research on Problem Inquiry Teaching about Senior School Mathematics Based Information Technology,G633.6
  15. Network-based middle school physical inquiry teaching mode in China,G633.7
  16. Understanding Self-selective Topic Learning of English Majors in RICH Education,H319
  17. Research and Practice on Inquiry Teaching of Mathematics in High School,G633.6
  18. Inquiry-based Instruction Design on Biology in Secondary School,G633.91
  19. The Preliminary Study on Secondary School Students’ Argumentation Ability in Science Inquiry,G633.98
  20. A Study on Secondary School Students’ Preconception and Conceptual Change of Image Formation,G633.7

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