Skip to main content
U.S. Department of Energy
Office of Scientific and Technical Information

Capabilities-based query rewriting in mediator systems

Conference ·
OSTI ID:535551
 [1];  [2];  [3]
  1. Stanford Univ., CA (United States)
  2. Junglee Corp., Palo Alto, CA (United States)
  3. IBM Almaden Research Center, San Jose, CA (United States)
Users today are struggling to integrate a broad range of information sources providing different levels of query capabilities. Currently, data sources with different and limited capabilities are accessed either by writing rich functional wrappers for the more primitive sources, or by dealing with all sources at a {open_quotes}lowest common denominator{close_quotes}. This paper explores a third approach, in which a mediator ensures that sources receive queries they can handle, while still taking advantage of all of the query power of the source. We propose an architecture that enables this, and identify a key component of that architecture, the Capabilities-Based Rewriter (CBR). The CBR takes as input a description of the capabilities of a data source, and a query targeted for that data source. From these, the CBR determines component queries to be sent to the sources, commensurate with their abilities, and computes a plan for combining their results using joins, unions, selections, and projections. We provide a language to describe the query capability of data sources and a plan generation algorithm. Our description language and plan generation algorithm are schema independent and handle SPJ queries.
OSTI ID:
535551
Report Number(s):
CONF-961209--; CNN: Contract F33615-93-C-1337
Country of Publication:
United States
Language:
English

Similar Records

The CMS DBS Query Language
Conference · Thu Dec 31 23:00:00 EST 2009 · J.Phys.Conf.Ser. · OSTI ID:1973955

Query-answering algorithms for information agents
Conference · Mon Dec 30 23:00:00 EST 1996 · OSTI ID:430632

Optimization of nested SQL queries revisited
Conference · Tue Mar 31 23:00:00 EST 1987 · OSTI ID:6470730