利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

17 条记录 (耗时 0.023 秒)

    Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries
    3.
    发明授权
    Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries 有权
    用于预测维护辅助数据库结构以用于执行数据库查询的效果的方法和装置

    公开(公告)号：US07743052B2

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

    申请号：US11353515

    申请日：2006-02-14

    申请人： Robert Joseph Bestgen ,  James Michael Flanagan ,  Michael Donald Pfeifer

    发明人： Robert Joseph Bestgen ,  James Michael Flanagan ,  Michael Donald Pfeifer

    IPC分类号： G06F7/00

    CPC分类号： G06F17/30289 ,  G06F17/30386

    摘要： A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.

    摘要翻译： 数据库管理系统维护可以针对数据库执行的查询记录。 对于给定的辅助数据库结构，咨询功能自动审查查询记录，并使用辅助数据库结构识别可能以更高效率执行的查询，向用户呈现分析信息。 优选地，辅助数据库结构是索引，并且该信息用于确定是否将数据包括在数据库定义中。 优选地，当考虑多个备选数据库优化时，查询优化器记录潜在有用的索引，并且稍后检索该信息以识别将从索引中受益的查询。

    Autonomic index creation
    4.
    发明授权
    Autonomic index creation 有权
    自主创建指数

    公开(公告)号：US08838573B2

    公开(公告)日：2014-09-16

    申请号：US11423216

    申请日：2006-06-09

    申请人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

    发明人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

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

    CPC分类号： G06F17/30312 ,  G06F17/30946

    摘要： An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation. An autonomic index creation mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created based on the information in the index advice records and the index advice policies. By automating the process of creating indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating indexes.

    摘要翻译： 索引建议记录引擎生成并存储索引建议记录。 索引建议策略机制允许用户定义一个索引建议策略，该策略指定自主索引创建的标准。 自主索引创建机制读取索引建议记录，将此信息与用户定义的索引建议策略中的条件进行比较，并根据索引建议记录和索引建议策略中的信息确定是否创建索引。 通过根据用户定义的策略自动创建索引的过程，优选实施例从人工创建索引的大部分工作中减轻人类用户。

    Autonomic index creation, modification and deletion
    5.
    发明授权
    Autonomic index creation, modification and deletion 失效
    自主创建，修改和删除

    公开(公告)号：US08121988B2

    公开(公告)日：2012-02-21

    申请号：US12194240

    申请日：2008-08-19

    申请人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

    发明人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30336 ,  G06F17/30312 ,  G06F17/30946

    摘要： An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation, modification and deletion. An autonomic index mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created, modified or deleted based on the information in the index advice records and the index advice policies. By automating the process of creating, modifying and deleting indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating, modifying and deleting indexes.

    摘要翻译： 索引建议记录引擎生成并存储索引建议记录。 索引建议策略机制允许用户定义一个索引建议策略，该策略指定自主索引创建，修改和删除的标准。 自动索引机制读取索引建议记录，将此信息与用户定义的索引建议策略中的条件进行比较，并根据索引建议记录和索引建议中的信息确定是否创建，修改或删除索引 政策。 通过根据用户定义的策略自动创建，修改和删除索引的过程，优选实施例从人工创建，修改和删除索引的大部分工作中缓解人类用户。

    Apparatus and Method for Autonomic Index Creation
    6.
    发明申请
    Apparatus and Method for Autonomic Index Creation 有权
    自动索引创建的装置和方法

    公开(公告)号：US20070288428A1

    公开(公告)日：2007-12-13

    申请号：US11423216

    申请日：2006-06-09

    申请人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

    发明人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30312 ,  G06F17/30946

    摘要： An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation. An autonomic index creation mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created based on the information in the index advice records and the index advice policies. By automating the process of creating indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating indexes.

    摘要翻译： 索引建议记录引擎生成并存储索引建议记录。 索引建议策略机制允许用户定义一个索引建议策略，该策略指定自主索引创建的标准。 自主索引创建机制读取索引建议记录，将此信息与用户定义的索引建议策略中的条件进行比较，并根据索引建议记录和索引建议策略中的信息确定是否创建索引。 通过根据用户定义的策略自动创建索引的过程，优选实施例从人工创建索引的大部分工作中减轻人类用户。

    Autonomic index creation, modification and deletion
    8.
    发明授权
    Autonomic index creation, modification and deletion 有权
    自主创建，修改和删除

    公开(公告)号：US08838574B2

    公开(公告)日：2014-09-16

    申请号：US11423233

    申请日：2006-06-09

    申请人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

    发明人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

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

    CPC分类号： G06F17/30336 ,  G06F17/30312 ,  G06F17/30946

    摘要： An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation, modification and deletion. An autonomic index mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created, modified or deleted based on the information in the index advice records and the index advice policies. By automating the process of creating, modifying and deleting indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating, modifying and deleting indexes.

    摘要翻译： 索引建议记录引擎生成并存储索引建议记录。 索引建议策略机制允许用户定义一个索引建议策略，该策略指定自主索引创建，修改和删除的标准。 自动索引机制读取索引建议记录，将此信息与用户定义的索引建议策略中的条件进行比较，并根据索引建议记录和索引建议中的信息确定是否创建，修改或删除索引 政策。 通过根据用户定义的策略自动创建，修改和删除索引的过程，优选实施例从人工创建，修改和删除索引的大部分工作中缓解人类用户。

    Autonomic index creation, modification and deletion
    9.
    发明授权
    Autonomic index creation, modification and deletion 失效
    自主创建，修改和删除

    公开(公告)号：US08595212B2

    公开(公告)日：2013-11-26

    申请号：US12192629

    申请日：2008-08-15

    申请人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

    发明人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30336

    摘要： An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation, modification and deletion. An autonomic index mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created, modified or deleted based on the information in the index advice records and the index advice policies. By automating the process of creating, modifying and deleting indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating, modifying and deleting indexes.

    摘要翻译： 索引建议记录引擎生成并存储索引建议记录。 索引建议策略机制允许用户定义一个索引建议策略，该策略指定自主索引创建，修改和删除的标准。 自动索引机制读取索引建议记录，将此信息与用户定义的索引建议策略中的条件进行比较，并根据索引建议记录和索引建议中的信息确定是否创建，修改或删除索引 政策。 通过根据用户定义的策略自动创建，修改和删除索引的过程，优选实施例从人工创建，修改和删除索引的大部分工作中缓解人类用户。

    AUTONOMIC INDEX CREATION, MODIFICATION AND DELETION
    10.
    发明申请
    AUTONOMIC INDEX CREATION, MODIFICATION AND DELETION 失效
    自动索引创建，修改和删除

    公开(公告)号：US20080301196A1

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

    申请号：US12192629

    申请日：2008-08-15

    申请人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

    发明人： Mark John Anderson ,  Robert Joseph Bestgen ,  James Michael Flanagan ,  Scott Forstie ,  Thomas James Schreiber

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

    CPC分类号： G06F17/30336

    摘要： An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation, modification and deletion. An autonomic index mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created, modified or deleted based on the information in the index advice records and the index advice policies. By automating the process of creating, modifying and deleting indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating, modifying and deleting indexes.

    摘要翻译： 索引建议记录引擎生成并存储索引建议记录。 索引建议策略机制允许用户定义一个索引建议策略，该策略指定自主索引创建，修改和删除的标准。 自动索引机制读取索引建议记录，将此信息与用户定义的索引建议策略中的条件进行比较，并根据索引建议记录和索引建议中的信息确定是否创建，修改或删除索引 政策。 通过根据用户定义的策略自动创建，修改和删除索引的过程，优选实施例从人工创建，修改和删除索引的大部分工作中缓解人类用户。