Dissertation > Excellent graduate degree dissertation topics show

Modeling Database System Performance with Locking Description

Author: PangLiYing
Tutor: NiuBaoNing
School: Taiyuan University of Technology
Course: Computer technology
Keywords: Database System Performance Model Data Lock LayeredQueuing Network Model MOL
CLC: TP311.13
Type: Master's thesis
Year: 2013
Downloads: 1
Quote: 0
Read: Download Dissertation

Abstract


With the development of information technology, optimizing application performance has become paramount important for enterprises. The optimization of database systems involves dynamic adjusting and tuning parameters and control workloads, which has a significant impact on the performance of application sand occupies the core position in the optimization of application performance. Optimizing the performance of database systems usually needs a model to guide the optimization. Therefore, establishing a precise performance model of database systems has become the key task for optimizing the performance of database systems.Locking as a part of internal of database systems, its impact on the performance of database systems cannot be ignored. At present, the main technology on locking is queuing networks model, but it only describes computer hardware resources, and cannot describe the hierarchical structures and software resources existing modern computer systems, it has influence on the analysis and description the flow of the lock.This thesis uses the layered queuing network model for lock modeling. Layered queuing network model, an extension of queuing network model, is designed to be able to model the software resources, in addition to hardware resources. Layered queuing network model can better describe and analyze the dependence of calls and hierarchical relationships among resources and tasks, making up the deficiency for queuing network model. At the same time, if the row locks are too many the database systems will run out of memory, which will result in the row locks automatically upgraded to table locks, for this account this thesis only models table locks. The main work as follows:1. By analyzing the locking mechanism, a layered queuing network model with locking description is proposed for database systems. The experiment employs TPC-H Benchmark as the data and workloads, and DB2as the target database system.2. The model is solved and analyzed using the method of layered. The model parameters obtained by using the direct and indirect methods. Due to load the concurrent access will cause the lock waiting, however, the competition for resources also cause the lock waiting in actual execution time. Therefore, the experiments use the1-0.5of the proportion of lock waiting time in total time to solving the lock waiting time.3. The model is solved and analyzed using the three sets of load. By comparing with the queuing network model the proposed layered queuing network model is more accurate.

Related Dissertations

  1. The Studying of University Students’ Community Management Based on GIS,G647
  2. Chain Enterprise Information Management System Design and Implementation of encryption technology,TP393.08
  3. Research and implementation of general test database systems,TP311.52
  4. Botnet Detection and Prevention System-Database and System Integration Solution,TP393.08
  5. Sichuan College of Architecture Design and Implementation of Online Examination System,TP311.52
  6. Design and development of apparel inventory management system,TP311.52
  7. University dormitory management information system design and implementation,TP311.52
  8. Knowledge-based theory of the Equipment Management System Design and Implementation,TP311.52
  9. The Research on the Relationship of Pay for Performance Model and Work Performance,F272.92
  10. Vocational and Technical College Mobile Design and Implementation of the management system of party members,TP311.52
  11. Numerical and Experimental Study on Performance of Truss Spar in the Process of Wet Tow and Upending,U661.7
  12. The Design and Implementation of Question Bank Management System of the Branch of Hengshui University,TP311.52
  13. Study on the Weldability and Its Database System of Ni-based Alloy with Plasma Arc Welding,TG456.2
  14. Research and Implementation of MPI Parallel Fault Tolerant Technology,TP302.8
  15. The Analysis and Design of Huifeng Logistics Fund Settlement Unifiedly Management Information System,TP311.52
  16. Research on Wide Area Traveling Wave Location System,TM76
  17. Research on Welding Integrated Technology of Batch and Diversity of Diesel Engine Frame,TK426
  18. Research on Mechanical Behavior of Combined Sections Used in Steel-Reinfouced Concrete Pillar Base,U441
  19. Research on Micro Machining Technology of Ultraviolet Laser,TG665
  20. TCM fingerprint database system design and implementation,R284
  21. Hospital Leadership and hospital management performance correlation studies,R197.3

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