An algorithmic basis for integrating production systems and large databases

Executing a large number of transactions on a large database within a short amount of time is computationally stressful. Main-memory resident production systems have been made computationally feasible by the development of incremental match algorithms that exploit the temporal redundancy of the database by saving results computed in prior cycles. Unfortunately, the worst-case space complexity of these match algorithms is exponential, and space management becomes a dominant issue. A lazy incremental match algorithm with linear worst-case space complexity is presented. Initial empirical results show that Lazy Match can prune 60% of the search for rule instantiations. It is felt that these results provide the first reasonable algorithmic basis upon which one can develop an active database system.<<ETX>>

[1]  Salvatore J. Stolfo,et al.  A simple preprocessing scheme to extract and balance implicit parallelism in the concurrent match of production rules , 1986 .

[2]  Charles L. Forgy,et al.  Rete: a fast algorithm for the many pattern/many object pattern match problem , 1991 .

[3]  Frank Wm. Tompa,et al.  Efficiently updating materialized views , 1986, SIGMOD '86.

[4]  Jeffrey D. Ullman,et al.  Implementation of logiclal query languages for databases (abstract only) , 1985, SIGMOD Conference.

[5]  Stanley Y. W. Su,et al.  A Transaction Oriented Mechanism to Control Processing in a Knowledge Base Management System , 1988, Expert Database Conf..

[6]  J. McDermott,et al.  Production system conflict resolution strategies , 1977, SGAR.

[7]  Timos K. Sellis,et al.  Exploiting Concurrency in a DBMS Implementation for Production Systems , 1988, Proceedings [1988] International Symposium on Databases in Parallel and Distributed Systems.

[8]  Charles L. Forgy,et al.  OPS5 user's manual , 1981 .

[9]  Charles L. Forgy,et al.  Rete: A Fast Algorithm for the Many Patterns/Many Objects Match Problem , 1982, Artif. Intell..

[10]  Irving L. Traiger,et al.  System R: relational approach to database management , 1976, TODS.

[11]  Michael Stonebraker,et al.  The Design of the POSTGRES Storage System , 1988, VLDB.

[12]  Roger King,et al.  MOBY: An Architecture for Distributed Expert Database Systems , 1987, VLDB.

[13]  Eric K. Clemons,et al.  Efficiently monitoring relational databases , 1979, ACM Trans. Database Syst..

[14]  Don S. Batory,et al.  GENESIS: An Extensible Database Management System , 1988, IEEE Trans. Software Eng..

[15]  Alfred G. Dale,et al.  Scalability of Parallel Joins on High Performance Multicomputers , 1989 .

[16]  Daniel P. Miranker TREAT: a better match algorithm for AI production systems , 1987, AAAI 1987.

[17]  C. Forgy,et al.  PRODUCTION SYSTEM CONFLICT RESOLUTION STRATEGIES1 , 1978 .

[18]  Salvatore J. Stolfo,et al.  DADO: A Parallel Processor for Expert Systems , 1984 .

[19]  Allen Newell,et al.  High-speed implementations of rule-based systems , 1989, TOCS.