Dissertation > Excellent graduate degree dissertation topics show

Research and Design of Transaction Concurrency Control in Main Memory Database(mmdb)

Author: DongXiaoHui
Tutor: HuangBenXiong
School: Huazhong University of Science and Technology
Course: Communication and Information System
Keywords: Memory Database Transaction Manager CacheDB Intent lock Dynamic multi- granularity locking
CLC: TP311.13
Type: Master's thesis
Year: 2009
Downloads: 109
Quote: 1
Read: Download Dissertation

Abstract


With the growing popularity of electric power industry, the degree of information, power system rising demand for real-time processing of field data, and gave birth to the birth of the support for real-time, high-performance database. Increased memory capacity and lower cost, memory-based, high-performance real-time database become mainstream technology trends. Memory database data stored in the memory, the read and write data in memory, and no great due to disk I / O overhead. Therefore, in the process of massive data, transaction concurrency control quality directly determines the level of data processing performance. The goal of this paper is to study memory database transaction concurrency control techniques to design a suitable memory database transaction management solutions to meet the massive data processing power industry needs. Power industry field collecting data arrival time is extremely uneven, with a strong burst, which brought unprecedented challenges to the transaction concurrency control. By analyzing the existing transaction concurrency control techniques, including two-phase locking protocol tree multi-granularity locking intent lock, dynamic multi-granularity locking and deadlock detection problem to be solved in this paper: multi-core environment high burst sexual concurrency control transaction flow problem. Multicore environment affairs sudden flow of in-depth analysis of the concurrency control problem based on the existing self-developed memory database - CacheDB architecture, design a suitable power industry application transaction management function modules, including transaction management, transaction scheduling and lock manager. The program combines the advantages of the of intent lock and dynamic multi-granularity locking, transaction conflict for a long time, concurrent ability row-level locking; Affairs conflict is low overhead lock table-level locking, greatly increase the overall system properties. In addition, the improvement of traditional dynamic multi-granularity locking mechanism key consideration lock compatibility and cost optimized affairs conflicts judgment mechanism; optimize the existing deadlock detection mechanism for dynamic multi-granularity locking as much as possible to reduce unnecessary deadlock detection operation. In order to verify the feasibility of the CacheDB transaction management solutions, latch and dynamic multi-granularity lock simulation test. The test results show that the intent locks and dynamic multi-granularity phase-locked combination transaction concurrency control design, the data reaches the uneven conditions significantly improve overall system transaction processing performance.

Related Dissertations

  1. The Design and Implementation of a Web Based Affairs Management System,TP311.52
  2. Design and Implementation of TestEvaluate Module in ISEE Based on MMDB,TP311.52
  3. The Design and Implementation of Chief Editor’s Office Management System for Binhai Development Area,TP311.52
  4. Research and Implementation on Critical Technology for Embedded Real-time Database,TP311.13
  5. Research and Improvement of the Index Mechanism of the Main Memory Database,TP311.13
  6. The Research of RFID Middleware Based on Smartphone,TP391.44
  7. Design and Realize of Real-time Main Memory Database,TP311.13
  8. The memory database cluster monitoring system design and applied research,TP311.13
  9. Design and Implementation of Location Based Access Platform,TN915.6
  10. Design and Implementation of Spatial Index for Main-memory Database,TP311.13
  11. Memory Database Backup and Recovery Research and Design,TP311.13
  12. Research on Buffer Management for Flash-based DBMS,TP311.13
  13. Research on Storage and Quick Retrival of Real-Time Data,TP311.13
  14. The Research of Memory Database Query Optional in Multi-core System,TP311.13
  15. Research on Web Service-Based Workflow of Dynamic Virtual Enterprise,TP311.52
  16. An in-memory database model design and implementation,TP311.13
  17. The Researching of Transaction Scheduling and Data Recovery in Real-time Main Memory Database System,TP311.13
  18. Design and Implementation of Main Memory Database,TP311.13
  19. Memory database accounting background,TP311.13
  20. WCDMA core network HLR software module design,TN929.533

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