A Cost Evaluator for Parallel Database Systems

The design of ESQL queries Optimizer may be decomposed into three dimensions: (i) the search space which defines the syntactic representation of all relevant aspects of an execution, (ii) the search strategy used to generate an optimal execution plan and (iii) the cost evaluator which calculates the metrics used by the search strategies. In this paper, we investigate issues involved in designing and using a cost evaluator, separate from the Optimizer, for queries optimization in parallel database environments. This cost evaluator can be seen as an extension of the cost evaluator of the EDS [1], DBS3 [3, 20] parallel database systems and the Papyrus project [7].

[1]  Patrick Valduriez,et al.  ESQL2: an object-oriented SQL with F-Logic semantics , 1992, [1992] Eighth International Conference on Data Engineering.

[2]  Wei Hong,et al.  Exploiting inter-operation parallelism in XPRS , 1992, SIGMOD '92.

[3]  Michel Couprie,et al.  A Multi-Environment Cost Evaluator for Parallel Database Systems , 1991, DASFAA.

[4]  C. Murray Woodside,et al.  Fast Allocation of Processes in Distributed and Parallel Systems , 1993, IEEE Trans. Parallel Distributed Syst..

[5]  Patrick Valduriez,et al.  Prototyping DBS3, a shared-memory parallel database system , 1991, [1991] Proceedings of the First International Conference on Parallel and Distributed Information Systems.

[6]  Mike Ward,et al.  A Compositional Approach for the Design of a Parallel Query Processing Language , 1992, PARLE.

[7]  Abdelkader Hameurlain,et al.  An Optimization Method of data Communication and Control for Parallel Execution of SQL Queries , 1993, DEXA.

[8]  Patrick Valduriez,et al.  Join and Semijoin Algorithms for a Multiprocessor Database Machine , 1984, TODS.

[9]  Philip S. Yu,et al.  Using Segmented Right-Deep Trees for the Execution of Pipelined Hash Joins , 1992, VLDB.

[10]  Arun N. Swami,et al.  Optimization of large join queries: combining heuristics and combinatorial techniques , 1989, SIGMOD '89.

[11]  Philip S. Yu,et al.  Parallel Query Processing , 1993, Advanced Database Systems.

[12]  Matthias Jarke,et al.  Query Optimization in Database Systems , 1984, CSUR.

[13]  Jeffrey F. Naughton,et al.  Practical selectivity estimation through adaptive sampling , 1990, SIGMOD '90.

[14]  Abdelkader Hameurlain,et al.  Exploiting Inter-Operation Parallelism for SQL Query Optimization , 1994, DEXA.

[15]  Guy M. Lohman,et al.  Measuring the Complexity of Join Enumeration in Query Optimization , 1990, VLDB.

[16]  Michael Stonebraker,et al.  Optimization of parallel query execution plans in XPRS , 1991, [1991] Proceedings of the First International Conference on Parallel and Distributed Information Systems.

[17]  Sumit Ganguly,et al.  Query optimization for parallel execution , 1992, SIGMOD '92.

[18]  David J. DeWitt,et al.  A performance evaluation of four parallel join algorithms in a shared-nothing multiprocessor environment , 1989, SIGMOD '89.

[19]  David J. DeWitt,et al.  Parallel database systems: the future of high performance database systems , 1992, CACM.

[20]  David J. DeWitt,et al.  Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines , 1990, VLDB.

[21]  Abdelkader Hameurlain,et al.  An Analytical Method to Allocate Processors in High Performance Parallel Execution of Recursive Queries , 1992, DEXA.

[22]  Allen Van Gelder,et al.  Measuring the effectiveness of optimization. Search Strategies , 1992, BDA.

[23]  Yannis E. Ioannidis,et al.  Randomized algorithms for optimizing large join queries , 1990, SIGMOD '90.

[24]  Michael Kifer,et al.  Filtering Data Flow in Deductive Databases , 1986, ICDT.

[25]  Mikal Ziane,et al.  Parallel query processing in DBS3 , 1993, [1993] Proceedings of the Second International Conference on Parallel and Distributed Information Systems.

[26]  Michael Stonebraker,et al.  The Design of XPRS , 1988, VLDB.

[27]  Patricia G. Selinger,et al.  Predictions and Challenges for Database Systems in the Year 2000 , 1993, VLDB.

[28]  Patrick Valduriez,et al.  Extending the Search Strategy in a Query Optimizer , 1991, VLDB.

[29]  Patrick Valduriez,et al.  On the Effectiveness of Optimization Search Strategies for Parallel Execution Spaces , 1993, VLDB.