Dissertation > Excellent graduate degree dissertation topics show

Adaptive Management of Transaction Workload for Database Systems

Author: ShiJian
Tutor: NiuBaoNing
School: Taiyuan University of Technology
Course: Applied Computer Technology
Keywords: Load adaptive AWMF Terminal load Batch load Transaction class load
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 19
Quote: 1
Read: Download Dissertation

Abstract


Load adaptive database system refers to the database management system through the filter and control the load the effective use of system resources to meet the load performance requirements of the process. Autonomous database load management framework (AWMF: Autonomic Workload Management Framework) is the overall framework of a load-adaptive load adaptive basic components and the main process. The AWMF of the effectiveness of the terminal load (Terminal Workload) and batch load (Batch Workload) has been verified. This paper studies the validity the AWMF of the the transaction class load (Transaction Workload), proposed as performance prediction components based on query cost (Cost) trading load queuing network model based on the model, the prototype of the AWFM - query scheduling through simulation comparison experiments verify effectiveness of AWFM transaction class load. The subject combination of queuing theory and AWMF, the queuing model based on transaction class load. Query scheduler for load control. Load control process is divided into a series of time intervals, and periodically resources dynamically optimized configuration. In each interval by the query scheduler according to the performance of a previous interval, automatic control, resource allocation. The premise of the computational performance is to understand the characteristics and laws of the load. The transaction class load reaches the number of the load of the system is always changing, i.e. the time of arrival of the load interval is random. The transactional load this random nature of this article negative exponential distribution to describe. And in accordance with the load distribution and input parameters to calculate the performance of the system. The experimental system including the analog part and the real implementation section. The implementation of the analog part load and the load used to simulate the database system and the database system and query scheduler connection. Experimental load the random arrival transactional load, simulated load random arrival characteristics, query cost distribution, query execution time distribution. Part of the real implementation of the query scheduler, which controls the execution of the load. The simulation experiment is divided into three parts: the uncontrolled experiment, the priority control the experiment, the query scheduler control experiments. The first two parts of the third part of a control experiment. The experimental results show that the query scheduler to control the load equally effective trading. Thus proving the validity the AWMF of the transaction class load.

Related Dissertations

  1. The Representation and Organization of Knowledge Rules in Workload Adaptation Database,TP311.13
  2. Research on Adaptive Resource Allocation in MIMO-OFDM System,TN919.3
  3. Research on a Novel Induction Heating Power Controlled by the LAPS-PWM Strategy,TP13
  4. Research on Modeling and Robust Control for Direct Tension System of 2030 Cold Tandem Rolling Mill,TG333
  5. Database load adaptive software architecture design and implementation framework,TP311.13
  6. Research on Node Potential Oriented Multi-NextHop Routing Protocol and Performance Evaluation,TN915.04
  7. Research on Workload Adaptation Technology for DBMS,TP311.13
  8. Low power feeder terminal of load switch,TM564
  9. The Investigation and Resolving of Unstable Reading Problem of NOR Flash Memory,TN407
  10. Research on F&B Index Structure Supporting XML Query,TP311.13
  11. Research on Compression, Operation and Query Processing Methods of Massive Datasets,TP311.13
  12. Research and Implementation of Mining Implicit User Interest,TP311.13
  13. Implementation of Data Compression, Operation and Query Processing System Based on BAP,TP311.13
  14. The Design and Implementation of DICOM Middle Software and Access Control Model in Formation Integration Platform,TP311.13
  15. Research and Improvement on K-Means Clustering Algorithm,TP311.13
  16. Study of Data Reduction Technique Based on Manifold Learning,TP311.13
  17. Research on K-means Optimization Clustering Algorithm,TP311.13
  18. Clustering Method Research Based on Divided and Conquered Method,TP311.13
  19. Incomplete information on the completeness of the system and its knowledge acquisition,TP311.13
  20. Evolutionary Clustering Algorithm and Its Application,TP311.13
  21. The Research and Application of Data Mart in the Telecommunication Business Analysis,TP311.13

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