CONCEPT OF RELATIONSHIPSETS IN ENTITY DATA MODEL (EDM)
    3.
    发明申请
    CONCEPT OF RELATIONSHIPSETS IN ENTITY DATA MODEL (EDM) 审中-公开
    实体数据模型(EDM)中的关系概念

    公开(公告)号:US20070266041A1

    公开(公告)日:2007-11-15

    申请号:US11468008

    申请日:2006-08-29

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F16/288

    摘要: The claimed subject matter provides a system and/or a method that facilitates addressing complex modeling. An entity data model that can receive data via an interface and that formalizes a notion of at least one of a Relationship, a Relationship instance, and a Relationship Set in a manner substantially similar to at least one of an Entity type, an Entity instance, and an entity-set respectively, wherein a semantic related to the at least one of the Relationship, the Relationship instance, and the Relationship Set are captured as metadata in the same manner as metadata is captured for at least one of the Entity type, the Entity instance, and the Entity-set, respectively.

    摘要翻译: 所要求保护的主题提供了有助于寻址复杂建模的系统和/或方法。 实体数据模型,其可以经由接口接收数据并以与实体类型,实体实例中的至少一个实质上相似的方式形式化关系,关系实例和关系集中的至少一个的概念, 以及实体集合,其中与所述关系,所述关系实例和所述关系集合中的至少一个相关的语义以与为所述实体类型,所述实体集合中的至少一个被捕获的元数据相同的方式被捕获为元数据 实体实例和实体集。

    Storage optimization for VARRAY columns
    7.
    发明授权
    Storage optimization for VARRAY columns 有权
    VARRAY列的存储优化

    公开(公告)号:US07320061B2

    公开(公告)日:2008-01-15

    申请号:US10912426

    申请日:2004-08-05

    IPC分类号: G06F12/00

    CPC分类号: G06F17/30318

    摘要: Methods and apparatus for efficiently storing data in a variable array (VARRAY) of a database system are disclosed. A method for storing data in a VARRAY having an associated large object segment in a system having a memory and a kernel includes determining a size of data to be inserted into the VARRAY. The method also includes determining when the size of the data is less than a threshold value, and storing the data as inline raw data in a column of the VARRAY that is present in the memory when the size of the data is less than the threshold value. When the size of the data is not less than the threshold value, the data is stored in a large object that is associated with the VARRAY. Further, when a VARRAY type is evolved to have a larger maximum size, existing data is not migrated or transformed.

    摘要翻译: 公开了将数据有效地存储在数据库系统的可变数组(VARRAY)中的方法和装置。 在具有存储器和内核的系统中具有相关联的大对象段的VARRAY中存储数据的方法包括确定要插入到VARRAY中的数据的大小。 该方法还包括当数据的大小小于阈值时确定数据的大小是否小于阈值,并且当数据的大小小于阈值时,将数据作为内联原始数据存储在存在于存储器中的VARRAY的列中 。 当数据的大小不小于阈值时,数据存储在与VARRAY相关联的大对象中。 此外,当VARRAY类型演变为具有较大的最大大小时,现有数据不会迁移或转换。

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

    公开(公告)号:US07203672B2

    公开(公告)日:2007-04-10

    申请号:US10865178

    申请日:2004-06-09

    IPC分类号: 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)不被评估 由从设备中的每个从属进程。 在执行语句期间,如果数据库语句包含外部表达式,则通过使外部表达式进行求值来生成一个或多个外部值,并将一个或多个外部值传送到从设备的从站,以允许 从属进程并行执行子任务的各个部分,而不需要从属集的每个从属点来评估外部表达式。

    Techniques for peer-to-peer replication of objects in a relational database
    9.
    发明授权
    Techniques for peer-to-peer replication of objects in a relational database 有权
    用于关系数据库中对象的对等复制的技术

    公开(公告)号:US06889229B1

    公开(公告)日:2005-05-03

    申请号:US09968617

    申请日:2001-09-28

    IPC分类号: G06F17/30

    摘要: Techniques for replicating a database object of a relational database managed by a database system from a first node on a network to a second node on the network include determining that the database object on the first node includes a user-defined object. A first routine of the database system is invoked. The first routine performs the step of copying the database object to the second node of the network. The first routine copies a name of a user-defined defined type of the user-defined object from the first node to the second node. The first routine also copies a first definition of the user-defined type from the first node to the second node. The first routine then copies a second definition of the database object from the first node to the second node. The second definition includes the name of the user-defined type. These techniques provide the benefits of peer-to-peer replication in a distributed database to users of object-relational databases that including user-defined objects.

    摘要翻译: 将由数据库系统管理的关系数据库的数据库对象从网络上的第一节点复制到网络上的第二节点的技术包括确定第一节点上的数据库对象包括用户定义的对象。 调用数据库系统的第一个例程。 第一个例程执行将数据库对象复制到网络的第二个节点的步骤。 第一个例程将用户定义的用户定义的类型的名称从第一个节点复制到第二个节点。 第一例程还将用户定义类型的第一定义从第一节点复制到第二节点。 然后,第一个例程将数据库对象的第二个定义从第一个节点复制到第二个节点。 第二个定义包括用户定义类型的名称。 这些技术为包括用户定义的对象的对象关系数据库的用户提供了分布式数据库中对等复制的好处。

    Multiple cache directories
    10.
    发明授权
    Multiple cache directories 有权
    多个缓存目录

    公开(公告)号:US08161244B2

    公开(公告)日:2012-04-17

    申请号:US12464898

    申请日:2009-05-13

    IPC分类号: G06F12/00

    摘要: A first portion of an identifier can be used to assign the identifier to a slot in a first directory. The identifier can identify a cache unit in a cache. It can be determined whether assignment of the identifier to the slot in the first directory will result in the identifier and one or more other identifiers being assigned to the same slot in the first directory. If so, then the technique can include (1) using a second portion of the identifier to assign the identifier to a slot in a second directory; and (2) assigning the one or more other identifiers to one or more slots in the second directory. In addition, it can be determined whether a directory in a cache lookup data structure includes more than one pointer. If not, then a parent pointer that points to the subject directory can be removed.

    摘要翻译: 标识符的第一部分可以用于将标识符分配给第一目录中的时隙。 标识符可以识别高速缓存中的高速缓存单元。 可以确定是否将标识符分配给第一目录中的时隙将导致标识符,并且一个或多个其他标识符被分配给第一目录中的相同时隙。 如果是,则该技术可以包括(1)使用标识符的第二部分将标识符分配给第二目录中的时隙; 和(2)将一个或多个其他标识符分配给第二目录中的一个或多个时隙。 另外,可以确定高速缓存查找数据结构中的目录是否包括多于一个的指针。 如果没有,则可以删除指向主题目录的父指针。