S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. ACM Trans. on Database Systems, 24(2):177--228, 1999.  Home/Search   Document Details and Download   Summary   Related Articles   Check

....plan. Cost based optimizers only use the selectivity of the predicates to order them in the query plan but do not consider their computational complexities. In [49, 48] Hellerstein et al. use both the selectivity and the cost of selection predicates to optimize queries with expensive UDFs. In [26], Chaudhari and Shim proposes dynamic programming based algorithms to optimize queries with expensive predicates. The techniques discussed above deal with UDF optimization when the functions appear in the where clause of an SQL query. Expensive UDFs can also appear in the projection clause as ....

Surajit Chaudhuri and Kyuseok Shim. Optimization of queries with user-defined predicates. In Proc. 22nd Int. Conf. on Very Large Data Bases VLDB '96, pages 87--98, 1996.

....system of the XQuery core significantly. However, the XQuery core cannot properly type recursive XML queries [2, 10, 11] In this regard, our structural function inlining is a novel technique for typing recursive XML queries. As to optimizing functions, most of existing optimization techniques [6, 7] treat functions simply as externally defined black boxes accompanying some semantic information. Moreover, they consider nonrecursive functions only, and even the XQuery core cannot optimize recursive functions [2, 10, 11] In contrast, the structural function inlining optimizes recursive ....

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. ACM Transactions on Database Systems, 24(2):177-- 228, June 1999.

....Here the cost of the plan includes the join cost and the evaluation costs of all complex operators. The final join plan for our example is shown on the fight hand side of Figure 8. Notice that our algorithm is not exhaustive in terms of possible alternatives for complex operator placement (as is [CS96] for predicates) This is an intentional compromise done to avoid the extra combinatorial explosion of such an exhaustive search. At present, we have not completed the implementation of the cost based query optimizer for the QPC although the major building blocks, such as query plans and search ....

S. Chaudhuri and K. Shim. Optimization of Queries with User-defined Predicates. In Proc. 22nd VLDB Conf., pp. 87 98, Bombay, India, 1996.

....and cost of user defined functions is non trivial, although a reasonable guess may be accomplished by maintaining statistics of previous executions. Some researchers have proposed that the placement of expensive predicates such as UDFs be considered during the join enumeration algorithm [6, 20]. This approach has the e#ect of substantially increasing the cost of enumeration. Hellerstein proposed a predicate migration approach [20] which can lead to cost that is polynomial in the number of UDFs. In the worst case, predicate migration requires exhaustive enumeration of the join space, ....

Surajit Chaudhuri and Kyuseok Shim. Optimization of queries with user-defined predicates. In Proc. Int'l Conf. on VLDB, Mumbai(Bombay), India, 1996.

....and partitioning is beyond the scope of this paper. In the following, we will describe changes to the optimizer s cost model and the plan enumerator. These changes are essentially along the lines of previous work to extend bottom up, dynamic programming query optimizers, e.g. Loh88,CS94,CS96,CK97] Cost Model The cost model extensions are straightforward. We only need to provide cost estimates for all new operators like OHJ, SOHJ, indirect partitioning, and BulkMerge. Similar cost formulae as those needed to estimate the cost of (S)OHJ operators have been devised in [BCK98,BCKK00] ....

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In Proc. of the Conf. on Very Large Data Bases (VLDB), pages 87--98, Bombay, India, September 1996.

....is read (i.e. at which cycle provider and with which scan or wrapper operator) After that, join plans are constructed from these access plans and (later) from simpler join plans. To deal with unary external functions and predicates, the dynamic programming algorithm is extended as described in [8]. In every step, the cost of each plan is estimated and inferior plans are pruned in order to speed up the optimization process. Rather than presenting the full details of the ObjectGlobe optimizer, we would like to highlight the peculiarities that make the ObjectGlobe optimizer special: ....

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In Proc. of the Conf. on Very Large Data Bases (VLDB), pages 87--98, Bombay, India, September 1996.

....is read (i.e. at which cycle provider and with which scan or wrapper operator) After that, join plans are constructed from these access plans and (later) from simpler join plans. To deal with unary external functions and predicates, the dynamic programming algorithm is extended as described in [CS96] In every step, the cost of each plan is estimated and inferior plans are pruned in order to speed up the optimization process. Rather than presenting the full details of the ObjectGlobe optimizer, we would like to highlight the peculiarities that make the ObjectGlobe optimizer special: ....

....standard exception handling mechanism of Java with a little help from our send receive operator pair for crossing network connections. The servers of child operators cannot be informed with the exception mechanism. A 14 Total Lookup Time Avg. Time per Search Optimization Time Scenario I 5. 64 secs 0.47 secs 0.83 secs Scenario II 5.64 secs 0.47 secs 0.07 secs Table 1: Overheads of Plan Generation wrapper execution location time Passau 151 secs Maryland 62 secs Table 2: Query for all Hotels in Philadelphia special (UDP) network protocol is used for this purpose. What we did not mention ....

[Article contains additional citation context not shown here]

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In VLDB [VLD96], pages 87--98.

....about: ffl Kim [Kim82] ffl Ganski Wong [GW87] ffl Dayal [Day87] ffl Magic Sets [MP92, SPL96, SHP 96b] ffl Cluet and Moerkotte [CM95, CM93] ffl Steenhagen [SABd94] 7. 4 Semantic Optimization and Handling Foreign Functions ffl Zdonik [HZ80] ffl Aberer [AF95] ffl Chaudhuri and Kim [CS96, CS93] ffl Conjunctive Predicates [HS93, Hel94, LMS94] ffl Avoiding sorting [SSM96] ffl Semantics and Cost Estimation [NCN97] 7.5 Plan Languages, Partial Evaluation and Dynamic Optimization ffl Exodus Volcano [CDG 90, GM93] ffl OPA [DGK 91, Gra95] ffl Opt [KD] ffl ....

Surajit Chaudhuri and Kyuseok Shim. Optimization of queries with user-defined predicates. In Proceedings of the 22nd VLDB Conference, pages 87--110, Bombay, India, September 1996.

....is read (i.e. at which cycle provider and with which scan or wrapper operator) After that, join plans are constructed from these access plans and (later) from simpler join plans. To deal with unary external functions and predicates, the dynamic programming algorithm is extended as described in [CS96] In every step, the cost of each plan is estimated and inferior plans are pruned in order to speed up the optimization process. Rather than presenting the full details of the ObjectGlobe optimizer, we would like to highlight the peculiarities that make the ObjectGlobe optimizer special: 10 ....

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In Proc. of the Conf. on Very Large Data Bases (VLDB), pages 87--98, Bombay, India, September 1996.

....early sorting and partitioning is beyond the scope of this paper. In the following, we will describe changes to the optimizer s cost model and the plan enumerator. These changes are essentially along the lines of previous work to extend bottom up, dynamicprogramming query optimizers, e.g. [Loh88,CS94, CS96,CK97]. Cost Model The cost model extensions are straightforward. We only need to provide cost estimates for all new operators like OHJ, SOHJ, indirect partitioning, and BulkMerge. Similar cost formulae as those needed to estimate the cost of (S)OHJ operators have been devised in [BCK98, BCKK00] for ....

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In Proc. of the Conf. on Very Large Data Bases (VLDB), pages 87--98, Bombay, India, September 1996.

....Here the cost of the plan includes the join cost and the evaluation costs of all complex operators. The final join plan for our example is shown on the right hand side of Figure 8. Notice that our algorithm is not exhaustive in terms of possible alternatives for complex operator placement (as is [CS96] for predicates) This is an intentional compromise done to avoid the extra combinatorial explosion of such an exhaustive search. At present, we have not completed the implementation of the cost based query optimizer for the QPC although the major building blocks, such as query plans and search ....

S. Chaudhuri and K. Shim. Optimization of Queries with User-defined Predicates. In Proc. 22nd VLDB Conf., pp. 87-- 98, Bombay, India, 1996.

No context found.

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In VLDB'96, Proceedings of 22th International Conference on Very Large Data Bases, September 3-6, 1996.

....is to determine the set of filter conditions that are to be evaluated using GradeSearch. The rest of the conditions will be evaluated by using Probe. In order to efficiently execute the latter step, we will exploit the known techniques in optimizing the processing of expensive filter conditions [25, 22, 23, 26, 11]. In this section, we first define a space of search minimal executions, which access as few attributes as possible using GradeSearch, and sketch the cost model and the optimization criteria. Next, we describe an optimization algorithm and explain the conditions under which it is optimal. ....

....objects in the repository, IOal Sel(a) o. Optimizing Evaluation of Residues: Given a residue (a, f) the task of determining an optimal eval uation for (a, f) maps to the well studied problem of optimizing the execution of selection conditions containing expensive predicates [25] See also [23, 26, 22, 11]. If (a, f) is a conjunction of atomic conditions a A. A a, there is an efficient algorithm w that finds the optimum probing strategy. Specifically, it can be shown [23, 26] that the order in which the atomic conditions for each object should be probed is given by the rank of each condition ....

[Article contains additional citation context not shown here]

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. ACM Transactions on Database Systems, 24(2): 177-228, June 1999.

No context found.

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. ACM Trans. on Database Systems, 24(2):177--228, 1999.

No context found.

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In Proc. Int. Conf. on Very Large Data Bases (VLDB), pages 87--98, 1996.

No context found.

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. Technical report, Microsoft Research, Advanced Technology Division, One Microsoft Way, Redmond, WA 98052, USA, 1997.

No context found.

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In Proc. Int. Conf. on Very Large Data Bases (VLDB), pages 87--98, Bombay, India, 1996.

No context found.

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. ACM Trans. on Database Systems, 24(2):177--228, 1999.

No context found.

S. Chaudhuri and K. Shim. Optimization of Queries with User-defined Predicates. In VLDB, 1996.

No context found.

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In VLDB, pages 87--98, 1996.

No context found.

S. Chaudhuri and K. Shim. Optimization of queries with user-defined predicates. In VLDB, pages 87--98, 1996.

No context found.

Surajit Chaudhuri and Kyuseok Shim. Optimization of queries with user-defined predicates. ACM Transactions on Database Systems (TODS), 24(2):177--228, 1999.

No context found.

Chaudhuri, S., and K. Shim, Optimization of Queries with User-Defined Predicates. Proc. VLDB, 1996, 87-98.

No context found.

S. Chaudhuri and K. Shim. Optimization of Queries with User-defined Predicates. In Proc. of the 22nd VLDB Conference, pp. 87--98, Bombay, 1996.

No context found.

Chaudhuri, S. and Shim, K. "Optimization of Queries with User-defined Predicates" VLDB, 1996.

First 50 documents

Online articles have much greater impact   More about CiteSeer.IST   Add search form to your site   Submit documents   Feedback  

CiteSeer.IST - Copyright Penn State and NEC