专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20100042631A1 METHOD FOR PARTITIONING A QUERY 有权
标题翻译：用于分类查询的方法
公开(公告)号：US20100042631A1
公开(公告)日：2010-02-18
申请号：US12190187
申请日：2008-08-12
申请人： Yefim Shuf , Hong Min , Terence Patrick Purcell , Ou Jin , Fen-Ling Lin , Brian Thinh-Vinh Tran , Patrick Dooling Bossman
发明人： Yefim Shuf , Hong Min , Terence Patrick Purcell , Ou Jin , Fen-Ling Lin , Brian Thinh-Vinh Tran , Patrick Dooling Bossman
IPC分类号： G06F17/30
CPC分类号： G06F17/30445
摘要： Techniques for partitioning a query are provided. The techniques include establishing one or more criterion for partitioning a query, wherein the query comprises one or more tables, materializing a first of the one or more tables, partitioning the first of the one or more tables until the one or more criterion have been satisfied, and partitioning and joining a remainder of the one or more tables of the query.
摘要翻译：提供了分割查询的技术。这些技术包括建立用于划分查询的一个或多个标准，其中该查询包括一个或多个表，实现该一个或多个表中的第一个表，划分一个或多个表中的第一个，直到满足一个或多个标准，以及分割和加入查询的一个或多个表的其余部分。

2. 外观设计

USD603234S1 Ratchet wrench with adjustable working angle 有权
标题翻译：棘轮扳手，工作角度可调
公开(公告)号：USD603234S1
公开(公告)日：2009-11-03
申请号：US29338789
申请日：2009-06-18
申请人： Fen-Ling Lin
设计人： Fen-Ling Lin

3. 发明申请

US20070061288A1 Dynamic semi-join processing with runtime optimization 失效
标题翻译：动态半连接处理与运行时优化
公开(公告)号：US20070061288A1
公开(公告)日：2007-03-15
申请号：US11222886
申请日：2005-09-09
申请人： You-Chin Fuh , Fen-Ling Lin , Andrei Lurie , Terence Purcell , Yoichi Tsuji , Li Xia
发明人： You-Chin Fuh , Fen-Ling Lin , Andrei Lurie , Terence Purcell , Yoichi Tsuji , Li Xia
IPC分类号： G06F17/30
CPC分类号： G06F17/30466 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： 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.
摘要翻译：提供了用于处理包括半连接的查询的技术。在执行时，从半连接中选择下一个半连接，以便在当前一轮的半连接执行中执行。确定报告阈值，其指示要为所确定的半连接检索的记录标识符的数量。执行所选择的半连接，直到检索到确定的记录标识数量。

4. 发明授权

US07124137B2 Method, system, and program for optimizing processing of nested functions 有权
标题翻译：用于优化嵌套函数处理的方法，系统和程序
公开(公告)号：US07124137B2
公开(公告)日：2006-10-17
申请号：US10325781
申请日：2002-12-19
申请人： Fen-Ling Lin , Yao Ching Stephen Chen , Yun Wang , Guogen Zhang , Mengchu Cai , Jason Alexander Cu , Li-Mey Lee
发明人： Fen-Ling Lin , Yao Ching Stephen Chen , Yun Wang , Guogen Zhang , Mengchu Cai , Jason Alexander Cu , Li-Mey Lee
IPC分类号： G06F17/30 , G06F15/177
CPC分类号： G06F17/30917 , Y10S707/99934
摘要： Disclosed is a method, system, and program for processing a function. A set of nested functions are received. A composite function is generated for the set of nested functions. A tagging template is generated for the set of nested functions that corresponds to the composite function. A result is produced by evaluating the composite function using the tagging template.
摘要翻译：公开了一种用于处理功能的方法，系统和程序。接收一组嵌套函数。为嵌套函数集生成一个复合函数。为与复合函数对应的嵌套函数集生成标记模板。通过使用标签模板评估复合函数产生结果。

5. 发明申请

US20050027690A1 Dynamic selection of optimal grouping sequence at runtime for grouping sets, rollup and cube operations in SQL query processing 审中-公开
标题翻译：运行时动态选择最佳分组序列，以便在SQL查询处理中进行分组，汇总和多维数据集操作
公开(公告)号：US20050027690A1
公开(公告)日：2005-02-03
申请号：US10629459
申请日：2003-07-29
申请人： Guogen Zhang , Fen-Ling Lin , Jung-Hsin Hu , Yao-Ching Chen , Yun Wang , Glenn Yuki
发明人： Guogen Zhang , Fen-Ling Lin , Jung-Hsin Hu , Yao-Ching Chen , Yun Wang , Glenn Yuki
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F16/24537
摘要： A method, apparatus, and article of manufacture for optimizing a query in a computer system. During compilation of the query, a GROUP BY clause with one or more GROUPING SETS, ROLLUP or CUBE operations is maintained in its original form until after query rewrite. The GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations is then translated into a plurality of levels having one or more grouping sets. After compilation of the query, a grouping sets sequence is dynamically determined for the GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations based on intermediate grouping sets, in order to optimize the grouping sets sequence. The execution of the grouping sets sequence is optimized by selecting a smallest grouping set from a previous one of the levels as an input to a grouping set on a next one of the levels. Finally, a UNION ALL operation is performed on the grouping sets.
摘要翻译：一种用于优化计算机系统中的查询的方法，装置和制品。在编译查询期间，具有一个或多个GROUPING SETS，ROLLUP或CUBE操作的GROUP BY子句将保持其原始格式，直到查询重写为止。然后将具有GROUPING SETS，ROLLUP或CUBE操作的GROUP BY子句转换为具有一个或多个分组集合的多个级别。在编译查询之后，基于中间分组集合的GROUP BY子句动态确定分组集序列，并使用GROUPING GROUP，ROLLUP或CUBE操作，以优化分组集序列。通过从先前的一个级别中选择最小的分组集作为在下一个级别上的分组集合的输入来优化分组集序列的执行。最后，对分组集执行UNION ALL操作。

6. 发明授权

US06496823B2 Apportioning a work unit to execute in parallel in a heterogeneous environment 有权
标题翻译：分配一个工作单元在异构环境中并行执行
公开(公告)号：US06496823B2
公开(公告)日：2002-12-17
申请号：US09159418
申请日：1998-09-24
申请人： Ted Eric Blank , Tammie Dang , Fen-Ling Lin , Randy Mitchell Nakagawa , Bryan Frederick Smith , Craig Leonard Sutton , Darren Benjamin Swank , Hong Sang Tie , Dino Carlo Tonelli , Annie S. Tsang , Kouhorng Allen Yang , Kathryn Ruth Zeidenstein
发明人： Ted Eric Blank , Tammie Dang , Fen-Ling Lin , Randy Mitchell Nakagawa , Bryan Frederick Smith , Craig Leonard Sutton , Darren Benjamin Swank , Hong Sang Tie , Dino Carlo Tonelli , Annie S. Tsang , Kouhorng Allen Yang , Kathryn Ruth Zeidenstein
IPC分类号： G06F15163
CPC分类号： G06F9/5066 , Y10S707/99932 , Y10S707/99933
摘要： A method, apparatus, and article of manufacture for a computer-implemented apportioning system. Work is distributed to processors in a multi-processor system. Initially, during bind-time, a scaling factor is determined for each processor. The scaling factor represents relative processing power in relation to each other processor. Then, portions of a total amount of work are distributed to each processor based on the determined scaling factor of that processor and a determined amount of work for an average processor.
摘要翻译：一种用于计算机实现的分配系统的方法，装置和制品。工作在多处理器系统中分配给处理器。最初，在绑定时间期间，为每个处理器确定缩放因子。缩放因子表示相对于每个其他处理器的相对处理能力。然后，基于所确定的该处理器的缩放因子和一个平均处理器的确定的工作量，将总工作量的部分分配给每个处理器。

7. 发明授权

US07711730B2 Method of returning data during insert statement processing 有权
标题翻译：插入语句处理期间返回数据的方法
公开(公告)号：US07711730B2
公开(公告)日：2010-05-04
申请号：US10744633
申请日：2003-12-22
申请人： Margaret A. Bernal , Karelle L. Cornwell , Hsuiying Y. Cheng , Yao-Ching S. Chen , Christopher J. Crone , Fen-Ling Lin , James W. Pickel , Yumi K. Tsuji , Julie A. Watts
发明人： Margaret A. Bernal , Karelle L. Cornwell , Hsuiying Y. Cheng , Yao-Ching S. Chen , Christopher J. Crone , Fen-Ling Lin , James W. Pickel , Yumi K. Tsuji , Julie A. Watts
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30595 , G06F17/30463
摘要： A method for generating an execution plan for updating and retrieving data from a database in a single process includes: receiving a statement by a server to update a database with a first set of data and to retrieve a second set of data from the database; building a first execution plan to update the database with the first set of data; building a second execution plan to retrieve the second set of data from the database; and building a single execution plan including a combination of the first and second execution plans. The single execution plan allows for the updating and retrieval of data with a single crossing of an interface between a client and the database. By performing both functions in this manner, the efficiency of performing such tasks on the database is significantly increased.
摘要翻译：一种用于生成用于在单个进程中从数据库更新和检索数据的执行计划的方法包括：由服务器接收用第一组数据更新数据库的语句，并从数据库中检索第二组数据; 构建第一个执行计划，用第一组数据更新数据库; 构建第二个执行计划以从数据库中检索第二组数据; 并构建包括第一和第二执行计划的组合的单个执行计划。单个执行计划允许通过客户端和数据库之间的接口的单个交叉来更新和检索数据。通过以这种方式执行这两个功能，在数据库上执行这样的任务的效率显着增加。

8. 发明申请

US20090094258A1 OFF-LOADING STAR JOIN OPERATIONS TO A STORAGE SERVER 失效
标题翻译：将负载明星加入到存储服务器中
公开(公告)号：US20090094258A1
公开(公告)日：2009-04-09
申请号：US11866907
申请日：2007-10-03
申请人： YING-LIN CHEN , You-Chin Fuh , Wei Han , Fen-Ling Lin , Inderpal Singh Narang , Lin Qiao , Vijayshankar Raman , Kouhorng Allen Yang
发明人： YING-LIN CHEN , You-Chin Fuh , Wei Han , Fen-Ling Lin , Inderpal Singh Narang , Lin Qiao , Vijayshankar Raman , Kouhorng Allen Yang
IPC分类号： G06F7/00
CPC分类号： G06F17/30498
摘要： A method, storage server, and computer readable medium for off-loading star-join operations from a host information processing system to a storage server. At least a first and second set of keys from a first and second dimension table, respectively are received from a host system. Each of the first and second set of keys is associated with at least one fact table. A set of locations associated with a set of foreign key indexes are received from the host system. A set of fact table indexes are traversed. At least a first set of Row Identifiers (“RIDs”) associated with the first set of keys and at least a second set of RIDs associated with the second set of keys are identified. An operation is performed on the first and second sets of RIDs to identify an intersecting set of RIDs. The intersecting set of RIDs are then stored.
摘要翻译：一种用于从主机信息处理系统到存储服务器的卸载星形连接操作的方法，存储服务器和计算机可读介质。分别从主机系统接收来自第一和第二维度表的至少第一和第二组密钥。第一组和第二组中的每一个与至少一个事实表相关联。从主机系统接收与一组外键索引相关联的一组位置。遍历一组事实表索引。识别与第一组密钥相关联的至少第一组行标识符（“RID”）和与第二组密钥相关联的至少第二组RID。对第一和第二组RID执行操作以识别RID的交叉集合。然后存储相交的RID集合。

9. 发明授权

US07437374B2 Efficient XML schema validation of XML fragments using annotated automaton encoding 失效
标题翻译：使用注释自动机编码的XML片段的高效XML模式验证
公开(公告)号：US07437374B2
公开(公告)日：2008-10-14
申请号：US10774594
申请日：2004-02-10
申请人： Yao-Ching Stephen Chen , Fen-Ling Lin , Ning Wang , Guogen Zhang
发明人： Yao-Ching Stephen Chen , Fen-Ling Lin , Ning Wang , Guogen Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/2725 , G06F17/2229 , G06F17/2247 , Y10S707/99942 , Y10S707/99943
摘要： An XML schema is compiled into an annotated automaton encoding, which includes a parsing table for structural information and annotation for type information. The representation is extended to include a mapping from schema types to states in a parsing table. To validate a fragment against a schema type, it is necessary simply to determine the state corresponding to the schema type, and start the validation process from that state. When the process returns to the state, fragment validation has reached successful completion. This approach is more efficient than a general tree representation. Only the data representation of the schema information is handled, making it much easier than manipulating validation parser code generated by a parser generator. In addition, only one representation is needed for schema information for both document and fragment validation. This approach also provides a basis for incremental validation after update.
摘要翻译： XML模式被编译成带注释的自动机编码，其包括用于结构信息的解析表和类型信息的注释。该表示扩展为包括从模式类型到解析表中的状态的映射。要根据模式类型验证片段，只需确定与模式类型相对应的状态，并从该状态启动验证过程。当进程返回到状态时，片段验证已经成功完成。这种方法比一般的树表示效率更高。只处理模式信息的数据表示，使得它比操纵解析器生成器生成的验证解析器代码容易得多。此外，文档和片段验证的模式信息只需要一个表示。这种方法还为更新后的增量验证提供了基础。

10. 发明申请

US20080215534A1 COST-BASED SUBQUERY CORRELATION AND DECORRELATION 有权
标题翻译：基于COST的底层相关和装饰
公开(公告)号：US20080215534A1
公开(公告)日：2008-09-04
申请号：US12104379
申请日：2008-04-16
申请人： Thomas Abel BEAVIN , Mengchu CAI , Yao-Ching Stephen CHEN , Hsiuying Yen CHENG , Fen-Ling LIN , Irene Ching-Hua LIU , Jerry MUKAI , Demai NI , Yoichi TSUJI , Li XIA , Ying ZENG
发明人： Thomas Abel BEAVIN , Mengchu CAI , Yao-Ching Stephen CHEN , Hsiuying Yen CHENG , Fen-Ling LIN , Irene Ching-Hua LIU , Jerry MUKAI , Demai NI , Yoichi TSUJI , Li XIA , Ying ZENG
IPC分类号： G06F7/06
CPC分类号： G06F17/30436 , G06F17/30442 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943
摘要： 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.
摘要翻译：提供了确定查询包括至少一个可以相关或解相关的子查询的技术。生成表示相关和解相关形式的子查询的查询的内部表示，其中内部表示包括至少一个虚拟表。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式