Title :
Join query optimization in parallel database systems
Author :
Jhingran, Anant ; Padmanabhan, Sriram ; Shatdal, Ambuj
Author_Institution :
IBM T. J. Watson Res. Center, Yorktown Heights, NY, USA
fDate :
10/6/1993 12:00:00 AM
Abstract :
The authors present a new framework for studying query optimization. They first note that scheduling and optimization must go together in a parallel environment. They introduce the concept of response time envelopes which integrates scheduling and optimization. It is shown that it can be used effectively to develop parallel query optimization algorithms which have same order of complexity as the traditional sequential query optimization algorithms and produce provably optimal or near optimal join plans
Keywords :
distributed databases; optimisation; parallel algorithms; query processing; scheduling; complexity; parallel database systems; query optimization; query optimization algorithms; response time envelopes; scheduling; Concurrent computing; Cost function; Database systems; Delay; Dynamic programming; Heuristic algorithms; Optimization methods; Petroleum; Processor scheduling; Query processing;
Conference_Titel :
Advances in Parallel and Distributed Systems, 1993., Proceedings of the IEEE Workshop on
Conference_Location :
Princeton, NJ
Print_ISBN :
0-8186-5250-0
DOI :
10.1109/APADS.1993.588851