A Geometric Approach to Indexing Large Rule Bases

The efficiency of finding qualifying rules against updates in large production systems has always been an important research issue. In database implementations of rule systems, this problem is even more critical. Predicate Indexing is a reduced version of the above problem when only selection conditions are considered. In this paper we draw a similarity between predicate indexing and indexing of geometric data, and discuss index design issues. Results from experiments using special data structures are also presented.

[1]  M. Schkolnick,et al.  Physical database design for relational databases , 1988, TODS.

[2]  J. T. Robinson,et al.  The K-D-B-tree: a search structure for large multidimensional dynamic indexes , 1981, SIGMOD '81.

[3]  Christos Faloutsos,et al.  The R+-Tree: A Dynamic Index for Multi-Dimensional Objects , 1987, VLDB.

[4]  Douglas Comer,et al.  The difficulty of optimum index selection , 1978, TODS.

[5]  Michael Stonebraker,et al.  An Analysis of Rule Indexing Implementations in Data Base Systems , 1986, Expert Database Conf..

[6]  Michael Stonebraker,et al.  The POSTGRES Rule Manager , 1988, IEEE Trans. Software Eng..

[7]  Timos K. Sellis,et al.  Data intensive production systems: the DIPS approach , 1989, SGMD.

[8]  Hanan Samet,et al.  The Design and Analysis of Spatial Data Structures , 1989 .

[9]  Timos K. Sellis,et al.  Special Issue on Rule Management and Processing in Expert Database Systems - Letter from the Guest Editor , 1989, SIGMOD Rec..

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

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

[12]  Anoop Gupta.  Parallelism in production systems , 1987 .

[13]  Eric N. Hanson,et al.  A predicate matching algorithm for database rule systems , 1990, SIGMOD '90.

[14]  David S. Johnson,et al.  Computers and Intractability: A Guide to the Theory of NP-Completeness , 1978 .

[15]  Christos Faloutsos,et al.  Analysis of object oriented spatial access methods , 1987, SIGMOD '87.

[16]  C. L. Liu,et al.  Introduction to Combinatorial Mathematics. , 1971 .

[17]  Antonin Guttman,et al.  R-trees: a dynamic index structure for spatial searching , 1984, SIGMOD '84.