Two-dimensional substring indexing

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

Research output: Contribution to journalArticlepeer-review

19 Scopus citations


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

All Science Journal Classification (ASJC) codes

  • Theoretical 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