利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

10 条记录 (耗时 0.043 秒)

    Optimized constraint and index maintenance for non updating updates
    2.
    发明授权
    Optimized constraint and index maintenance for non updating updates 有权
    非更新更新的优化约束和索引维护

    公开(公告)号：US07801882B2

    公开(公告)日：2010-09-21

    申请号：US10957409

    申请日：2004-10-01

    申请人： Conor J. Cunningham ,  Stefano Stefani

    发明人： Conor J. Cunningham ,  Stefano Stefani

    IPC分类号： G06F7/00 ,  G06F17/30

    CPC分类号： G06F17/30315

    摘要： Database management systems allow modification of existing table rows through update statements or other data modification commands. For example, a user may specify, via a command statement, the table to update, the columns to modify and their respective new value(s), and qualify the rows to be updated. Optimized constraint and index maintenance for data modification statements and commands is provided where the new value being assigned to the columns is actually the same as the current value, e.g., update commands that actually leave the columns unchanged.

    摘要翻译： 数据库管理系统允许通过更新语句或其他数据修改命令修改现有的表行。 例如，用户可以通过命令语句指定要更新的表，要修改的列及其各自的新值，并限定要更新的行。 提供了数据修改语句和命令的优化约束和索引维护，其中分配给列的新值实际上与当前值相同，例如，实际上使列保持不变的更新命令。

    Optimization of performing query compilations
    3.
    发明授权
    Optimization of performing query compilations 失效
    优化执行查询编译

    公开(公告)号：US07739268B2

    公开(公告)日：2010-06-15

    申请号：US11392267

    申请日：2006-03-29

    申请人： Conor J. Cunningham ,  Stanislav A. Oks ,  Stefano Stefani

    发明人： Conor J. Cunningham ,  Stanislav A. Oks ,  Stefano Stefani

    IPC分类号： G06F7/00 ,  G06F17/30 ,  G06F13/00 ,  G06F13/28

    CPC分类号： G06F17/30442

    摘要： Implementations of various technologies for compiling a query. In one implementation, the memory consumption of the query may be monitored. If the amount of memory consumed by the query exceeds one or more gateway thresholds, then the query may be processed to acquire one or more gateways. The query may then be compiled as having acquired the one or more gateways.

    摘要翻译： 用于编译查询的各种技术的实现。 在一个实现中，可以监视查询的内存消耗。 如果查询消耗的内存量超过一个或多个网关阈值，则可以处理查询以获取一个或多个网关。 然后可以将查询编译为已经获取了一个或多个网关。

    Type path indexing
    5.
    发明授权
    Type path indexing 有权
    键入路径索引

    公开(公告)号：US07516143B2

    公开(公告)日：2009-04-07

    申请号：US11244021

    申请日：2005-10-05

    申请人： Conor J. Cunningham ,  Ramachandran Venkatesh ,  Eric N. Hanson

    发明人： Conor J. Cunningham ,  Ramachandran Venkatesh ,  Eric N. Hanson

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30327 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99936 ,  Y10S707/99937 ,  Y10S707/99942 ,  Y10S707/99944

    摘要： Efficient hierarchical searching is based on object type. By pre-computing additional information and storing it in a fast-lookup structure, it is possible to quickly identify objects that satisfy an object retrieval request. Furthermore, it is also possible to use this technique to avoid object hydration for operations in the store. Moreover, it is possible to leverage database statistical structures such as histograms to estimate the number of qualifying objects without having to examine each object.

    摘要翻译： 高效的层次搜索是基于对象类型的。 通过预先计算附加信息并将其存储在快速查找结构中，可以快速识别满足对象检索请求的对象。 此外，也可以使用该技术来避免商店中的操作的物体水合。 此外，可以利用诸如直方图的数据库统计结构来估计限定对象的数量而不必检查每个对象。

    Type path indexing
    6.
    发明授权
    Type path indexing 有权
    键入路径索引

    公开(公告)号：US07379927B2

    公开(公告)日：2008-05-27

    申请号：US11244018

    申请日：2005-10-05

    申请人： Conor J. Cunningham ,  Ramachandran Venkatesh ,  Eric N. Hanson

    发明人： Conor J. Cunningham ,  Ramachandran Venkatesh ,  Eric N. Hanson

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30327 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99936 ,  Y10S707/99937 ,  Y10S707/99942 ,  Y10S707/99944

    摘要： Efficient hierarchical searching is based on object type. By pre-computing additional information and storing it in a fast-lookup structure, it is possible to quickly identify objects that satisfy an object retrieval request. Furthermore, it is also possible to use this technique to avoid object hydration for operations in the store. Moreover, it is possible to leverage database statistical structures such as histograms to estimate the number of qualifying objects without having to examine each object.

    摘要翻译： 高效的层次搜索是基于对象类型的。 通过预先计算附加信息并将其存储在快速查找结构中，可以快速识别满足对象检索请求的对象。 此外，也可以使用该技术来避免商店中的操作的物体水合。 此外，可以利用诸如直方图的数据库统计结构来估计限定对象的数量而不必检查每个对象。

    Structured indexes on results of function applications over data
    7.
    发明授权
    Structured indexes on results of function applications over data 有权

    公开(公告)号：US07254574B2

    公开(公告)日：2007-08-07

    申请号：US10795623

    申请日：2004-03-08

    申请人： Conor J. Cunningham ,  Eric N. Hanson ,  Milind M. Joshi ,  Cesar A. Galindo-Legaria ,  Florian M. Waas

    发明人： Conor J. Cunningham ,  Eric N. Hanson ,  Milind M. Joshi ,  Cesar A. Galindo-Legaria ,  Florian M. Waas

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30451 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

    摘要： Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is “cross apply unnest”. This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.

    Structured indexes on results of function applications over data
    8.
    发明授权
    Structured indexes on results of function applications over data 有权

    公开(公告)号：US07349897B2

    公开(公告)日：2008-03-25

    申请号：US11051447

    申请日：2005-02-04

    申请人： Conor J. Cunningham ,  Eric N. Hanson ,  Milind M. Joshi ,  Cesar A. Galindo-Legaria ,  Florian M. Waas

    发明人： Conor J. Cunningham ,  Eric N. Hanson ,  Milind M. Joshi ,  Cesar A. Galindo-Legaria ,  Florian M. Waas

    IPC分类号： G06F17/30 ,  G06F17/00

    CPC分类号： G06F17/30451 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

    摘要： Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is “cross apply unnest”. This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.

    Structured indexes on results of function applications over data
    9.
    发明授权
    Structured indexes on results of function applications over data 有权
    功能应用程序对数据结果的结构化索引

    公开(公告)号：US07340445B2

    公开(公告)日：2008-03-04

    申请号：US11051360

    申请日：2005-02-04

    申请人： Conor J. Cunningham ,  Eric N. Hanson ,  Milind M. Joshi ,  Cesar A. Galindo-Legaria ,  Florian M. Waas

    发明人： Conor J. Cunningham ,  Eric N. Hanson ,  Milind M. Joshi ,  Cesar A. Galindo-Legaria ,  Florian M. Waas

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30451 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

    摘要： Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is “cross apply unnest”. This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.

    摘要翻译： 索引视图或物化视图用作具有多值属性的基表上的辅助索引。 这提供了使用索引来搜索嵌套数据。 而且，索引是针对不良操作的结果。 索引对不察觉操作的结果的视图提供了对嵌套集合的内容进行索引的能力。 一个这样的不太理想的操作是“不适用”。 这为查询执行计划提供了其他选项，从而导致更优化的查询。 从索引视图向基表提供反向连接，以允许来自索引视图中不存在的基表中的字段包含在使用索引视图处理的表上的查询结果中作为 访问路径 这提供了一种在查询结果中包含不在索引视图中但在基表中的列的方法。 通过独立的集群密钥（作为逻辑行定位符），从单表索引视图向基表支持后连接。 因此，系统可以通过独特的聚类键从索引视图返回到基表。 这些功能允许使用索引视图来索引关于多集或多值属性的内容的表。

    Structured indexes on results of function applications over data
    10.
    发明授权
    Structured indexes on results of function applications over data 有权
    功能应用程序对数据结果的结构化索引

    公开(公告)号：US07272598B2

    公开(公告)日：2007-09-18

    申请号：US11096149

    申请日：2005-03-31

    申请人： Conor J. Cunningham ,  Eric N. Hanson ,  Milind M. Joshi ,  Cesar A. Galindo-Legaria ,  Florian M. Waas

    发明人： Conor J. Cunningham ,  Eric N. Hanson ,  Milind M. Joshi ,  Cesar A. Galindo-Legaria ,  Florian M. Waas

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30451 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

    摘要： Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is “cross apply unnest”. This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.

    摘要翻译： 索引视图或物化视图用作具有多值属性的基表上的辅助索引。 这提供了使用索引来搜索嵌套数据。 而且，索引是针对不良操作的结果。 索引对不察觉操作的结果的视图提供了对嵌套集合的内容进行索引的能力。 一个这样的不太理想的操作是“不适用”。 这为查询执行计划提供了其他选项，从而导致更优化的查询。 从索引视图向基表提供反向连接，以允许来自索引视图中不存在的基表中的字段包含在使用索引视图处理的表上的查询结果中作为 访问路径 这提供了一种在查询结果中包含不在索引视图中但在基表中的列的方法。 通过独立的集群密钥（作为逻辑行定位符），从单表索引视图向基表支持后连接。 因此，系统可以通过独特的聚类键从索引视图返回到基表。 这些功能允许使用索引视图来索引关于多集或多值属性的内容的表。