利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

17 条记录 (耗时 0.031 秒)

    Immutable bookmarks for large objects in a database
    5.
    发明授权
    Immutable bookmarks for large objects in a database 有权
    数据库中大对象不可变的书签

    公开(公告)号：US07630957B2

    公开(公告)日：2009-12-08

    申请号：US11426697

    申请日：2006-06-27

    申请人： Geeta Arora ,  Muralidhar Krishnaprasad

    发明人： Geeta Arora ,  Muralidhar Krishnaprasad

    IPC分类号： G06F7/00

    CPC分类号： G06F17/30318 ,  Y10S707/99932

    摘要： User-level bookmarks are initially created at a specified offset in a large object (LOB) of a database and automatically updated to reflect a new offset, if necessary, after database updates. By logically linking the bookmark to a data element, the bookmark continues to point to the same logical data element as it did before the update. An API provides the functionality of immutable bookmarks by automatically changing the offset of the bookmark following sliding inserts or deletions of data to the database.

    摘要翻译： 用户级书签最初以数据库的大对象（LOB）中指定的偏移量创建，并在数据库更新后自动更新以反映新的偏移量（如有必要）。 通过将书签逻辑地链接到数据元素，书签继续指向与更新前相同的逻辑数据元素。 API通过在将数据滑动插入或删除到数据库后自动更改书签的偏移量，从而提供不可变书签的功能。

    Immutable Bookmarks for Large Objects in a Database
    6.
    发明申请
    Immutable Bookmarks for Large Objects in a Database 有权
    数据库中大对象不可变的书签

    公开(公告)号：US20070299816A1

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

    申请号：US11426697

    申请日：2006-06-27

    申请人： Geeta Arora ,  Muralidhar Krishnaprasad

    发明人： Geeta Arora ,  Muralidhar Krishnaprasad

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30318 ,  Y10S707/99932

    摘要： User-level bookmarks are initially created at a specified offset in a large object (LOB) of a database and automatically updated to reflect a new offset, if necessary, after database updates. By logically linking the bookmark to a data element, the bookmark continues to point to the same logical data element as it did before the update. An API provides the functionality of immutable bookmarks by automatically changing the offset of the bookmark following sliding inserts or deletions of data to the database.

    摘要翻译： 用户级书签最初以数据库的大对象（LOB）中指定的偏移量创建，并在数据库更新后自动更新以反映新的偏移量（如有必要）。 通过将书签逻辑地链接到数据元素，书签继续指向与更新前相同的逻辑数据元素。 API通过在将数据滑动插入或删除到数据库后自动更改书签的偏移量，从而提供不可变书签的功能。

    Technique and framework to provide diagnosability for XML query/DML rewrite and XML index selection
    7.
    发明授权
    Technique and framework to provide diagnosability for XML query/DML rewrite and XML index selection 有权

    公开(公告)号：US09767214B2

    公开(公告)日：2017-09-19

    申请号：US13172573

    申请日：2011-06-29

    申请人： Beda Christoph Hammerschmidt ,  Zhen Hua Liu ,  Geeta Arora ,  Thomas Baby

    发明人： Beda Christoph Hammerschmidt ,  Zhen Hua Liu ,  Geeta Arora ,  Thomas Baby

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

    CPC分类号： G06F17/30929

    摘要： A method and apparatus for automatically analyzing and providing feedback regarding the optimizability of a relational database query. A query developer's primary goal is to ensure that queries and DML operations are rewritten for the most efficient execution. Rewrite diagnosability captures metadata for each attempted query optimization including success or failure and the reasons for failure. The metadata is stored in association with the operators that were not removed through rewriting. Once all optimizations have been attempted and rewriting is complete, the metadata is selectively displayed based on the cost to perform the associated operation. The context of performing the operation may affect the cost. The cost may be based at least on the type of operation and where within the query tree the operation is located. A query developer may configure the database system not to execute the resulting query plan based on one or more criteria.

    Technique and Framework to Provide Diagnosability for XML Query/DML Rewrite and XML Index Selection
    8.
    发明申请
    Technique and Framework to Provide Diagnosability for XML Query/DML Rewrite and XML Index Selection 有权
    为XML查询/ DML重写和XML索引选择提供可诊断性的技术和框架

    公开(公告)号：US20130006964A1

    公开(公告)日：2013-01-03

    申请号：US13172573

    申请日：2011-06-29

    申请人： Beda Christoph Hammerschmidt ,  Zhen Hua Liu ,  Geeta Arora ,  Thomas Baby

    发明人： Beda Christoph Hammerschmidt ,  Zhen Hua Liu ,  Geeta Arora ,  Thomas Baby

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30929

    摘要： A method and apparatus for automatically analyzing and providing feedback regarding the optimizability of a relational database query. A query developer's primary goal is to ensure that queries and DML operations are rewritten for the most efficient execution. Rewrite diagnosability captures metadata for each attempted query optimization including success or failure and the reasons for failure. The metadata is stored in association with the operators that were not removed through rewriting. Once all optimizations have been attempted and rewriting is complete, the metadata is selectively displayed based on the cost to perform the associated operation. The context of performing the operation may affect the cost. The cost may be based at least on the type of operation and where within the query tree the operation is located. A query developer may configure the database system not to execute the resulting query plan based on one or more criteria.

    摘要翻译： 一种用于自动分析和提供关于关系数据库查询的可优化性的反馈的方法和装置。 查询开发人员的主要目标是确保查询和DML操作被重写以实现最有效的执行。 重写诊断能力捕获每个尝试的查询优化的元数据，包括成功或失败以及失败的原因。 元数据与未通过重写删除的运算符相关联存储。 一旦尝试了所有优化并重写完成后，将根据执行相关操作的成本选择性地显示元数据。 执行操作的上下文可能会影响成本。 成本可以至少基于操作类型以及操作所在查询树中的哪一个。 查询开发人员可以将数据库系统配置为不基于一个或多个标准执行生成的查询计划。

    Query statistics
    9.
    发明授权
    Query statistics 有权
    查询统计信息

    公开(公告)号：US07849113B2

    公开(公告)日：2010-12-07

    申请号：US11978799

    申请日：2007-10-30

    申请人： Sundeep Abraham ,  Wesley C. Lin ,  Yasuhiro Matsuda ,  Mohammad Faisal ,  Geeta Arora

    发明人： Sundeep Abraham ,  Wesley C. Lin ,  Yasuhiro Matsuda ,  Mohammad Faisal ,  Geeta Arora

    IPC分类号： G06F17/20 ,  G06F15/16

    CPC分类号： G06F17/30536 ,  G06F17/30442

    摘要： Systems, methods, and other embodiments associated with selectively acquiring and utilizing query statistics are described. One example method includes selectively acquiring statistics associated with search queries submitted to a search process during a sample period. The statistics may be associated with an index and tokens associated with the index and search queries. The method may also include selecting tokens and/or queries to optimize based, at least in part, on the statistics. In one example, whether and/or how the tokens and/or queries are optimized may depend on estimating index fragmentation based, at least in part, on the statistics.

    摘要翻译： 描述了与选择性地获取和利用查询统计相关联的系统，方法和其他实施例。 一个示例性方法包括选择性地获取在采样周期期间提交到搜索过程的搜索查询相关联的统计信息。 统计信息可能与与索引和搜索查询相关联的索引和令牌相关联。 该方法还可以包括至少部分地基于统计信息来选择令牌和/或查询进行优化。 在一个示例中，是否和/或如何优化令牌和/或查询可以取决于至少部分地基于统计量估计索引碎片。

    Migrating temporary data of a session
    10.
    发明申请
    Migrating temporary data of a session 有权
    迁移会话的临时数据

    公开(公告)号：US20080098048A1

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

    申请号：US11732844

    申请日：2007-04-04

    申请人： Yujie Cao ,  Tugrul Bingol ,  Geeta Arora ,  Harmeek Singh Bedi ,  Susan M. Kotsovolos

    发明人： Yujie Cao ,  Tugrul Bingol ,  Geeta Arora ,  Harmeek Singh Bedi ,  Susan M. Kotsovolos

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30306 ,  G06F11/2097 ,  Y10S707/99953

    摘要： A technique for migrating (e.g., “copying” or “moving”) temporary data from one session to another session is provided. While executing a workload associated with a particular session, session state is created. A subset of the session state comprises large objects that are referred to as “temporary data.” Thus, temporary data is stored in a database (instead of in the database server) and is normally deleted when the particular session is deleted. To avoid this deletion when the session state is migrated to a different session, the temporary data, in one embodiment, is saved in an external storage that is separate from the database. An external table is created in the external storage and stores the temporary data. Location information to access the external table is provided to the other session.

    摘要翻译： 提供了用于将临时数据从一个会话迁移（例如，“复制”或“移动”）到另一会话的技术。 在执行与特定会话相关联的工作时，会创建会话状态。 会话状态的一个子集包括被称为“临时数据”的大对象。 因此，临时数据存储在数据库（而不是数据库服务器）中，并且在特定会话被删除时通常被删除。 为了在将会话状态迁移到不同的会话时避免该删除，在一个实施例中，临时数据被保存在与数据库分开的外部存储器中。 在外部存储器中创建外部表，并存储临时数据。 访问外部表的位置信息被提供给另一个会话。