Two-dimensional substring indexing

P. Ferragina, N. Koudas, S. Muthukrishnan, D. Srivastava

    Research output: Contribution to conferencePaper

    Abstract

    As databases have expanded in scope to storing string data (XML documents, product catalogs), it has become increasingly important to search databases based on matching substrings, often on multiple, correlated dimensions. While string B-trees are I/O optimal in one dimension, no index structure with non-trivial query bounds is known for two-dimensional substring indexing. In this paper, we present a technique for two-dimensional substring indexing based on a reduction to the geometric problem of identifying common colors in two ranges containing colored points. We develop an I/O efficient algorithm for solving the common colors problem, and use it to obtain an I/O efficient (poly-logarithmic query time) algorithm for the two-dimensional substring indexing problem. Our techniques result in a family of secondary memory index structures that trade space for time, with no loss of accuracy. We show how our technique can be practically realized using a combination of string B-trees and R-trees.

    Original languageEnglish (US)
    Pages282-288
    Number of pages7
    StatePublished - Jan 1 2001
    Event20th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems - Santa Barbara, CA, United States
    Duration: May 21 2001May 23 2001

    Conference

    Conference20th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems
    CountryUnited States
    CitySanta Barbara, CA
    Period5/21/015/23/01

      Fingerprint

    ASJC Scopus subject areas

    • Software
    • Information Systems
    • Hardware and Architecture

    Cite this

    Ferragina, P., Koudas, N., Muthukrishnan, S., & Srivastava, D. (2001). Two-dimensional substring indexing. 282-288. Paper presented at 20th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, Santa Barbara, CA, United States.