Selection of optimal plans for FIRST-N-ROW queries
    4.
    发明申请
    Selection of optimal plans for FIRST-N-ROW queries 审中-公开
    选择FIRST-N-ROW查询的最优计划

    公开(公告)号:US20060167845A1

    公开(公告)日:2006-07-27

    申请号:US11042525

    申请日:2005-01-25

    IPC分类号: G06F17/30

    CPC分类号: G06F16/24542

    摘要: 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.

    摘要翻译: 一种用于优化计算机系统中的查询的方法,装置和制品,其中所述查询由所述计算机系统执行以从存储在所述计算机系统上的数据库中检索数据。 优化包括通过评估获取N行的成本相对于最终结果集中的总行数R来确定用于第一N行查询的最优访问计划。 具体来说,对于流水线访问计划,这包括计算在流水线计划中从每个表中获取多少行,以便从最终结果集中获取前N行。

    Belt-drive continuously variable transmission
    5.
    发明授权
    Belt-drive continuously variable transmission 有权
    皮带驱动无级变速器

    公开(公告)号:US09222579B2

    公开(公告)日:2015-12-29

    申请号:US13414088

    申请日:2012-03-07

    申请人: Yoichi Tsuji

    发明人: Yoichi Tsuji

    摘要: 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.

    摘要翻译: 一种带式无级变速器,其包括用于将最初传动比位置中的主带轮的主可动绳轮锁定的锁定机构。 所述锁定机构包括在主固定轮轮轴的外周面上延伸的固定侧轴向槽,在主动轮胎轮套的内周面上延伸的可动侧轴向槽,设置在所述轴向槽之间的中间构件, 轴向锥形槽,其形成为对应于最高传动比设置的至少一个轴向槽的一部分,以及中间构件位移限制构件,其布置成限制中间构件相对于初级固定轮轮轴的位移量 沿着固定侧轴向槽或可动侧轴向槽。

    BELT-DRIVE CONTINUOUSLY VARIABLE TRANSMISSION
    6.
    发明申请
    BELT-DRIVE CONTINUOUSLY VARIABLE TRANSMISSION 有权
    皮带驱动连续可变传动

    公开(公告)号:US20120244974A1

    公开(公告)日:2012-09-27

    申请号:US13414088

    申请日:2012-03-07

    申请人: Yoichi TSUJI

    发明人: Yoichi TSUJI

    IPC分类号: F16H9/18

    摘要: 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.

    摘要翻译: 一种带式无级变速器,其包括用于将最初传动比位置中的主带轮的主可动绳轮锁定的锁定机构。 所述锁定机构包括在主固定轮轮轴的外周面上延伸的固定侧轴向槽,在主动轮胎轮套的内周面上延伸的可动侧轴向槽,设置在所述轴向槽之间的中间构件, 轴向锥形槽,其形成为对应于最高传动比设置的至少一个轴向槽的一部分,以及中间构件位移限制构件,其布置成限制中间构件相对于初级固定轮轮轴的位移量 沿着固定侧轴向槽或可动侧轴向槽。