Weighted article with fill spout
    1.
    发明授权
    Weighted article with fill spout 有权
    带填充口的加权物品

    公开(公告)号:US08622877B2

    公开(公告)日:2014-01-07

    申请号:US12511036

    申请日:2009-07-28

    IPC分类号: A63B21/06

    摘要: An article (101) is provided which may include a body (103) having an interior volume (113), and a collapsible inlet (105) which is in open communication with said interior volume and which is movable from a first position in which it extends from said body, to a second position in which it extends into said internal volume.

    摘要翻译: 提供了一种物品(101),其可以包括具有内部容积(113)的本体(103)和与所述内部容积开放连通的可折叠入口(105),所述可收缩入口可从第一位置移动 从所述主体延伸到第二位置,在所述第二位置,所述第二位置延伸到所述内部容积中。

    Query Optimizer
    2.
    发明申请
    Query Optimizer 有权
    查询优化器

    公开(公告)号:US20080033914A1

    公开(公告)日:2008-02-07

    申请号:US11461937

    申请日:2006-08-02

    IPC分类号: G06F7/00 G06F17/30

    摘要: For a database query that defines a plurality of separate snowflake schemas, a query optimizer computes separately for each of the snowflake schemas a logical access plan for obtaining from that schema's tables a respective record set that includes the data requested from those tables by that query. The query optimizer also computes a logical access plan for obtaining the query's results from the record sets in which execution of the logical access plans thus computed will result.

    摘要翻译: 对于定义多个单独的雪花模式的数据库查询,查询优化器针对每个雪花模式分别计算逻辑访问计划,以从该模式表获得包括由该查询从这些表请求的数据的相应记录集。 查询优化器还计算用于从记录集获得查询结果的逻辑访问计划,在该记录集中执行由此计算的逻辑访问计划。

    WEIGHTED ARTICLE WITH FILL SPOUT
    5.
    发明申请
    WEIGHTED ARTICLE WITH FILL SPOUT 审中-公开
    带有FILL SPOUT的加权文章

    公开(公告)号:US20140113778A1

    公开(公告)日:2014-04-24

    申请号:US14145269

    申请日:2013-12-31

    IPC分类号: A63B21/06

    摘要: An article (101) is provided which comprises a body (103) having an interior volume (113), and a collapsible inlet (105) which is in open communication with said interior volume and which is movable from a first position in which it extends from said body, to a second position in which it extends into said internal volume.

    摘要翻译: 提供了一种物品(101),其包括具有内部容积(113)的主体(103)和与所述内部容积敞开连通且可从其延伸的第一位置的可折叠入口(105) 从所述主体到第二位置,在所述第二位置,所述第二位置延伸到所述内部容积中。

    Modular query optimizer
    6.
    发明授权
    Modular query optimizer 有权
    模块化查询优化器

    公开(公告)号:US08214352B2

    公开(公告)日:2012-07-03

    申请号:US12625482

    申请日:2009-11-24

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30424 G06F17/30463

    摘要: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for modular query optimizer. In one aspect, a method includes selecting one or more projections from a set of projections for each table in a database query wherein each of the selected projections for the table has leads to an estimated lower execution cost for the query as compared to non-selected projections; generating join orders for the query based on data distribution of one or more of the selected projections among sites in a computer network wherein the join orders reflect different combinations of data distribution operations applied to the output of one or more of the query's joins; and selecting a join order from the join orders based on evaluation of the join orders using a cost model.

    摘要翻译: 方法,系统和装置,包括在计算机存储介质上编码的计算机程序,用于模块化查询优化器。 在一个方面,一种方法包括从数据库查询中的每个表的一组投影中选择一个或多个投影,其中所选择的表中的每个选择的投影导致与未被选择的查询相比估计的较低执行成本 预测 基于计算机网络中的站点中的一个或多个所选择的投影的数据分布来生成用于查询的连接订单,其中所述连接顺序反映应用于所述查询的一个或多个联接的输出的数据分发操作的不同组合; 并且基于使用成本模型对连接订单的评估从连接订单中选择连接顺序。

    MAGNETIC STRAP ASSEMBLY AND METHOD

    公开(公告)号:US20210298399A1

    公开(公告)日:2021-09-30

    申请号:US16828531

    申请日:2020-03-24

    IPC分类号: A41F1/00 A44B1/18

    摘要: A magnetic strap assembly includes a ribbon member having a first surface and a second surface. An adhesive member having a first surface and a second surface is coupled to the ribbon member along the first surfaces. A magnet is coupled to the second surface of the ribbon member and the second surface of the adhesive member includes an adhesive to couple it to an external object, such as clothing or a type of fabric. The strap assembly is premanufactured and used by an installer in desired cut lengths to install on clothing for example to facilitate closing openings and enabling those with hand operation deficiencies the ability to dress themselves without struggling with mainstream fasteners.

    MERGING DATA FROM A SOURCE LOCATION INTO A TARGET LOCATION
    8.
    发明申请
    MERGING DATA FROM A SOURCE LOCATION INTO A TARGET LOCATION 有权
    将数据从源位置合并到目标位置

    公开(公告)号:US20150088939A1

    公开(公告)日:2015-03-26

    申请号:US14398249

    申请日:2012-06-01

    IPC分类号: G06F17/30

    摘要: In an example, data from a source location is merged into a target location containing existing data, in which both the source location and the target location contain tuples of data. For each tuple in the source location, during a single operation, a determination is made as to whether there is a matched tuple in the target location that satisfies a predetermined condition. For each matched tuple that satisfies the predetermined condition, the matched tuple in the target location is updated with a count value that is equal to a count of the matched tuple in the source location and the target location. In addition, for each tuple that does not have a matched tuple that satisfies the predetermined condition, the unmatched tuple is inserted into the target location.

    摘要翻译: 在一个示例中,来自源位置的数据被合并到包含现有数据的目标位置,其中源位置和目标位置都包含数据元组。 对于源位置中的每个元组,在单个操作期间,确定目标位置中是否存在满足预定条件的匹配元组。 对于满足预定条件的每个匹配的元组,目标位置中的匹配元组被更新为与源位置和目标位置中的匹配元组的计数相等的计数值。 另外,对于不具有满足预定条件的匹配元组的每个元组,将不匹配的元组插入目标位置。

    Optimizing snowflake schema queries
    9.
    发明授权
    Optimizing snowflake schema queries 有权
    优化雪花模式查询

    公开(公告)号:US08671091B2

    公开(公告)日:2014-03-11

    申请号:US11461937

    申请日:2006-08-02

    IPC分类号: G06F7/00

    摘要: For a database query that defines a plurality of separate snowflake schemas, a query optimizer computes separately for each of the snowflake schemas a logical access plan for obtaining from that schema's tables a respective record set that includes the data requested from those tables by that query. The query optimizer also computes a logical access plan for obtaining the query's results from the record sets in which execution of the logical access plans thus computed will result.

    摘要翻译: 对于定义多个单独的雪花模式的数据库查询,查询优化器针对每个雪花模式分别计算逻辑访问计划,以从该模式表获得包括由该查询从这些表请求的数据的相应记录集。 查询优化器还计算用于从记录集获得查询结果的逻辑访问计划,在该记录集中执行由此计算的逻辑访问计划。

    Modular query optimizer
    10.
    发明授权
    Modular query optimizer 有权
    模块化查询优化器

    公开(公告)号:US08312027B2

    公开(公告)日:2012-11-13

    申请号:US13489094

    申请日:2012-06-05

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30424 G06F17/30463

    摘要: Computer programs encoded on a computer storage medium provide for a modular query optimizer. In one aspect, a computer program product includes selecting one or more projections from a set of projections for each table in a database query wherein each of the selected projections for the table has leads to an estimated lower execution cost for the query as compared to non-selected projections; generating join orders for the query based on data distribution of one or more of the selected projections among sites in a computer network wherein the join orders reflect different combinations of data distribution operations applied to the output of one or more of the query's joins; and selecting a join order from the join orders based on evaluation of the join orders using a cost model.

    摘要翻译: 在计算机存储介质上编码的计算机程序提供模块化查询优化器。 在一个方面,计算机程序产品包括从数据库查询中的每个表的一组投影中选择一个或多个投影,其中对于表的每个所选择的投影导致查询的估计较低的执行成本,与非非 选择投影 基于计算机网络中的站点中的一个或多个所选择的投影的数据分布来生成用于查询的连接订单,其中所述连接顺序反映应用于所述查询的一个或多个联接的输出的数据分发操作的不同组合; 并且基于使用成本模型对连接订单的评估从连接订单中选择连接顺序。