摘要:
Techniques are provided that determine that a query includes at least one subquery that may be correlated or decorrelated. An internal representation of the query that represents the subquery in both correlated and decorrelated form is generated, wherein the internal representation includes at least one virtual table.
摘要:
Provided are a techniques for processing a query including semi-joins. At execution time, a next semi-join is selected from the semi-joins for execution in a current round of semi-join executions. A reporting threshold is determined that indicates a number of record-identifiers to be retrieved for the determined semi-join. The selected semi-join is executed until the determined number of record identifiers are retrieved.
摘要:
In various embodiments, a method, apparatus, and article of manufacture collect statistics in a database management system. A workload comprising a plurality of database queries is received. Query statistics for the database queries are identified. The query statistics for the database queries are consolidated to provide consolidated statistics. One or more statistics collection requests are generated based on the consolidated statistics.
摘要:
A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization comprises determining an optimal access plan for a first-N-rows query by evaluating a cost of fetching N rows, relative to a total number of rows R in a final results set. Specifically, for a pipelined access plan, this comprises calculating how many rows need to be fetched from each table in the pipelined plan in order to obtain the first N rows from the final results set.
摘要:
A belt-drive continuously variable transmission including a lock mechanism for locking a primary moveable sheave of a primary pulley in a highest transmission ratio position. The lock mechanism includes a fixed side axial groove extending on an outer circumferential surface of a primary fixed sheave shaft, a moveable side axial groove extending on an inner circumferential surface of a primary moveable sheave sleeve, an intervening member disposed between the axial grooves, an axial tapered groove formed as a part of at least one of the axial grooves which is disposed corresponding to a highest transmission ratio, and an intervening member displacement limiting member arranged to limit an amount of displacement of the intervening member relative to the primary fixed sheave shaft along the fixed side axial groove or the moveable side axial groove.
摘要:
A belt-drive continuously variable transmission including a lock mechanism for locking a primary moveable sheave of a primary pulley in a highest transmission ratio position. The lock mechanism includes a fixed side axial groove extending on an outer circumferential surface of a primary fixed sheave shaft, a moveable side axial groove extending on an inner circumferential surface of a primary moveable sheave sleeve, an intervening member disposed between the axial grooves, an axial tapered groove formed as a part of at least one of the axial grooves which is disposed corresponding to a highest transmission ratio, and an intervening member displacement limiting member arranged to limit an amount of displacement of the intervening member relative to the primary fixed sheave shaft along the fixed side axial groove or the moveable side axial groove.
摘要:
Techniques are provided that determine that a query includes at least one subquery that may be correlated or decorrelated. An internal representation of the query that represents the subquery in both correlated and decorrelated form is generated, wherein the internal representation includes at least one virtual table.
摘要:
In various embodiments, a method, apparatus, and article of manufacture collect statistics in a database management system. A workload comprising a plurality of database queries is received. Query statistics for the database queries are identified. The query statistics for the database queries are consolidated to provide consolidated statistics. One or more statistics collection requests are generated based on the consolidated statistics.
摘要:
Techniques are provided that determine that a query includes at least one subquery that may be correlated or decorrelated. An internal representation of the query that represents the subquery in both correlated and decorrelated form is generated, wherein the internal representation includes at least one virtual table.
摘要:
A piezoelectric ceramic composition and a piezoelectric element in which cracks and chips are not likely to occur during working even if the thicknesses are reduced, are provided. The piezoelectric ceramic composition contains as a primary component, a complex oxide having a perovskite structure, composed of at least Pb, Zr, Ti, Mn, Nb and O, and represented by general formula ABO3, in which the total molar quantity of elements constituting A is smaller than the total molar quantity of elements constituting B, and Si is present as a secondary component at the content of about 0.010 wt % to 0.090 wt %, in terms of SiO2, relative to the primary component.