This Article 
 Bibliographic References 
 Add to: 
Coupling Production Systems and Database Systems: A Homogeneous Approach
April 1993 (vol. 5 no. 2)
pp. 240-256

Methods for storing and manipulating large rule bases using a relational database management systems (DBMS) are discussed. An approach to decomposing and storing the condition elements in the antecedents of rules such as those used in production rule-based systems is presented. A set-oriented approach, DBCond, which uses a special data structure that is implemented using relations is proposed. A matching algorithm for DBCond uses the relational structures to efficiently identify rules whose antecedents are satisfied. The performance of DBCond is compared with that of DBRete, a DBMS implementation of the Rete match algorithm developed for use with the production rule language OPS5. DBCond is also compared with DBQuery, a method that is based on evaluating queries corresponding to the conditions in the antecedents of the rules. Improvements to the data structure and the algorithms of the DBCond method are described. An advantage of DBCond is that it is fully parallelizable, thus making it attractive for parallel computing environments.

[1] J. Blakeley, P. Larson, and F. Tompa, "Efficiently updating materialized views," inProc. ACM-SIGMOD Int. Conf Management of Data, Washington, May 28-30, 1986.
[2] J. A. Blakeley, N. Coburn, and P.-A. Larson, "Updating derived relations: Detecting irrelevant and autonomously computable updates," inProc. Very Large Data Bases, 1986, pp. 457-466.
[3] O. P. Buneman and E. K. Clemons, "Efficiently monitoring relational databases,"Trans. Database Syst., vol. 4, no. 3, pp. 368-382, 1979.
[4] U. S. Chakravarthy and J. Minker, "Multiple query processing in deductive databases using query graphs," inProc. Int. Conf. Very Large Data Bases, Kyoto, Japan, Aug. 1986, pp. 384-391.
[5] S. Chakravarthy, "Rule management and evaluation: An active DBMS perspective,"SIGMOD REC., Special Issue on Rule Management and Processing in Expert Database Systems, vol. 18, no. 3, Sept. 1989.
[6] C. de Maindreville and E. Simon, "A Production Rule-Based Approach to Deductive Databases,"Proc. IEEE Int'l Conf. Data Engineering, J. Carlis, ed., IEEE Computer Society Press, Los Alamitos, Calif., Feb. 1988.
[7] U. Dayal et al., "The HiPAC Project: Combining active databases and timing constraints,"SIGMOD Rec., vol. 17, no. 1, 1988.
[8] L. M. L. Delcambre, "RPL: An expert system language with query power,"IEEE Expert, vol. 3, 1988.
[9] L. Delcambre, J. Waramahaputi, and J. Etheredge, "Pattern match reduction for the relational production language in the USL MMDBS," inSIGMOD Rec., vol. 18, no. 3, 1989.
[10] K. P. Eswaran, J. N. Gray, R. A. Lorie, and I. L. Traiger, "The notions of consistency and predicate locks in a database system,"Commun. ACM, vol. 19, no. 11, pp. 624-633, Nov. 1976.
[11] C. L. Forgy, "OPS5 user's manual," Tech. Rep. CMU-CS-81-135, Carnegie-Mellon Univ., 1981.
[12] C. L. Forgy, "Rete: A fast algorithm for the many pattern/many obiect pattern match problem,"Artif. Intell., vol. 19, 1982.
[13] E. Hansen, "An initial report on the design of ARIEL," inSIGMOD Rec., Sept. 1989.
[14] F. Hayes-Roth, "Rule-based systems,"Commun. ACM, vol. 28, no. 9, pp. 921-932, Sept. 1985.
[15] L. Kershberg, ed.,Expert Database Systems: Proceedings From the First International workshop. Menlo Park, CA: Benjamin/Cummings, 1986.
[16] L. Kershberg,Expert Database Systems: Proceedings From the First International Conference. Menlo Park, CA: Benjamin/Cummings, 1987.
[17] L. Kershberg,Expert Database Systems: Proceedings From the Second International Conference. Menlo Park, CA: Benjamin/Cummings, 1988.
[18] J. Kierman, C. de Maindreville, and E. Simon, "The design and implementation of an extendible deductive database system," inSIGMOD Rec., vol. 18, no. 3, 1989.
[19] C.-C. Lin, "Coupling production systems and database systems: A homogeneous approach," Ph.D. dissertation, Dep. Comput. Sci., Univ. of Maryland, College Park, MD, 1990.
[20] D. Miranker, "TREAT: A better match algorithm for AI production systems," inProc. 1987 Nat. Conf. on Artificial Intelligence, Seattle, WA, 1987.
[21] L. Raschid, T. Sellis, and C.C. Lin, "Exploiting concurrency in a DBMS implementation for production systems," inProc. Int. Symp. Databases Parallel Distributed Syst., 1988.
[22] L. Raschid, "A semantics for a class of stratified production system programs," to be published.
[23] T. Sellis, "Multiple-query optimization,"ACM Trans. Database Syst., vol. 13, no. 1, Mar. 1988.
[24] T. K. Sellis, C.-C. Lin, and L. Raschid, "Implementing large production systems in a DBMS environment: Concepts and algorithms," inProc. ACM SIGMOD Int. Conf. Management Data, Chicago, IL, 1988.
[25] T. Sellis, ed. "Special issue on rule management and processing in expert database systems,"SIGMOD Rec., vol. 18, no. 3, 1989.
[26] M. Stonebraker, "Implementation of integrity constraints and views by query modification," inProc. 1975 ACM-SIGMOD Int. Conf. Management of Data, San Jose, CA, June 1975.
[27] M. Stonebraker, T. Sellis, and E. Hanson, "Rule indexing implementations in database systems," inExpert Database Systems: Proceedings From the First International Conference. Menlo Park, CA: Benjamin/Cummings, 1987.
[28] M. Stonebraker, E. N. Hanson, and S. Potamianos, "The POSTGRES rule manager,"IEEE Trans. Software Eng., vol. 14, 1988.
[29] M. Stonebrakeret al., "Commentary on the POSTGRES rules system,"SIGMOD Rec., Sept. 1989.
[30] J. Widom and S. Finkelstein, "Set-oriented production rules in relational database systems," inProc. ACM-Sigmod Int. Conf. on Management of Data, 1990.

Index Terms:
large rule bases; relational database management systems; condition elements; production rule-based systems; set-oriented approach; DBCond; special data structure; matching algorithm; relational structures; DBRete; DBMS implementation; Rete match algorithm; production rule language OPS5; DBQuery; parallelizable; parallel computing environments; deductive databases; knowledge based systems; relational databases; set theory
T. Sellis, C.-C. Lin, L. Raschid, "Coupling Production Systems and Database Systems: A Homogeneous Approach," IEEE Transactions on Knowledge and Data Engineering, vol. 5, no. 2, pp. 240-256, April 1993, doi:10.1109/69.219733
Usage of this product signifies your acceptance of the Terms of Use.