Search Space Reduction Using Approximate Results
Embodiments include systems, methods and computer-readable mediums for accelerating a database query containing multiple predicates connected conjunctively. The database system receives a database query on a table. The database query includes a first predicate and a second predicate connected conjun...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
Format: | Patent |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | Embodiments include systems, methods and computer-readable mediums for accelerating a database query containing multiple predicates connected conjunctively. The database system receives a database query on a table. The database query includes a first predicate and a second predicate connected conjunctively. The database system produces a search space that satisfies a pre-filter for the first predicate. The search space represents rows of the table that satisfy the first predicate. The database system then applies the search space to evaluation of the second predicate. In one embodiment, the first predicate is a LIKE predicate requesting rows matching a search string in a column, and the pre-filter is a word index representing rows of the table containing a token of the search string in the column. |
---|