Interpreting remote objects at a local site
    1.
    发明申请
    Interpreting remote objects at a local site 有权
    在本地站点解释远程对象

    公开(公告)号:US20050262113A1

    公开(公告)日:2005-11-24

    申请号:US10949102

    申请日:2004-09-24

    IPC分类号: G06F17/00 G06F17/30

    CPC分类号: G06F17/30569

    摘要: A method and apparatus for receiving objects is provided. Embodiments provide for receiving, from a source database server, at a target database server, an object. If the object type of the object is involved in an inheritance hierarchy, then the target database server inspects the object to determine a source identifier that identifies to a source database server the object type associated with the object. The target database determines a target identifier that identifies to the target database server the object type associated with the object based on a mapping that associates source identifiers to target identifiers. Alternately, if the object type of the object is not involved in an inheritance hierarchy, then the target database server inspects the object to determine a set of characteristics of the object. The target database server determines the target identifier for the object based on the characteristics of the object.

    摘要翻译: 提供了一种用于接收物体的方法和装置。 实施例提供从源数据库服务器在目标数据库服务器处接收对象。 如果对象的对象类型涉及继承层次结构,则目标数据库服务器将检查对象以确定向源数据库服务器标识与对象关联的对象类型的源标识符。 目标数据库基于将源标识符与目标标识符相关联的映射来确定向目标数据库服务器标识与对象相关联的对象类型的目标标识符。 或者,如果对象的对象类型不涉及继承层次结构,则目标数据库服务器将检查对象以确定对象的一组特征。 目标数据库服务器基于对象的特征来确定对象的目标标识符。

    Interpreting remote objects at a local site
    2.
    发明授权
    Interpreting remote objects at a local site 有权
    在本地站点解释远程对象

    公开(公告)号:US08359336B2

    公开(公告)日:2013-01-22

    申请号:US10949102

    申请日:2004-09-24

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30569

    摘要: A method and apparatus for receiving objects is provided. Embodiments provide for receiving, from a source database server, at a target database server, an object. If the object type of the object is involved in an inheritance hierarchy, then the target database server inspects the object to determine a source identifier that identifies to a source database server the object type associated with the object. The target database determines a target identifier that identifies to the target database server the object type associated with the object based on a mapping that associates source identifiers to target identifiers. Alternately, if the object type of the object is not involved in an inheritance hierarchy, then the target database server inspects the object to determine a set of characteristics of the object. The target database server determines the target identifier for the object based on the characteristics of the object.

    摘要翻译: 提供了一种用于接收物体的方法和装置。 实施例提供从源数据库服务器在目标数据库服务器处接收对象。 如果对象的对象类型涉及继承层次结构,则目标数据库服务器将检查对象以确定向源数据库服务器标识与对象关联的对象类型的源标识符。 目标数据库基于将源标识符与目标标识符相关联的映射来确定向目标数据库服务器标识与对象相关联的对象类型的目标标识符。 或者,如果对象的对象类型不涉及继承层次结构,则目标数据库服务器将检查对象以确定对象的一组特征。 目标数据库服务器基于对象的特征来确定对象的目标标识符。

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

    公开(公告)号:US20080098048A1

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

    申请号:US11732844

    申请日:2007-04-04

    IPC分类号: G06F17/30

    摘要: 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.

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

    Partitioning of nested tables
    5.
    发明授权
    Partitioning of nested tables 有权
    嵌套表的分区

    公开(公告)号:US07756889B2

    公开(公告)日:2010-07-13

    申请号:US11707735

    申请日:2007-02-16

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30486 G06F17/30312

    摘要: Techniques for partitioning nested tables are provided. A parent table includes a column for collection items. A nested table is created for storing items that belong to the collection items. The nested table is partitioned to create a plurality of nested table partitions. Each nested table partition is a distinct, separately stored structure within a database. How the nested table is partitioned may, or may not, be based on how the parent table is partitioned. For example, a nested table may be partitioned based on the same criteria in which the parent table is partitioned. As another example, a nested table may be partitioned, whereas the parent table is not partitioned.

    摘要翻译: 提供分区嵌套表的技术。 父表包括收集项列。 创建嵌套表用于存储属于集合项目的项目。 嵌套表被分区以创建多个嵌套表分区。 每个嵌套表分区是一个不同的,单独存储的数据库结构。 嵌套表的分区方式可能是,也可能不是基于父表的分区方式。 例如,嵌套表可以根据父表进行分区的相同标准进行分区。 作为另一示例,嵌套表可以被分区,而父表不被分区。

    Technique and framework to provide diagnosability for XML query/DML rewrite and XML index selection

    公开(公告)号:US09767214B2

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

    申请号:US13172573

    申请日:2011-06-29

    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.

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

    公开(公告)号:US07849113B2

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

    申请号:US11978799

    申请日:2007-10-30

    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.

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

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

    公开(公告)号:US07630957B2

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

    申请号:US11426697

    申请日:2006-06-27

    IPC分类号: G06F7/00

    摘要: 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通过在将数据滑动插入或删除到数据库后自动更改书签的偏移量,从而提供不可变书签的功能。