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}
}
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 ...
References
- [ALM94]
- ...
- [Ant91]
- ...
- [Ant92]
- Gennady Antoshenkov:
Random Sampling from Pseudo-Ranked B+ Trees.
VLDB 1992: 375-382

- [Ant93a]
- Gennady Antoshenkov:
Dynamic Query Optimization in Rdb/VMS.
ICDE 1993: 538-547

- [Antoshenkov 93b]
- Gennady Antoshenkov:
Query Processing in DEC Rdb: Major Issues and Future Challenges.
IEEE Data Eng. Bull. 16(4): 42-52(1993)

- [Ant95]
- ...
- [Babb79]
- Edward Babb:
Implementing a Relational Database by Means of Specialized Hardware.
ACM Trans. Database Syst. 4(1): 1-29(1979)

- [BaUn77]
- Rudolf Bayer, Karl Unterauer:
Prefix B-Trees.
ACM Trans. Database Syst. 2(1): 11-26(1977)

- [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

- [DaNg82]
- Dean Daniels, Pui Ng:
Distributed Query Compilation and Processing in R*.
IEEE Database Eng. Bull. 5(3): 15-18(1982)

- [Gra94]
- Goetz Graefe, William J. McKenna:
The Volcano Optimizer Generator: Extensibility and Efficient Search.
ICDE 1993: 209-218

- [Gray93]
- Jim Gray (Ed.):
The Benchmark Handbook for Database and Transaction Systems (2nd Edition).
Morgan Kaufmann 1993, ISBN 1-55860-292-5
Contents

- [GrWa89]
- Goetz Graefe, Karen Ward:
Dynamic Query Evaluation Plans.
SIGMOD Conference 1989: 358-366

- [HaSw92]
- Peter J. Haas, Arun N. Swami:
Sequential Sampling Procedures for Query Size Estimation.
SIGMOD Conference 1992: 341-350

- [HoEn95]
- ...
- [INSS92]
- Yannis E. Ioannidis, Raymond T. Ng, Kyuseok Shim, Timos K. Sellis:
Parametric Query Optimization.
VLDB 1992: 103-114

- [IoCh91]
- Yannis E. Ioannidis, Stavros Christodoulakis:
On the Propagation of Errors in the Size of Join Results.
SIGMOD Conference 1991: 268-277

- [LiNS90]
- Richard J. Lipton, Jeffrey F. Naughton, Donovan A. Schneider:
Practical Selectivity Estimation through Adaptive Sampling.
SIGMOD Conference 1990: 1-11

- [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

- [OIRo89]
- Frank Olken, Doron Rotem:
Random Sampling from B+ Trees.
VLDB 1989: 269-277

- [Ren92]
- T. K. Rengarajan:
Rdb/VMS Support for Multi-media Databases.
SIGMOD Conference 1992: 287

- [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

- [Zipf49]
- George Kingsley Zipf:
Human Behaviour and the Principle of Least Effort: an Introduction to Human Ecology.
Addison-Wesley 1949

Copyright © Fri Dec 4 03:32:57 2009
by Michael Ley (ley@uni-trier.de)