Two-dimensional substring indexing

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

    Research output: Contribution to conferencePaperpeer-review


    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)
    Number of pages7
    StatePublished - 2001
    Event20th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems - Santa Barbara, CA, United States
    Duration: May 21 2001May 23 2001


    Conference20th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems
    Country/TerritoryUnited States
    CitySanta Barbara, CA

    ASJC Scopus subject areas

    • Software
    • Information Systems
    • Hardware and Architecture


    Dive into the research topics of 'Two-dimensional substring indexing'. Together they form a unique fingerprint.

    Cite this