RULE SCHEDULING IN ACTIVE DATABASE USING LEARNING AUTOMATA

Active database systems (ADBS) can react to the occurrence of predefined events automatically by definition a collection of active rules. One of the most important modules of ADBS is the rule scheduler, which has considerable impact on performance and efficiency of ADBS. Rule scheduler selects a rule to execute (evaluate) its action (condition) section in each time through the rules, which are ready for execution (evaluation). We have already evaluated and compared the existing rule scheduling approaches in a laboratorial environment based on three-tier architecture. Five evaluation criteria were recognized and defined formally for evaluation and comparison of rule scheduling approaches including: Average Response Time, Response Time Variance, Throughput, Time Overhead per Transaction and CPU Utilization. At last, we introduced the most effective approach. In this paper, we first, design and implement the before mentioned laboratorial environment again to over and simulate the behavior of ADBS more exactly and completely, then propose a new approach to improve the rule scheduling process based on improvement of triggered rule scheduling using learning automaton. Then, we compare it with the most effective existing approach in the mentioned framework. Results of experiments show that the new method improves the rule scheduling.

[1]  Kumpati S. Narendra,et al.  Learning automata - an introduction , 1989 .

[2]  Klaus R. Dittrich,et al.  Investigating Termination in Active Database Systems with Expressive Rule Languages , 1997, Rules in Database Systems.

[3]  Ahmad Abdollahzadeh Barforoush,et al.  Measuring Evaluation Parameters in Benchmarking Rule Scheduling Methods in Active Database Systems , 2006 .

[4]  Marco Spuri,et al.  Implications of Classical Scheduling Results for Real-Time Systems , 1995, Computer.

[5]  Klaus R. Dittrich,et al.  Events in an Active Object-Oriented Database System , 1993, Rules in Database Systems.

[6]  Klaus R. Dittrich,et al.  Architecture and Implementation of the Active Object-OrientedDatabase Management System SAMOS , 1995 .

[7]  B. R. Harita,et al.  Learning automata with changing number of actions , 1987, IEEE Transactions on Systems, Man, and Cybernetics.

[8]  Jennifer Widom,et al.  An overview of production rules in database systems , 1993, The Knowledge Engineering Review.

[9]  A. Rasoolzadegan,et al.  A New Approach for Event Triggering Probability Estimation in Active Database Systems to Rule Scheduling Improvement , 2006, 2006 2nd International Conference on Information & Communication Technologies.

[10]  Stefano Paraboschi,et al.  Effective Scheduling of Detached Rules in Active Databases , 2003, IEEE Trans. Knowl. Data Eng..

[11]  P. S. Sastry,et al.  Varieties of learning automata: an overview , 2002, IEEE Trans. Syst. Man Cybern. Part B.

[12]  Ahmad Abdollahzadeh Barforoush,et al.  A New Rule Scheduling Approach based on Estimation of Rule Execution Probability in Active Database , 2008, J. Convergence Inf. Technol..

[13]  Donald F. Towsley,et al.  Priority assignment in real-time active databases , 1996, The VLDB Journal.