Query Processing and Optimization in Oracle Rdb.
Gennady Antoshenkov, Mohamed Ziauddin:
Query Processing and Optimization in Oracle Rdb.
VLDB J. 5(4): 229-237(1996)@article{DBLP:journals/vldb/AntoshenkovZ96,
author = {Gennady Antoshenkov and
Mohamed Ziauddin},
title = {Query Processing and Optimization in Oracle Rdb},
journal = {VLDB J.},
volume = {5},
number = {4},
year = {1996},
pages = {229-237},
ee = {db/journals/vldb/AntoshenkovZ96.html},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
This paper contains an overview of the technology used in the query
processing and optimization component of
Oracle Rdb,
a relational database management system originally developed
by Digital Equipment Corporation and now under development
by Oracle Corporation.
Oracle Rdb is a production system that supports the most demanding
database applications, runs on multiple platforms and in a variety
of environments.
Key Words
Relational database, Optimizer, Dynamic optimization, Sampling,
Query Transformation
Copyright © 1996 by Springer, Berlin, Heidelberg.
Permission to make digital or hard copies of the abstract is granted provided that copies are not made or distributed for profit or
direct commercial advantage, and that copies show this notice along with the full citation.
Citation Page
CDROM Version: Load the CDROM "Volume 4 Issue 1, Books, VLDB-j, TODS, ..." and ...
DVD Version: Load ACM SIGMOD Anthology DVD 2" and ...
BibTeX
References
- [ALM94]
- ...
- [Ant91]
- ...
- [Ant92]
- Gennady Antoshenkov:
Random Sampling from Pseudo-Ranked B+ Trees.
VLDB 1992: 375-382 BibTeX
- [Ant93a]
- Gennady Antoshenkov:
Dynamic Query Optimization in Rdb/VMS.
ICDE 1993: 538-547 BibTeX
- [Antoshenkov 93b]
- Gennady Antoshenkov:
Query Processing in DEC Rdb: Major Issues and Future Challenges.
IEEE Data Eng. Bull. 16(4): 42-52(1993) BibTeX
- [Ant95]
- ...
- [Babb79]
- Edward Babb:
Implementing a Relational Database by Means of Specialized Hardware.
ACM Trans. Database Syst. 4(1): 1-29(1979) BibTeX
- [BaUn77]
- Rudolf Bayer, Karl Unterauer:
Prefix B-Trees.
ACM Trans. Database Syst. 2(1): 11-26(1977) BibTeX
- [CHHI91]
- Josephine M. Cheng, Donald J. Haderle, Richard Hedges, Balakrishna R. Iyer, Ted Messinger, C. Mohan, Yun Wang:
An Efficient Hybrid Join Algorithm: A DB2 Prototype.
ICDE 1991: 171-180 BibTeX
- [DaNg82]
- Dean Daniels, Pui Ng:
Distributed Query Compilation and Processing in R*.
IEEE Database Eng. Bull. 5(3): 15-18(1982) BibTeX
- [Gra94]
- Goetz Graefe, William J. McKenna:
The Volcano Optimizer Generator: Extensibility and Efficient Search.
ICDE 1993: 209-218 BibTeX
- [Gray93]
- Jim Gray (Ed.):
The Benchmark Handbook for Database and Transaction Systems (2nd Edition).
Morgan Kaufmann 1993, ISBN 1-55860-292-5
Contents BibTeX
- [GrWa89]
- Goetz Graefe, Karen Ward:
Dynamic Query Evaluation Plans.
SIGMOD Conference 1989: 358-366 BibTeX
- [HaSw92]
- Peter J. Haas, Arun N. Swami:
Sequential Sampling Procedures for Query Size Estimation.
SIGMOD Conference 1992: 341-350 BibTeX
- [HoEn95]
- ...
- [INSS92]
- Yannis E. Ioannidis, Raymond T. Ng, Kyuseok Shim, Timos K. Sellis:
Parametric Query Optimization.
VLDB 1992: 103-114 BibTeX
- [IoCh91]
- Yannis E. Ioannidis, Stavros Christodoulakis:
On the Propagation of Errors in the Size of Join Results.
SIGMOD Conference 1991: 268-277 BibTeX
- [LiNS90]
- Richard J. Lipton, Jeffrey F. Naughton, Donovan A. Schneider:
Practical Selectivity Estimation through Adaptive Sampling.
SIGMOD Conference 1990: 1-11 BibTeX
- [MHWC90]
- C. Mohan, Donald J. Haderle, Yun Wang, Josephine M. Cheng:
Single Table Access Using Multiple Indexes: Optimization, Execution, and Concurrency Control Techniques.
EDBT 1990: 29-43 BibTeX
- [OIRo89]
- Frank Olken, Doron Rotem:
Random Sampling from B+ Trees.
VLDB 1989: 269-277 BibTeX
- [Ren92]
- T. K. Rengarajan:
Rdb/VMS Support for Multi-media Databases.
SIGMOD Conference 1992: 287 BibTeX
- [Roy91]
- ...
- [SACL79]
- Patricia G. Selinger, Morton M. Astrahan, Donald D. Chamberlin, Raymond A. Lorie, Thomas G. Price:
Access Path Selection in a Relational Database Management System.
SIGMOD Conference 1979: 23-34 BibTeX
- [Zipf49]
- George Kingsley Zipf:
Human Behaviour and the Principle of Least Effort: an Introduction to Human Ecology.
Addison-Wesley 1949
BibTeX
Referenced by
- Ron Avnur, Joseph M. Hellerstein:
Eddies: Continuously Adaptive Query Processing.
SIGMOD Conference 2000: 261-272
- Vijayshankar Raman, Bhaskaran Raman, Joseph M. Hellerstein:
Online Dynamic Reordering for Interactive Data Processing.
VLDB 1999: 709-720
- Michael Jaedicke, Bernhard Mitschang:
User-Defined Table Operators: Enhancing Extensibility for ORDBMS.
VLDB 1999: 494-505
- Zachary G. Ives, Daniela Florescu, Marc Friedman, Alon Y. Levy, Daniel S. Weld:
An Adaptive Query Execution System for Data Integration.
SIGMOD Conference 1999: 299-310
- Michael Jaedicke, Bernhard Mitschang:
On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS.
SIGMOD Conference 1998: 379-389
- Phillip B. Gibbons, Yossi Matias:
New Sampling-Based Summary Statistics for Improving Approximate Query Answers.
SIGMOD Conference 1998: 331-342
- Joseph M. Hellerstein:
Online Processing Redux.
IEEE Data Eng. Bull. 20(3): 20-29(1997)
- Joseph M. Hellerstein, Peter J. Haas, Helen J. Wang:
Online Aggregation.
SIGMOD Conference 1997: 171-182
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Journal: 1992-1995 Copyright © by VLDB Endowment / 1996-... Copyright © by Springer Verlag,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sun May 17 00:31:28 2009