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

1. 发明申请

US20070112736A1 Multi-query optimization 有权
标题翻译：多查询优化
公开(公告)号：US20070112736A1
公开(公告)日：2007-05-17
申请号：US11280827
申请日：2005-11-15
申请人： Russell Okamoto , Greg Passmore
发明人： Russell Okamoto , Greg Passmore
IPC分类号： G06F17/30
CPC分类号： G06F17/3046
摘要： A database query optimization method is provided for database queries that include predicates, the queries being directed to at least one database table having data in rows and columns. The method includes associating a lineage bit set with each row of the database table, the lineage bit set providing a binary predicate state indication whether each predicate is met or are not met by data in the row. A dependency bit set is established to provide a binary indication of the predicates that are included in each query. Queries are applied against the database table by a logical operation between the lineage bit set and the dependency bit set. A database query optimization data structure includes a lineage bit set associated with each row in the database table. The lineage bit set provides a binary predicate state indication whether each predicate is met or are not met by data in the row. The data structure further includes a dependency bit set that provides a binary indication of the predicates included in each query.
摘要翻译：为包含谓词的数据库查询提供数据库查询优化方法，查询指向至少一个具有行和列数据的数据库表。该方法包括将谱系位集合与数据库表的每一行相关联，提供二进制谓词状态指示的谱系位集合是否满足或不满足该行中的数据的每个谓词。建立依赖位集合以提供包含在每个查询中的谓词的二进制指示。通过谱系位集和依赖位置位之间的逻辑运算，对数据库表应用查询。数据库查询优化数据结构包括与数据库表中的每一行相关联的谱系位集合。谱系位集提供二进制谓词状态指示，每个谓词是否满足或不满足行中的数据。数据结构还包括依赖性位集合，其提供包括在每个查询中的谓词的二进制指示。

2. 发明申请

US20110225205A1 MULTI-QUERY OPTIMIZATION 有权
标题翻译：多重优化
公开(公告)号：US20110225205A1
公开(公告)日：2011-09-15
申请号：US13110981
申请日：2011-05-19
申请人： Russell OKAMOTO , Greg PASSMORE
发明人： Russell OKAMOTO , Greg PASSMORE
IPC分类号： G06F17/30
CPC分类号： G06F17/3046
摘要： A database query optimization method is provided for database queries that include predicates, the queries being directed to at least one database table having data in rows and columns. The method includes associating a lineage bit set with each row of the database table, the lineage bit set providing a binary predicate state indication whether each predicate is met or are not met by data in the row. A dependency bit set is established to provide a binary indication of the predicates that are included in each query. Queries are applied against the database table by a logical operation between the lineage bit set and the dependency bit set. A database query optimization data structure includes a lineage bit set associated with each row in the database table. The lineage bit set provides a binary predicate state indication whether each predicate is met or are not met by data in the row. The data structure further includes a dependency bit set that provides a binary indication of the predicates included in each query.
摘要翻译：为包含谓词的数据库查询提供数据库查询优化方法，查询指向至少一个具有行和列数据的数据库表。该方法包括将谱系位集合与数据库表的每一行相关联，提供二进制谓词状态指示的谱系位集合是否满足或不满足该行中的数据的每个谓词。建立依赖位集合以提供包含在每个查询中的谓词的二进制指示。通过谱系位集和依赖位置位之间的逻辑运算，对数据库表应用查询。数据库查询优化数据结构包括与数据库表中的每一行相关联的谱系位集合。谱系位集提供二进制谓词状态指示，每个谓词是否满足或不满足行中的数据。数据结构还包括依赖性位集合，其提供包括在每个查询中的谓词的二进制指示。

3. 发明授权

US08626745B2 Multi-query optimization 有权
标题翻译：多查询优化
公开(公告)号：US08626745B2
公开(公告)日：2014-01-07
申请号：US13110981
申请日：2011-05-19
申请人： Russell Okamoto , Greg Passmore
发明人： Russell Okamoto , Greg Passmore
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/3046
摘要： A database query optimization method is provided for database queries that include predicates, the queries being directed to at least one database table having data in rows and columns. The method includes associating a lineage bit set with each row of the database table, the lineage bit set providing a binary predicate state indication whether each predicate is met or are not met by data in the row. A dependency bit set is established to provide a binary indication of the predicates that are included in each query. Queries are applied against the database table by a logical operation between the lineage bit set and the dependency bit set. A database query optimization data structure includes a lineage bit set associated with each row in the database table. The lineage bit set provides a binary predicate state indication whether each predicate is met or are not met by data in the row. The data structure further includes a dependency bit set that provides a binary indication of the predicates included in each query.
摘要翻译：为包含谓词的数据库查询提供数据库查询优化方法，查询指向至少一个具有行和列数据的数据库表。该方法包括将谱系位集合与数据库表的每一行相关联，提供二进制谓词状态指示的谱系位集合是否满足或不满足该行中的数据的每个谓词。建立依赖位集合以提供包含在每个查询中的谓词的二进制指示。通过谱系位集和依赖位置位之间的逻辑运算，对数据库表应用查询。数据库查询优化数据结构包括与数据库表中的每一行相关联的谱系位集合。谱系位集提供二进制谓词状态指示，每个谓词是否满足或不满足行中的数据。数据结构还包括依赖性位集合，其提供包括在每个查询中的谓词的二进制指示。

4. 发明授权

US07966315B2 Multi-query optimization 有权
标题翻译：多查询优化
公开(公告)号：US07966315B2
公开(公告)日：2011-06-21
申请号：US11280827
申请日：2005-11-15
申请人： Russell Okamoto , Greg Passmore
发明人： Russell Okamoto , Greg Passmore
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/3046
摘要： A database query optimization method is provided for database queries that include predicates, the queries being directed to at least one database table having data in rows and columns. The method includes associating a lineage bit set with each row of the database table, the lineage bit set providing a binary predicate state indication whether each predicate is met or are not met by data in the row. A dependency bit set is established to provide a binary indication of the predicates that are included in each query. Queries are applied against the database table by a logical operation between the lineage bit set and the dependency bit set. A database query optimization data structure includes a lineage bit set associated with each row in the database table. The lineage bit set provides a binary predicate state indication whether each predicate is met or are not met by data in the row. The data structure further includes a dependency bit set that provides a binary indication of the predicates included in each query.
摘要翻译：为包含谓词的数据库查询提供数据库查询优化方法，查询指向至少一个具有行和列数据的数据库表。该方法包括将谱系位集合与数据库表的每一行相关联，提供二进制谓词状态指示的谱系位集合是否满足或不满足该行中的数据的每个谓词。建立依赖位集合以提供包含在每个查询中的谓词的二进制指示。通过谱系位集和依赖位置位之间的逻辑运算，对数据库表应用查询。数据库查询优化数据结构包括与数据库表中的每一行相关联的谱系位集合。谱系位集提供二进制谓词状态指示，每个谓词是否满足或不满足行中的数据。数据结构还包括依赖性位集合，其提供包括在每个查询中的谓词的二进制指示。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式