Partitioning of nested tables
    1.
    发明申请
    Partitioning of nested tables 有权
    嵌套表的分区

    公开(公告)号:US20080201296A1

    公开(公告)日:2008-08-21

    申请号:US11707735

    申请日:2007-02-16

    IPC分类号: G06F17/30

    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.

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

    Partitioning of nested tables
    2.
    发明授权
    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.

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

    USER DEFINED QUERY REWRITE MECHANISM
    3.
    发明申请
    USER DEFINED QUERY REWRITE MECHANISM 审中-公开
    用户定义的QUERY REWRITE机制

    公开(公告)号:US20090024570A1

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

    申请号:US11781139

    申请日:2007-07-20

    IPC分类号: G06F17/30

    CPC分类号: G06F16/24547

    摘要: A database statement contains a table function. The database statement is compiled by a database statement compiler. The database statement is rewritten by replacing the table function with a replacement database statement.

    摘要翻译: 数据库语句包含一个表函数。 数据库语句由数据库语句编译器编译。 通过用替换数据库语句替换表函数来重写数据库语句。

    Flashback support for domain index queries
    4.
    发明授权
    Flashback support for domain index queries 有权
    闪回支持域索引查询

    公开(公告)号:US07689549B2

    公开(公告)日:2010-03-30

    申请号:US11544790

    申请日:2006-10-05

    IPC分类号: G06F17/30

    摘要: Techniques for executing flashback queries using domain indexes in a database system are provided. In one technique, a flashback parameter of the flashback query is not included in a call-out invocation of domain index routines that implement a domain index. A call-back query execution unit nonetheless retrieves, for call-back queries issued by the domain index routines, call-back query results that reflect the state of a database in the database system as of the time specified in the flashback parameter. In another technique, a call-out invocation of domain index routines includes the flashback parameter of a flashback query. The domain index routines issue call-back queries that require the retrieval of data which reflects the state of a database as of the time specified in the flashback parameter, which are executed by the call-back query execution unit.

    摘要翻译: 提供了使用数据库系统中的域索引执行闪回查询的技术。 在一种技术中,闪回查询的闪回参数不包括在实现域索引的域索引例程的调用调用中。 回调查询执行单元仍然检索由域索引例程发出的回调查询,回调查询结果反映数据库系统中数据库的状态,直到闪回参数中指定的时间。 在另一种技术中,域索引例程的调出调用包括闪回查询的闪回参数。 域索引例程发出回调查询,要求检索反映由回退查询执行单元执行的闪回参数指定的时间内的数据库的状态的数据。

    Flashback support for domain index queries
    5.
    发明申请
    Flashback support for domain index queries 有权
    闪回支持域索引查询

    公开(公告)号:US20070198615A1

    公开(公告)日:2007-08-23

    申请号:US11544790

    申请日:2006-10-05

    IPC分类号: G06F17/30

    摘要: Techniques for executing flashback queries using domain indexes in a database system are provided. In one technique, a flashback parameter of the flashback query is not included in a call-out invocation of domain index routines that implement a domain index. A call-back query execution unit nonetheless retrieves, for call-back queries issued by the domain index routines, call-back query results that reflect the state of a database in the database system as of the time specified in the flashback parameter. In another technique, a call-out invocation of domain index routines includes the flashback parameter of a flashback query. The domain index routines issue call-back queries that require the retrieval of data which reflects the state of a database as of the time specified in the flashback parameter, which are executed by the call-back query execution unit.

    摘要翻译: 提供了使用数据库系统中的域索引执行闪回查询的技术。 在一种技术中,闪回查询的闪回参数不包括在实现域索引的域索引例程的调用调用中。 回调查询执行单元仍然检索由域索引例程发出的回调查询,回调查询结果反映数据库系统中数据库的状态,直到闪回参数中指定的时间。 在另一种技术中,域索引例程的调出调用包括闪回查询的闪回参数。 域索引例程发出回调查询,要求检索反映由回退查询执行单元执行的闪回参数指定的时间内的数据库的状态的数据。

    Techniques for Extending User-Defined Indexes with Auxiliary Properties
    7.
    发明申请
    Techniques for Extending User-Defined Indexes with Auxiliary Properties 有权
    扩展具有辅助属性的用户定义索引的技术

    公开(公告)号:US20090030883A1

    公开(公告)日:2009-01-29

    申请号:US12027897

    申请日:2008-02-07

    IPC分类号: G06F7/06

    摘要: In one embodiment, a database server registers one or more functions included in a user-defined index that includes one or more auxiliary properties. The one or more functions are operable to generate index entries of the user-defined index for the one or more auxiliary properties. The one or more auxiliary properties are different than, and in addition to, a primary property of the user-defined index that provides for evaluating a query operator. The database server receives a first statement that defines the user-defined index, where the first statement includes one or more parameters that define the one or more auxiliary properties. The database server invokes the one or more functions in response to the first statement, where the one or more functions when invoked generate and store the index entries of the user-defined index according to the one or more parameters that define the one or more auxiliary properties.

    摘要翻译: 在一个实施例中,数据库服务器注册包括在包括一个或多个辅助属性的用户定义索引中的一个或多个功能。 一个或多个功能可操作以生成用于一个或多个辅助属性的用户定义索引的索引条目。 一个或多个辅助属性不同于并且除了用于定义查询运算符的用户定义索引的主要属性之外。 数据库服务器接收定义用户定义的索引的第一个语句,其中第一个语句包含一个或多个定义一个或多个辅助属性的参数。 数据库服务器响应于第一语句来调用一个或多个函数,其中调用时一个或多个函数生成并根据定义一个或多个辅助的一个或多个参数来存储用户定义的索引的索引条目 属性。

    Minimum lifespan credentials for crawling data repositories
    9.
    发明授权
    Minimum lifespan credentials for crawling data repositories 有权
    用于爬取数据存储库的最小生命周期凭证

    公开(公告)号:US08875249B2

    公开(公告)日:2014-10-28

    申请号:US11680544

    申请日:2007-02-28

    摘要: A flexible and extensible architecture allows for secure searching across an enterprise. Such an architecture can provide a simple Internet-like search experience to users searching secure content inside (and outside) the enterprise. The architecture allows for the crawling and searching of a variety of sources across an enterprise, regardless of whether any of these sources conform to a conventional user role model. The architecture further allows for security attributes to be submitted at query time, for example, in order to provide real-time secure access to enterprise resources. The user query also can be transformed to provide for dynamic querying that provides for a more current result list than can be obtained for static queries.

    摘要翻译: 灵活可扩展的架构允许跨企业进行安全搜索。 这样的架构可以为在企业内部(和外部)搜索安全内容的用户提供简单的类似Internet的搜索体验。 该架构允许在整个企业中爬行和搜索各种源,而不管这些源是否符合常规用户角色模型。 该体系结构进一步允许在查询时提交安全属性,例如为了提供对企业资源的实时安全访问。 用户查询也可以被转换以提供动态查询,其提供比静态查询可获得的更多当前结果列表。

    Techniques for extending user-defined indexes with auxiliary properties
    10.
    发明授权
    Techniques for extending user-defined indexes with auxiliary properties 有权
    用辅助属性扩展用户定义的索引的技术

    公开(公告)号:US07996387B2

    公开(公告)日:2011-08-09

    申请号:US12027897

    申请日:2008-02-07

    IPC分类号: G06F17/30

    摘要: In one embodiment, a database server registers one or more functions included in a user-defined index that includes one or more auxiliary properties. The one or more functions are operable to generate index entries of the user-defined index for the one or more auxiliary properties. The one or more auxiliary properties are different than, and in addition to, a primary property of the user-defined index that provides for evaluating a query operator. The database server receives a first statement that defines the user-defined index, where the first statement includes one or more parameters that define the one or more auxiliary properties. The database server invokes the one or more functions in response to the first statement, where the one or more functions when invoked generate and store the index entries of the user-defined index according to the one or more parameters that define the one or more auxiliary properties.

    摘要翻译: 在一个实施例中,数据库服务器注册包括在包括一个或多个辅助属性的用户定义索引中的一个或多个功能。 一个或多个功能可操作以生成用于一个或多个辅助属性的用户定义索引的索引条目。 一个或多个辅助属性不同于并且除了用于定义查询运算符的用户定义索引的主要属性之外。 数据库服务器接收定义用户定义的索引的第一个语句,其中第一个语句包含一个或多个定义一个或多个辅助属性的参数。 数据库服务器响应于第一语句来调用一个或多个函数,其中调用时一个或多个函数生成并根据定义一个或多个辅助的一个或多个参数来存储用户定义的索引的索引条目 属性。