-
公开(公告)号:US08622877B2
公开(公告)日:2014-01-07
申请号:US12511036
申请日:2009-07-28
申请人: Mark T. Raines , Nga Tran Keith , Mai Phuong Tran
发明人: Mark T. Raines , Nga Tran Keith , Mai Phuong Tran
IPC分类号: A63B21/06
CPC分类号: A63B21/0603 , A63B21/06 , A63B21/0602 , A63B23/02 , A63B23/04 , A63B23/12 , A63B2209/02
摘要: 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),所述可收缩入口可从第一位置移动 从所述主体延伸到第二位置,在所述第二位置,所述第二位置延伸到所述内部容积中。
-
公开(公告)号:US20080033914A1
公开(公告)日:2008-02-07
申请号:US11461937
申请日:2006-08-02
申请人: Mitch Cherniack , Shilpa Lawande , Nga Tran
发明人: Mitch Cherniack , Shilpa Lawande , Nga Tran
CPC分类号: G06F17/30466 , G06F17/30457 , G06F17/30592
摘要: 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.
摘要翻译: 对于定义多个单独的雪花模式的数据库查询,查询优化器针对每个雪花模式分别计算逻辑访问计划,以从该模式表获得包括由该查询从这些表请求的数据的相应记录集。 查询优化器还计算用于从记录集获得查询结果的逻辑访问计划,在该记录集中执行由此计算的逻辑访问计划。
-
公开(公告)号:US09864763B2
公开(公告)日:2018-01-09
申请号:US14398249
申请日:2012-06-01
CPC分类号: G06F17/30292 , G06F17/30345 , G06F17/30563 , G06F17/30678
摘要: 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.
-
-
公开(公告)号:US20140113778A1
公开(公告)日:2014-04-24
申请号:US14145269
申请日:2013-12-31
申请人: Mark T. Raines , Nga Tran Keith , Mai Phuong Tran
发明人: Mark T. Raines , Nga Tran Keith , Mai Phuong Tran
IPC分类号: A63B21/06
CPC分类号: A63B21/0603 , A63B21/06 , A63B21/0602 , A63B23/02 , A63B23/04 , A63B23/12 , A63B2209/02
摘要: 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) 从所述主体到第二位置,在所述第二位置,所述第二位置延伸到所述内部容积中。
-
公开(公告)号: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.
摘要翻译: 方法,系统和装置,包括在计算机存储介质上编码的计算机程序,用于模块化查询优化器。 在一个方面,一种方法包括从数据库查询中的每个表的一组投影中选择一个或多个投影,其中所选择的表中的每个选择的投影导致与未被选择的查询相比估计的较低执行成本 预测 基于计算机网络中的站点中的一个或多个所选择的投影的数据分布来生成用于查询的连接订单,其中所述连接顺序反映应用于所述查询的一个或多个联接的输出的数据分发操作的不同组合; 并且基于使用成本模型对连接订单的评估从连接订单中选择连接顺序。
-
公开(公告)号:US20210298399A1
公开(公告)日:2021-09-30
申请号:US16828531
申请日:2020-03-24
申请人: CHARLES S. MCKEE , NGA TRAN KEITH
发明人: CHARLES S. MCKEE , NGA TRAN KEITH
摘要: 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.
-
公开(公告)号:US20150088939A1
公开(公告)日:2015-03-26
申请号:US14398249
申请日:2012-06-01
IPC分类号: G06F17/30
CPC分类号: G06F17/30292 , G06F17/30345 , G06F17/30563 , G06F17/30678
摘要: 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.
摘要翻译: 在一个示例中,来自源位置的数据被合并到包含现有数据的目标位置,其中源位置和目标位置都包含数据元组。 对于源位置中的每个元组,在单个操作期间,确定目标位置中是否存在满足预定条件的匹配元组。 对于满足预定条件的每个匹配的元组,目标位置中的匹配元组被更新为与源位置和目标位置中的匹配元组的计数相等的计数值。 另外,对于不具有满足预定条件的匹配元组的每个元组,将不匹配的元组插入目标位置。
-
公开(公告)号:US08671091B2
公开(公告)日:2014-03-11
申请号:US11461937
申请日:2006-08-02
申请人: Mitch Cherniack , Shilpa Lawande , Nga Tran
发明人: Mitch Cherniack , Shilpa Lawande , Nga Tran
IPC分类号: G06F7/00
CPC分类号: G06F17/30466 , G06F17/30457 , G06F17/30592
摘要: 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.
摘要翻译: 对于定义多个单独的雪花模式的数据库查询,查询优化器针对每个雪花模式分别计算逻辑访问计划,以从该模式表获得包括由该查询从这些表请求的数据的相应记录集。 查询优化器还计算用于从记录集获得查询结果的逻辑访问计划,在该记录集中执行由此计算的逻辑访问计划。
-
公开(公告)号: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.
摘要翻译: 在计算机存储介质上编码的计算机程序提供模块化查询优化器。 在一个方面,计算机程序产品包括从数据库查询中的每个表的一组投影中选择一个或多个投影,其中对于表的每个所选择的投影导致查询的估计较低的执行成本,与非非 选择投影 基于计算机网络中的站点中的一个或多个所选择的投影的数据分布来生成用于查询的连接订单,其中所述连接顺序反映应用于所述查询的一个或多个联接的输出的数据分发操作的不同组合; 并且基于使用成本模型对连接订单的评估从连接订单中选择连接顺序。
-
-
-
-
-
-
-
-
-