Object-oriented materialized views
    31.
    发明授权
    Object-oriented materialized views 有权
    面向对象的物化视图

    公开(公告)号:US07158994B1

    公开(公告)日:2007-01-02

    申请号:US10006605

    申请日:2001-12-05

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    摘要: Techniques are provided for creating object-oriented materialized views. The object-oriented materialized views may be object materialized views or object-relational materialized views. The base tables may be object tables, object relational tables, or relational tables. The object-oriented materialized views may be refreshed, fully or incrementally. When an object-oriented materialized view is created, refresh code is generated for it. Through the use of object-oriented materialized views, users gain both the efficiency of materialized views and the power of the object-oriented paradigm.

    摘要翻译: 提供了用于创建面向对象的物化视图的技术。 面向对象的物化视图可以是对象物化视图或物体关系物化视图。 基表可以是对象表,对象关系表或关系表。 面向对象的物化视图可以被刷新,完全或递增。 当创建面向对象的物化视图时,会为其生成刷新代码。 通过使用面向对象的物化视图,用户可以获得物化视图的效率和面向对象范式的力量。

    Communicating external expressions using a parallel single cursor model
    32.
    发明申请
    Communicating external expressions using a parallel single cursor model 有权
    使用并行单光标模型来传达外部表达式

    公开(公告)号:US20050131890A1

    公开(公告)日:2005-06-16

    申请号:US10865178

    申请日:2004-06-09

    IPC分类号: G06F7/00 G06F17/30

    摘要: Techniques are provided for processing, within a database server, a database statement, where at least one subtask required by the database statement is to be executed in parallel by a slave set. The database server determines whether the database statement includes an external expression, relative to the subtask, that (a) produces information that is required by slave processes in the slave set in order to perform the subtask, and (b) is not to be evaluated by each slave process in the slave set. During execution of the statement, if the database statement includes an external expression, then one or more external values are generated by causing the external expression to be evaluated, and the one or more external values are communicated to slaves of the slave set to allow the slave processes to perform respective portions of the subtask in parallel, without requiring each slave of the slave set to evaluate the external expression.

    摘要翻译: 提供技术来在数据库服务器内处理数据库语句,数据库语句所要求的至少一个子任务将由从属集并行执行。 数据库服务器确定数据库语句是否包含相对于子任务的外部表达式,(a)产生从属集中的从属进程所需的信息以执行子任务,并且(b)不被评估 由从设备中的每个从属进程。 在执行语句期间,如果数据库语句包含外部表达式,则通过使外部表达式进行求值来生成一个或多个外部值,并将一个或多个外部值传送到从设备的从站,以允许 从属进程并行执行子任务的各个部分,而不需要从属集的每个从属点来评估外部表达式。

    Distributed cache arrangement
    33.
    发明授权
    Distributed cache arrangement 有权
    分布式缓存安排

    公开(公告)号:US08943271B2

    公开(公告)日:2015-01-27

    申请号:US12363505

    申请日:2009-01-30

    IPC分类号: G06F12/08 G06F12/12

    摘要: Systems and methods that aggregate memory capacity of multiple computers into a single unified cache, via a layering arrangement. Such layering arrangement is scalable to a plurality of machines and includes a data manager component, an object manager component and a distributed object manager component, which can be implemented in a modular fashion. Moreover, the layering arrangement can provide for an explicit cache tier (e.g., cache-aside architecture) that applications are aware about, wherein decision are made explicitly which objects to put/remove in such applications (as opposed to an implicit cache wherein application do not know the existence of the cache).

    摘要翻译: 通过分层排列将多台计算机的内存容量集中到一个统一缓存中的系统和方法。 这种分层布置可扩展到多个机器,并且包括可以以模块化方式实现的数据管理器组件,对象管理器组件和分布式对象管理器组件。 此外,分层布置可以提供应用程序知道的显式高速缓存层(例如,高速缓存替代架构),其中明确地确定在这样的应用中放置/去除哪些对象(与应用程序执行的隐式缓存相反) 不知道缓存的存在)。

    Open types for distributed systems
    35.
    发明授权
    Open types for distributed systems 有权
    分布式系统的开放类型

    公开(公告)号:US08375018B2

    公开(公告)日:2013-02-12

    申请号:US12483359

    申请日:2009-06-12

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30448

    摘要: Techniques for exchanging data are provided herein. An “open” data type is established on a computer system to define the structure of data. The open data type includes one or more predefined properties, and enables one or more extension properties to be optionally included. Data that is defined according to the open data type includes data values for the predefined properties, and may optionally include data values for extension properties. A second computer system may consider the extension properties to be extension properties or predefined properties of a data type known at the second computer system. In this manner, the type system that is used to exchange data between nodes need not necessarily be commonly known among the nodes, and/or may be dynamically modified, even for a particular data instance. Furthermore, queries may be performed against the data that query against the predefined properties and/or extension properties.

    摘要翻译: 本文提供了交换数据​​的技术。 在计算机系统上建立开放数据类型以定义数据的结构。 打开的数据类型包括一个或多个预定义的属性,并且允许可选地包括一个或多个扩展属性。 根据开放数据类型定义的数据包括预定义属性的数据值,并且可以可选地包括扩展属性的数据值。 第二计算机系统可以将扩展属性视为在第二计算机系统中已知的数据类型的扩展属性或预定属性。 以这种方式,用于在节点之间交换数据的类型系统不一定在节点之间是众所周知的,和/或可以动态修改,即使对于特定的数据实例也是如此。 此外,可以针对针对预定义属性和/或扩展属性进行查询的数据执行查询。

    Processing path-based database operations
    38.
    发明授权
    Processing path-based database operations 有权
    处理基于路径的数据库操作

    公开(公告)号:US07627547B2

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

    申请号:US10999864

    申请日:2004-11-29

    IPC分类号: G06F7/00

    摘要: A method and apparatus for processing path-based database operations is provided. According to one aspect, a “parent row ID” column is added to a directory links table. For each row in the table, the value of the “parent row ID” column indicates the row ID, in the table, of the node that is that row's node's parent in the file hierarchy. To determine whether a particular node is within a specified path of the file hierarchy, the particular node's pathname is derived by visiting child-to-parent links indicated in the table and prepending, to the front of a pathname being constructed for the particular node, node names indicated in the visited rows. Each parent node's row in the directory links table is located using the “parent row ID” column of the child node's row. The resulting pathname is compared with the specified path to determine whether the particular node exists therein.

    摘要翻译: 提供了一种用于处理基于路径的数据库操作的方法和装置。 根据一个方面,将“父行ID”列添加到目录链接表。 对于表中的每一行,“父行ID”列的值表示表中该行的文件层次结构中该节点的父节点的行ID。 为了确定特定节点是否在文件层次结构的指定路径内,特定节点的路径名是通过访问表中指示的前后的子对象链接导出到为特定节点构建的路径名的前面, 访问行中指示的节点名称。 目录链接表中的每个父节点的行都使用子节点行的“父行ID”列进行定位。 将得到的路径名与指定的路径进行比较,以确定特定节点是否存在于其中。

    Techniques for rewriting XML queries directed to relational database constructs
    40.
    发明授权
    Techniques for rewriting XML queries directed to relational database constructs 有权
    重写针对关系数据库结构的XML查询的技术

    公开(公告)号:US07120645B2

    公开(公告)日:2006-10-10

    申请号:US10428878

    申请日:2003-05-01

    IPC分类号: G06F17/30

    摘要: Techniques for executing database commands include receiving a database command that includes an XML component operation that operates on an XML construct that is based on a first set of one or more relational database constructs. It is determined whether the XML component operation can be transformed to a relational database operation on a particular set of one or more relational database constructs of the first set, which does not involve the XML component operation. If it is determined that the XML component operation can be transformed, then the XML component operation is rewritten as a particular relational database operation that operates on the particular set and that does not involve the XML component operation. The particular relational database operation is evaluated. In another aspect, techniques include determining a primitive set of XML generation operations and replacing non-primitive XML generation operations with one or more operations from the primitive set.

    摘要翻译: 用于执行数据库命令的技术包括接收包括对基于第一组一个或多个关系数据库构造的XML构造进行操作的XML组件操作的数据库命令。 确定XML组件操作是否可以被转换为第一组的一个或多个关系数据库构造的特定集合上的关系数据库操作,其不涉及XML组件操作。 如果确定可以转换XML组件操作,则将XML组件操作重写为在特定集合上操作且不涉及XML组件操作的特定关系数据库操作。 评估特定的关系数据库操作。 在另一方面,技术包括确定XML生成操作的原始集合并且用来自原语集合的一个或多个操作来替换非原始XML生成操作。