Title
Selection predicate indexing for active databases using interval skip lists
Abstract
A new, efficient selection predicate indexing scheme for active database systems is introduced. The selection predicate index proposed uses an interval index on an attribute of a relation or object collection when one or more rule condition clauses are defined on that attribute. The selection predicate index uses a new type of interval index called the interval skip list (IS-list). The IS-list is designed to allow efficient retrieval of all intervals that overlap a point, while allowing dynamic insertion and deletion of intervals. IS-list algorithms are described in detail. The IS-list allows efficient on-line searches, insertions, and deletions, yet is much simpler to implement than other comparable interval index data structures such as the priority search tree and balanced interval binary search tree (IBS-tree). IS-lists require only one third as much code to implement as balanced IBS-trees. The combination of simplicity, performance, and dynamic updateability of the IS-list is unmatched by any other interval index data structure. This makes the IS-list a good interval index structure for implementation in an active database predicate index. ‡ ‡ The C++ source code for interval skip lists can be obtained at http://www.cis.ufl.edu/~hanson/IS-lists/ or by sending a request by e-mail.
Year
DOI
Venue
1996
10.1016/0306-4379(96)00015-4
Inf. Syst.
Keywords
Field
DocType
active databases,selection predicate indexing,discrimination networks,predicate indexing,interval skip lists,triggers,skip list,indexation
Data mining,Data structure,Search algorithm,Computer science,Skip list,Search engine indexing,Predicate (grammar),Active database,Binary search tree,Database,Search tree
Journal
Volume
Issue
ISSN
21
3
Information Systems
Citations 
PageRank 
References 
37
7.59
18
Authors
2
Name
Order
Citations
PageRank
Eric N. Hanson1917376.11
Theodore Johnson2438.58