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

1. 发明申请

US20060287979A1 Cost-based subquery correlation and decorrelation 失效
标题翻译：基于成本的子查询相关和去相关
公开(公告)号：US20060287979A1
公开(公告)日：2006-12-21
申请号：US11156500
申请日：2005-06-17
申请人： Thomas Beavin , Mengchu Cai , Yao-Ching Chen , Hsiuying Cheng , Fen-Ling Lin , Irene Liu , Jerry Mukai , Demai Ni , Yoichi Tsuji , Li Xia , Ying Zeng
发明人： Thomas Beavin , Mengchu Cai , Yao-Ching Chen , Hsiuying Cheng , Fen-Ling Lin , Irene Liu , Jerry Mukai , Demai Ni , Yoichi Tsuji , Li Xia , Ying Zeng
IPC分类号： G06F17/30
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.
摘要翻译：提供了确定查询包括至少一个可以相关或解相关的子查询的技术。生成表示相关和解相关形式的子查询的查询的内部表示，其中内部表示包括至少一个虚拟表。

2. 发明授权

US07840552B2 Cost-based subquery correlation and decorrelation 有权
标题翻译：基于成本的子查询相关和去相关
公开(公告)号：US07840552B2
公开(公告)日：2010-11-23
申请号：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分类号： G06F17/30
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.
摘要翻译：提供了确定查询包括至少一个可以相关或解相关的子查询的技术。生成表示相关和解相关形式的子查询的查询的内部表示，其中内部表示包括至少一个虚拟表。

3. 发明授权

US07376646B2 Cost-based subquery correlation and decorrelation 失效
标题翻译：基于成本的子查询相关和去相关
公开(公告)号：US07376646B2
公开(公告)日：2008-05-20
申请号：US11156500
申请日：2005-06-17
申请人： 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分类号： G06F17/30
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.
摘要翻译：提供了确定查询包括至少一个可以相关或解相关的子查询的技术。生成表示相关和解相关形式的子查询的查询的内部表示，其中内部表示包括至少一个虚拟表。

4. 发明授权

US07657570B2 Optimizing aggregate processing 失效
标题翻译：优化聚合处理
公开(公告)号：US07657570B2
公开(公告)日：2010-02-02
申请号：US11738406
申请日：2007-04-20
申请人： Yun Wang , Fen-Ling Lin , Yao-Ching Chen , Mengchu Cai , Jason Alexander Cu , Allan Benjamin Lebovitz , Li-Mey Lee , Guogen Zhang
发明人： Yun Wang , Fen-Ling Lin , Yao-Ching Chen , Mengchu Cai , Jason Alexander Cu , Allan Benjamin Lebovitz , Li-Mey Lee , Guogen Zhang
IPC分类号： G06F17/00
CPC分类号： G06F17/30286 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99948
摘要： Disclosed is method for processing an aggregate function. Rows that contain a reference to intermediate result structures are grouped to form groups. For each group, aggregate element structures are formed from the intermediate result structures and, if the aggregate function specifies ordering, the aggregate element structures are sorted based on a sort key.
摘要翻译：公开了一种处理聚合函数的方法。包含对中间结果结构的引用的行被分组以形成组。对于每个组，从中间结果结构形成聚合元素结构，并且如果聚合函数指定排序，则基于排序关键字对聚合元素结构进行排序。

5. 发明授权

US07243098B2 Method, system, and program for optimizing aggregate processing 失效
标题翻译：用于优化聚合处理的方法，系统和程序
公开(公告)号：US07243098B2
公开(公告)日：2007-07-10
申请号：US10325854
申请日：2002-12-19
申请人： Yun Wang , Fen-Ling Lin , Yao Ching Stephen Chen , Mengchu Cai , Jason Alexander Cu , Allan Benjamin Lebovitz , Li-Mey Lee , Guogen Zhang
发明人： Yun Wang , Fen-Ling Lin , Yao Ching Stephen Chen , Mengchu Cai , Jason Alexander Cu , Allan Benjamin Lebovitz , Li-Mey Lee , Guogen Zhang
IPC分类号： G06F17/30 , G06F15/16
CPC分类号： G06F17/30286 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99948
摘要： Disclosed is a method, system, and program for processing an aggregate function. Rows that contain a reference to intermediate result structures are grouped to form groups. For each group, aggregate element structures are formed from the intermediate result structures and, if the aggregate function specifies ordering, the aggregate element structures are sorted based on a sort key.
摘要翻译：公开了一种用于处理聚合函数的方法，系统和程序。包含对中间结果结构的引用的行被分组以形成组。对于每个组，从中间结果结构形成聚合元素结构，并且如果聚合函数指定排序，则基于排序关键字对聚合元素结构进行排序。

6. 发明授权

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.
摘要翻译：公开了一种用于处理功能的方法，系统和程序。接收一组嵌套函数。为嵌套函数集生成一个复合函数。为与复合函数对应的嵌套函数集生成标记模板。通过使用标签模板评估复合函数产生结果。

7. 发明申请

US20070198479A1 Streaming XPath algorithm for XPath expressions with predicates 审中-公开
标题翻译：具有谓词的XPath表达式的流式XPath算法
公开(公告)号：US20070198479A1
公开(公告)日：2007-08-23
申请号：US11356366
申请日：2006-02-16
申请人： Mengchu Cai , Jason Cu , Fen-Ling Lin , Guogen Zhang , Qinghua Zou
发明人： Mengchu Cai , Jason Cu , Fen-Ling Lin , Guogen Zhang , Qinghua Zou
IPC分类号： G06F17/30
CPC分类号： G06F16/8373
摘要： A method and system for evaluating a path query are disclosed. The path query corresponds to a query tree including a plurality of query nodes. At least one query node corresponds to at least one predicate and is at a level. The predicate(s) are evaluated for previous query node(s). The method and system include scanning data nodes of a document and determining if the data nodes match the query nodes. The method and system also include placing data related to the data node in match stacks corresponding to matched query nodes. The data for the query node(s) include attribute(s) corresponding to the predicate(s). The method and system further include propagating a matching of the at least one query node backward to a matching of the at least one previous query node.
摘要翻译：公开了一种用于评估路径查询的方法和系统。路径查询对应于包括多个查询节点的查询树。至少一个查询节点对应于至少一个谓词并处于一个级别。对先前的查询节点评估谓词。该方法和系统包括扫描文档的数据节点并确定数据节点是否匹配查询节点。该方法和系统还包括将与数据节点相关的数据放置在与匹配查询节点相对应的匹配堆栈中。查询节点的数据包括对应于谓词的属性。所述方法和系统还包括将所述至少一个查询节点的匹配向后传播到所述至少一个先前查询节点的匹配。

8. 发明申请

US20130013617A1 INDEXING TIMESTAMP WITH TIME ZONE VALUE 有权
标题翻译：用时区索引TIMESTAMP
公开(公告)号：US20130013617A1
公开(公告)日：2013-01-10
申请号：US13177606
申请日：2011-07-07
申请人： Mengchu Cai , Stephen Yao Ching Chen , Ruiping Li , Wei Li , Robert W. Lyle
发明人： Mengchu Cai , Stephen Yao Ching Chen , Ruiping Li , Wei Li , Robert W. Lyle
IPC分类号： G06F17/30
CPC分类号： G06F17/30336
摘要： Techniques are described for processing a query to produce query results, the query specifying at least a first timestamp value. Embodiments receive the query for processing and access a database index containing a plurality of database keys. The database index contains one or more database index keys, each of which includes at least a timestamp value and a time zone value. Embodiments compare the first timestamp value specified in the query with a portion of one the database index keys to locate at least a portion of the query results. More specifically, the compared portion of the database index key excludes the time zone value. The located portion of the query results is then retrieved.
摘要翻译：描述了用于处理查询以产生查询结果的技术，所述查询指定至少第一时间戳值。实施例接收用于处理和访问包含多个数据库密钥的数据库索引的查询。数据库索引包含一个或多个数据库索引关键字，每个索引关键字至少包含时间戳值和时区值。实施例将查询中指定的第一个时间戳值与数据库索引键的一部分进行比较，以查找查询结果的至少一部分。更具体地，数据库索引关键字的比较部分排除时区值。然后检索查询结果的位置部分。

9. 发明申请

US20120078942A1 Supporting efficient partial update of hierarchically structured documents based on record storage 有权
标题翻译：支持基于记录存储的分层结构化文档的有效部分更新
公开(公告)号：US20120078942A1
公开(公告)日：2012-03-29
申请号：US12891146
申请日：2010-09-27
申请人： Mengchu Cai , Yu Chen , Eric Naoto Katayama
发明人： Mengchu Cai , Yu Chen , Eric Naoto Katayama
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , G06F17/30929
摘要： Methods and apparatus, including computer program products, implementing and using techniques for performing a partial update of a hierarchically structured document referencing one or more records stored in a database. An expression specifying one or more updates to be applied to the document is received. The document is searched to find update target position(s). Based on the received expression, a pending update list is built. When an update target position is found, a row of a document column in a base table is updated with the new version number for the document. New database records for insertion into the new document version are generated from the pending update list. Old database records to be replaced are identified. A database table for the document is updated to mark the old database records as obsolete and to add new database records to be referenced in the new version of the document.
摘要翻译：方法和装置，包括计算机程序产品，实现和使用技术，用于执行参考存储在数据库中的一个或多个记录的分层结构化文档的部分更新。接收指定要应用于文档的一个或多个更新的表达式。搜索文档以查找更新目标位置。根据收到的表达式，构建一个挂起的更新列表。当找到更新目标位置时，基本表中的文档列的行用文档的新版本号更新。从挂起的更新列表中生成用于插入新文档版本的新数据库记录。识别要替换的旧数据库记录。更新文档的数据库表以将旧数据库记录标记为过时，并添加要在新版本的文档中引用的新数据库记录。

10. 发明授权

US08972377B2 Efficient method of using XML value indexes without exact path information to filter XML documents for more specific XPath queries 有权
标题翻译：使用XML值索引的高效方法，而不需要确切的路径信息来过滤XML文档以获取更多特定的XPath查询
公开(公告)号：US08972377B2
公开(公告)日：2015-03-03
申请号：US11923652
申请日：2007-10-25
申请人： Guogen Zhang , Ruiping Li , Mengchu Cai
发明人： Guogen Zhang , Ruiping Li , Mengchu Cai
IPC分类号： G06F17/30
CPC分类号： G06F17/30911 , G06F17/30938
摘要： A system and method is provided for query processing comprises: creating an index of a database and ordering a set of index candidates from the index into a list based on a set of heuristic rules. A query defining a query path is then reduced into a list of single path expressions. Each index candidate is matched against the list of single path expressions according to the ordering of the index candidates. The matched candidate nodes are also verified to insure that they satisfy the query path.
摘要翻译：提供了一种用于查询处理的系统和方法，包括：创建数据库的索引并且基于一组启发式规则将索引候选的索引从索引排序到列表中。然后将定义查询路径的查询简化为单路径表达式列表。每个索引候选者根据索引候选者的顺序与单个路径表达式的列表进行匹配。还验证匹配的候选节点以确保它们满足查询路径。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式