Integrating SQL Databases with Content-Specific Search Engines.
Stefan Deßloch, Nelson Mendonça Mattos:
Integrating SQL Databases with Content-Specific Search Engines.
VLDB 1997: 528-537@inproceedings{DBLP:conf/vldb/DesslochM97,
author = {Stefan De{\ss}loch and
Nelson Mendon\c{c}a Mattos},
editor = {Matthias Jarke and
Michael J. Carey and
Klaus R. Dittrich and
Frederick H. Lochovsky and
Pericles Loucopoulos and
Manfred A. Jeusfeld},
title = {Integrating SQL Databases with Content-Specific Search Engines},
booktitle = {VLDB'97, Proceedings of 23rd International Conference on Very
Large Data Bases, August 25-29, 1997, Athens, Greece},
publisher = {Morgan Kaufmann},
year = {1997},
isbn = {1-55860-470-7},
pages = {528-537},
ee = {db/conf/vldb/DesslochM97.html},
crossref = {DBLP:conf/vldb/97},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
In recent years, database research and product development activities
have focused on support for non-traditional data types, such as text
or multi-media documents. This paper describes an approach of coupling
SQL databases and content-specific search engines, such as full-text
retrieval engines, in an efficient manner. It is based on a query
rewrite scheme that exploits so-called table functions, which are used
to pass results from external search engines into the database
engine. Using this approach the content-specific indexing mechanisms
of search engines can be exploited without having to extend the
database engine with new access methods, or having to break up the
search engine to map its indexing scheme to database index structures.
Copyright © 1997 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
Printed Edition
Matthias Jarke, Michael J. Carey, Klaus R. Dittrich, Frederick H. Lochovsky, Pericles Loucopoulos, Manfred A. Jeusfeld (Eds.):
VLDB'97, Proceedings of 23rd International Conference on Very Large Data Bases, August 25-29, 1997, Athens, Greece.
Morgan Kaufmann 1997, ISBN 1-55860-470-7
Contents
Electronic Edition
From CS Dept.,
University Trier (Germany)
References
- [Aok91]
- Paul M. Aoki:
Implementation of Extended Indexes in POSTGRES.
SIGIR Forum 25(1): 2-9(1991)
![bibliographical record in XML](../../xml.gif)
- [Car86]
- Michael J. Carey, David J. DeWitt, Daniel Frank, Goetz Graefe, M. Muralikrishna, Joel E. Richardson, Eugene J. Shekita:
The Architecture of the EXODUS Extensible DBMS.
OODBS 1986: 52-65
![bibliographical record in XML](../../xml.gif)
- [Cat96]
- R. G. G. Cattell:
The Object Database Standard: ODMG-93 (Release 1.2).
Morgan Kaufmann 1996
![bibliographical record in XML](../../xml.gif)
- [CD96]
- Michael J. Carey, David J. DeWitt:
Of Objects and Databases: A Decade of Turmoil.
VLDB 1996: 3-14
![bibliographical record in XML](../../xml.gif)
- [Cha96]
- Donald D. Chamberlin:
Using the New DB2: IBM's Object-Relational Database System.
Morgan Kaufmann 1996, ISBN 1-55860-373-5
![bibliographical record in XML](../../xml.gif)
- [Cot96a]
- ...
- [Cot96b]
- ...
- [CS93]
- Surajit Chaudhuri, Kyuseok Shim:
Query Optimization in the Presence of Foreign Functions.
VLDB 1993: 529-542
![bibliographical record in XML](../../xml.gif)
- [Dav96a]
- ...
- [Dav96b]
- ...
- [DDSS95]
- 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
![bibliographical record in XML](../../xml.gif)
- [GFHR97]
- David A. Grossman, Ophir Frieder, David O. Holmes, David C. Roberts:
Integrating Structured Data and Text: A Relational Approach.
JASIS 48(2): 122-132(1997)
![bibliographical record in XML](../../xml.gif)
- [Gut84]
- Antonin Guttman:
R-Trees: A Dynamic Index Structure for Spatial Searching.
SIGMOD Conference 1984: 47-57
![bibliographical record in XML](../../xml.gif)
- [HNP95]
- Joseph M. Hellerstein, Jeffrey F. Naughton, Avi Pfeffer:
Generalized Search Trees for Database Systems.
VLDB 1995: 562-573
![bibliographical record in XML](../../xml.gif)
- [HS93]
- Joseph M. Hellerstein, Michael Stonebraker:
Predicate Migration: Optimizing Queries with Expensive Predicates.
SIGMOD Conference 1993: 267-276
![bibliographical record in XML](../../xml.gif)
- [IBM95]
- ...
- [IBM96]
- ...
- [Jag90]
- H. V. Jagadish:
Spatial Search with Polyhedra.
ICDE 1990: 311-319
![bibliographical record in XML](../../xml.gif)
- [Kim95]
- Won Kim (Ed.):
Modern Database Systems: The Object Model, Interoperability, and Beyond.
ACM Press and Addison-Wesley 1995, ISBN 0-201-59098-0
Contents
![bibliographical record in XML](../../xml.gif)
- [KMH97]
- Marcel Kornacker, C. Mohan, Joseph M. Hellerstein:
Concurrency and Recovery in Generalized Search Trees.
SIGMOD Conference 1997: 62-72
![bibliographical record in XML](../../xml.gif)
- [LS88]
- Clifford A. Lynch, Michael Stonebraker:
Extended User-Defined Indexing with Application to Textual Databases.
VLDB 1988: 306-317
![bibliographical record in XML](../../xml.gif)
- [Loh91]
- Guy M. Lohman, Bruce G. Lindsay, Hamid Pirahesh, K. Bernhard Schiefer:
Extensions to Starburst: Objects, Types, Functions, and Rules.
Commun. ACM 34(10): 94-109(1991)
![bibliographical record in XML](../../xml.gif)
- [Mel96]
- ...
- [Sal89]
- Gerard Salton:
Automatic Text Processing: The Transformation, Analysis, and Retrieval of Information by Computer.
Addison-Wesley 1989, ISBN 0-201-12227-8
![bibliographical record in XML](../../xml.gif)
- [Schw96]
- Peter M. Schwarz, Walter Chang, Johann Christoph Freytag, Guy M. Lohman, John McPherson, C. Mohan, Hamid Pirahesh:
Extensibility in the Starburst Database System.
OODBS 1986: 85-92
![bibliographical record in XML](../../xml.gif)
- [Sto86]
- Michael Stonebraker:
Inclusion of New Types in Relational Data Base Systems.
ICDE 1986: 262-269
![bibliographical record in XML](../../xml.gif)
- [Sto96]
- Michael Stonebraker, Dorothy Moore:
Object-Relational DBMSs: The Next Great Wave.
Morgan Kaufmann 1996, ISBN 1-55860-397-2
![bibliographical record in XML](../../xml.gif)
- [ZM90]
- Stanley B. Zdonik, David Maier (Eds.):
Readings in Object-Oriented Database Systems.
Morgan Kaufmann 1990, ISBN 1-55860-000-0
![bibliographical record in XML](../../xml.gif)
Copyright © Fri Mar 12 17:22:56 2010
by Michael Ley (ley@uni-trier.de)