 |
|
|
Heterogeneous Database Query Optimization in DB2 Universal DataJoiner |
Full Paper (PDF)
|
DataJoiner (DJ) is a heterogeneous database system that provides a single database image of multiple databases.
It provides transparent access to tables at remote databases through user defined aliases (nicknames) that can be accessed as if they were local tables.
DJ is also a fully functional relational database system.
A couple of salient features of the DataJoiner query optimizer are: (1) A query submitted to DataJoiner is optimized using a cost model that takes into account the remote optimizer's capabilities in addition to the remote query processing capabilities and (2) If a remote database system lacks some functionality (eg: sorting), DataJoiner compensates for it.
In this paper, we present the design of the DataJoiner query optimizer.
|
References, where available, link to the DBLP on the World Wide Web.
[AL90]Amit P. Sheth, James A. Larson:
Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases.
Computing Surveys 22(3): 183-236(1990)[DKS92]Weimin Du, Ravi Krishnamurthy, Ming-Chien Shan:
Query Optimization in a Heterogeneous DBMS.
VLDB 1992: 277-291[GLS93]Peter Gassner, Guy M. Lohman, K. Bernhard Schiefer, Yun Wang:
Query Optimization in the IBM DB2 Family.
Data Engineering Bulletin 16(4): 4-18(1993)[HKWY97]Laura M. Haas, Donald Kossmann, Edward L. Wimmers, Jun Yang:
Optimizing Queries Across Diverse Data Sources.
VLDB 1997: 276-285[PHH92]Hamid Pirahesh, Joseph M. Hellerstein, Waqar Hasan:
Extensible/Rule Based Query Rewrite Optimization in Starburst.
SIGMOD Conference 1992: 39-48[RH98]Fernando de Ferreira Rezende, Klaudia Hergula:
The Heterogeneity Problem and Middleware Technology: Experiences with and Performance of Database Gateways.
VLDB 1998: 146-157[TRS97]Mary Tork Roth, Peter M. Schwarz:
Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources.
VLDB 1997: 266-275
|
@inproceedings{DBLP:conf/vldb/VenkataramanZ98,
author = {Shivakumar Venkataraman and
Tian Zhang},
editor = {Ashish Gupta and
Oded Shmueli and
Jennifer Widom},
title = {Heterogeneous Database Query Optimization in DB2 Universal DataJoiner},
booktitle = {VLDB'98, Proceedings of 24rd International Conference on Very
Large Data Bases, August 24-27, 1998, New York City, New York,
USA},
publisher = {Morgan Kaufmann},
year = {1998},
isbn = {1-55860-566-5},
pages = {685-689},
crossref = {DBLP:conf/vldb/98},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
|
DBLP: Copyright ©1999 by Michael Ley (ley@uni-trier.de).
|
|
