ABSTRACT

This study presents the Design and Performance Analysis of a Control System for Data Base System Management. Automatic tuning has been an elusive goal for database technology for a long time and is becoming a pressing issue for modern E-services. The research presented how relevant control-theoretical techniques can be used to solve typical problems in the database management system. One of the major difficulties in using formal methods to study such problems is the lack of accurate analytical models for complex database systems. The study presented a PID controller which combines Proportional action, Integral action and Derivative action in its operation making it the most complete controller available which provides a quick response, a control signal that tends to provide stability to the system and a minimum steady state error. The fuzzy Inference System (FIS) was presented to be able to design a database model suitable for this work. The research presented two models, one is the conventional model and the second is the optimized model. Some key performance indicators were examined in the conventional model involving two databases, database A and B. The key performance indicators includes; The database size, the database speed (flow rate), the database access rate and the database processing. The simulation results of the two models were compared in areas of data flow rate, data access rate, data flow error and also the simulation output rule behaviors. The result from the simulation proved the effectiveness of the optimized model which tends to provide stability to the system, a seamless flow of data and a minimum steady state error. This guarantees its ability to optimize the performance of the database. The developed optimized model was able to improve on the workload of the Database Management System (DBMS), Database stability is 60%, Optimized flow rate 50%, Database access rate 50% and the Database error rate is 30%.