A Framework for Join Pattern Indexing in Intelligent Database Systems

In intelligent database systems, knowledge directed inference often derives large amounts of data, and the efficiency of query processing in these systems depends upon how the derived data is maintained. This paper focuses on situations where the rule is conditional on a join of multiple data objects (relations) and the rule-derived data are materialized to reduce the overall query processing costs. We develop an indexing technique based on a unique construct called join pattern relation. Several pattern redundancy reduction methods are also introduced to minimize the overhead cost of join indexing.

[1]  Arie Segev,et al.  Rule Management in Expert Database Systems , 1994 .

[2]  Patrick Valduriez,et al.  Join indices , 1987, TODS.

[3]  Bipin C. Desai Performance of a Composite Attribute and Join Index , 1989, IEEE Trans. Software Eng..

[4]  Michael Stonebraker,et al.  A commentary on the POSTGRES rules system , 1989, SGMD.

[5]  Arie Segev,et al.  Data Management for Large Rule Systems , 1991, VLDB.

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

[7]  Kevin Wilkinson,et al.  The Iris Architecture and Implementation , 1990, IEEE Trans. Knowl. Data Eng..

[8]  Eric N. Hanson,et al.  A performance analysis of view materialization strategies , 1987, SIGMOD '87.

[9]  Eric Simon,et al.  The design and implementation of an extendible deductive database system , 1989, SGMD.

[10]  Carlo Zaniolo,et al.  The LDL System Prototype , 1990, IEEE Trans. Knowl. Data Eng..

[11]  Timos K. Sellis,et al.  Coupling Production Systems and Database Systems: A Homogeneous Approach , 1993, IEEE Trans. Knowl. Data Eng..

[12]  Hamid Pirahesh,et al.  Starburst Mid-Flight: As the Dust Clears , 1990, IEEE Trans. Knowl. Data Eng..

[13]  Michael J. Carey,et al.  A performance evaluation of pointer-based joins , 1990, SIGMOD '90.

[14]  Eric N. Hanson,et al.  An initial report on the design of Ariel DBMS with an integrated production rule system , 1989, SGMD.

[15]  Charles Kellogg,et al.  Optimizing the Rule-Data Interface in a KMS , 1986, VLDB.

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

[17]  Peter M. D. Gray Logic, algebra and databases , 1984, Ellis Horwood series in computers and their applications.