Integrating IR and RDBMS Using Cooperative Indexing.

Samuel DeFazio, Amjad M. Daoud, Lisa Ann Smith, Jagannathan Srinivasan, W. Bruce Croft, James P. Callan: Integrating IR and RDBMS Using Cooperative Indexing. SIGIR 1995: 84-92

@inproceedings{DBLP:conf/sigir/DeFazioDSSCC95,
  author    = {Samuel DeFazio and
               Amjad M. Daoud and
               Lisa Ann Smith and
               Jagannathan Srinivasan and
               W. Bruce Croft and
               James P. Callan},
  editor    = {Edward A. Fox and
               Peter Ingwersen and
               Raya Fidel},
  title     = {Integrating IR and RDBMS Using Cooperative Indexing},
  booktitle = {SIGIR'95, Proceedings of the 18th Annual International ACM SIGIR
               Conference on Research and Development in Information Retrieval.
                Seattle, Washington, USA, July 9-13, 1995 (Special Issue of
               the SIGIR Forum)},
  publisher = {ACM Press},
  year      = {1995},
  isbn      = {0-89791-714-6},
  pages     = {84-92},
  ee        = {db/conf/sigir/DeFazioDSSCC95.html},
  crossref  = {DBLP:conf/sigir/95},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

BibTeX

Abstract

The full integration of information retrieval (IR) features into a database management system (DBMS) has long been recognized as both a significant goal and a challenging undertaking. By full integration we mean:

support for document storage, indexing, retrieval, and update,
transaction semantics, thus all database operations on documents have the ACID properties of atomicity, consistency, isolation, and durability,
concurrent addition, update, and retrieval of documents, and
database query language extensions to provide ranking for document retrieval operations.

It is also necessary for the integrated offering to exhibit scaleable performance for document indexing and retrieval processes. To identify the implementation requirements imposed by the desired level of integration, we layered a representative IR application on Oracle Rdb and then conducted a number of database load and document retrieval experiments. The results of these experiments suggest that infrastructural extensions are necessary to obtain both the desired level of IR integration and scaleable performance. With the insight gained from our initial experiments, we developed an approach, called cooperative indexing, that provides a framework to achieve both scalability and full integration of IR and RDBMS technology. Prototype implementations of system-level extensions to support cooperative indexing were evaluated with a modified version of Oracle Rdb. Our experimental findings validate the cooperative indexing scheme and suggest alternatives to further improve performance.

Copyright © 1995 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 2 Issue 3, SIGIR, DASFAA'97, OODBS'86" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the CD and click on the path of your mount point:
/Anthology/An2-3 or /cdrom

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the DVD and click on the path of your mount point:
/Anthology/aDVD1 or /dvd

BibTeX

Printed Edition

Edward A. Fox, Peter Ingwersen, Raya Fidel (Eds.): SIGIR'95, Proceedings of the 18th Annual International ACM SIGIR Conference on Research and Development in Information Retrieval. Seattle, Washington, USA, July 9-13, 1995 (Special Issue of the SIGIR Forum). ACM Press 1995, ISBN 0-89791-714-6
Contents BibTeX

Online Edition: ACM Digital Library

Citation page

Referenced by

Kothuri Venkata Ravi Kanth, Siva Ravada, Jayant Sharma, Jay Banerjee: Indexing Medium-dimensionality Data in Oracle. SIGMOD Conference 1999: 521-522
Stefan Deßloch, Nelson Mendonça Mattos: Integrating SQL Databases with Content-Specific Search Engines. VLDB 1997: 528-537
S. R. Vasanthakumar, James P. Callan, W. Bruce Croft: Integrating INQUERY with an RDBMS to Support Text Retrieval. IEEE Data Eng. Bull. 19(1): 24-33(1996)
Daniel Knaus, Peter Schäuble: The System Architecture and the Transaction Concept of the SPIDER Information Retrieval System. IEEE Data Eng. Bull. 19(1): 43-52(1996)
Samuel DeFazio, Jagannathan Srinivasan: Database Extensions for Complex Domains. ICDE 1996: 200-202

BibTeX

ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]