A Database Management System using Fuzzified Proportional Integral Controller

Abstract

This paper presents a database management system (DBMS) using a fuzzified proportional integral controller. Automatic tuning has been an elusive goal for database technology for a long time and is becoming a pressing issue for modern E-services. One of the major difficulties in using antique methods to study such problems is the lack of accurate analytical methods for complex database systems. In the past, researchers were faced with complex problems of managing scalability as data increases and maintenance of database performance. Two Simulink models were developed, namely the conventional model and the optimized model. An integrated fuzzy logic proportional integral (PI) controller was used to simulate the proposed models. The optimized model of DBMS makes use of a combination of fuzzy controllers and data processing subsystems multiplexed with data access system. The simulation results of the two models were compared in areas of data flow rate, data access rate, data flow error and output rule behaviors. The results obtained proved the effectiveness of the optimized model which tends to provide stability to the system and minimize steady state error. In conclusion, the developed optimized model was able to improve the workload of the database management system with database stability of 60%, optimized flow rate of 50% and database access rate of 50%, respectively.