Two-dimensional substring indexing

Paolo Ferragina, Nick Koudas, S. Muthukrishnan, Divesh Srivastava

    Research output: Contribution to journalArticlepeer-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.

    Original languageEnglish (US)
    Pages (from-to)763-774
    Number of pages12
    JournalJournal of Computer and System Sciences
    Issue number4
    StatePublished - Jun 2003

    ASJC Scopus subject areas

    • Theoretical Computer Science
    • General Computer Science
    • Computer Networks and Communications
    • Computational Theory and Mathematics
    • Applied Mathematics


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

    Cite this