Object views for relational data
    1.
    发明授权
    Object views for relational data 失效
    关系数据的对象视图

    公开(公告)号:US6108664A

    公开(公告)日:2000-08-22

    申请号:US962415

    申请日:1997-10-31

    IPC分类号: G06F17/30

    摘要: A method and apparatus for presenting and modifying data from a set of tables in a database is provided. A view that is defined is based on a set of one or more tables that may include relational tables or object tables. The view defines a presentation of data from the one or more tables as a set of objects that reside in the database. Data is read from the one or more rows of the tables based on the view, and is presented as a set of objects that reside in the database. An object id that is based on data from the one or more rows is generated and associated with each object presented. The view may specify which columns from the one or more tables contain values used to generate the object ids. A trigger may associated with the view. The set of objects presented may be presented as objects having an attribute that is a column object. Column objects include user specified object types, collection objects (e.g. nested tables and variable arrays), or references to objects.

    摘要翻译: 提供了一种用于从数据库中的一组表格呈现和修改数据的方法和装置。 定义的视图基于可以包括关系表或对象表的一组或多个表的集合。 该视图将来自一个或多个表的数据的呈现定义为驻留在数据库中的一组对象。 基于视图从表的一行或多行中读取数据,并将其呈现为驻留在数据库中的一组对象。 基于来自一行或多行的数据的对象id被生成并且与呈现的每个对象相关联。 视图可以指定一个或多个表中的哪些列包含用于生成对象ID的值。 触发器可能与视图相关联。 所呈现的对象集可以被呈现为具有作为列对象的属性的对象。 列对象包括用户指定的对象类型,集合对象(例如嵌套表和变量数组)或对象的引用。

    Performing operations on objects in a database system in a response to a request that specifies references that indicate where the objects reside
    2.
    发明授权
    Performing operations on objects in a database system in a response to a request that specifies references that indicate where the objects reside 有权
    对数据库系统中的对象执行操作,以响应指定引用的请求,该引用指示对象所在的位置

    公开(公告)号:US06266673B1

    公开(公告)日:2001-07-24

    申请号:US09589601

    申请日:2000-06-07

    IPC分类号: G06F1730

    摘要: A mechanism is described for processing requests to specify operations to database objects. A request to perform an action on a set of multiple objects is received by a database system. The request includes references to each object in the set, each reference indicating a table where the respective object resides. The reference is used to locate the object, and once located, the action is performed on the object. The reference may indicate a table using a unique table id not used in any of a plurality of databases to identify a table. The action request may be to modify the object, the references may include references to objects that reside in different database systems.

    摘要翻译: 描述了一种用于处理对数据库对象指定操作的请求的机制。 数据库系统接收到对一组多个对象执行操作的请求。 请求包括对集合中每个对象的引用,每个引用指示相应对象所在的表。 该引用用于定位对象,一旦找到,对对象执行操作。 参考可以指示使用在多个数据库中的任何一个中未使用的唯一表id来标识表的表。 动作请求可以是修改对象,引用可以包括对驻留在不同数据库系统中的对象的引用。

    References that indicate where global database objects reside
    3.
    发明授权
    References that indicate where global database objects reside 失效
    指示全局数据库对象所在的引用

    公开(公告)号:US06134558A

    公开(公告)日:2000-10-17

    申请号:US961740

    申请日:1997-10-31

    IPC分类号: G06F17/30

    摘要: A method and apparatus for generating references to a set of objects which reside in a plurality databases is described. Each object is associated with a table from a plurality of tables that are contained in the plurality of databases. An object id is associated with each object; the object id uniquely identifies the object relative to the objects in the set of objects. A table id is associated with each table; the table id uniquely identifies the table relative to tables in the plurality of tables. A table containing an object is located based on the table id associated with the table, and the object is located in the table based on the object id associated with the object. A table mapping is generated. The table mapping maps a set of tables to databases associated with the set of tables. The set of tables are from the plurality of tables. References to objects from the set of object are generated. Each reference comprises data that identifies an object. The reference contains data representing the object id of the referenced object, the object referred to by the reference. The reference also contains data representing the table id of the table containing the referenced object. An object is located based on the table mapping and the reference referring to the object. The table containing the object is located based on the data in the reference, the data representing the table id associated with the table containing the object.

    摘要翻译: 描述了一种生成对驻留在多个数据库中的一组对象的引用的方法和装置。 每个对象与来自多个数据库中包含的多个表的表相关联。 对象id与每个对象相关联; 对象id唯一地标识相对于对象集合中的对象的对象。 表id与每个表相关联; 表id唯一地标识相对于多个表中的表的表。 包含对象的表基于与表相关联的表id来定位,并且该对象位于表中,基于与对象相关联的对象id。 生成表映射。 表映射将一组表映射到与该组表相关联的数据库。 表的集合来自多个表。 生成来自该对象对象的引用。 每个引用包括标识对象的数据。 引用包含表示引用对象的对象标识的数据,引用对象所引用的对象。 该引用还包含表示包含引用对象的表的表id的数据。 基于表映射和引用对象的引用来定位对象。 包含对象的表根据引用中的数据定位,表示与包含对象的表相关联的表id的数据。

    Method and apparatus for locating a first set of data using a global
identifier and a virtual addressing data structure
    5.
    发明授权
    Method and apparatus for locating a first set of data using a global identifier and a virtual addressing data structure 失效
    用于使用全局标识符和虚拟寻址数据结构定位第一组数据的方法和装置

    公开(公告)号:US5887275A

    公开(公告)日:1999-03-23

    申请号:US598517

    申请日:1996-02-08

    IPC分类号: G06F12/10 G06F12/08

    CPC分类号: G06F12/10

    摘要: A method and apparatus are provided for locating a object based on a reference to the object. An application determines whether the reference has previously been used to locate the object. If the reference has previously been used to locate the object, then a data structure referred to as a "tombstone" that has been associated with the object is located based on a first virtual memory address that is stored in the reference. Once the tombstone has been located, a first pseudo-timestamp that is stored in the reference is compared to a second pseudo-timestamp that is stored in the tombstone. If the first pseudo-timestamp matches the second pseudo-timestamp, then the object is located based on a second virtual memory address that is stored in the tombstone. If the first pseudo-timestamp does not match the second pseudo-timestamp or if the reference has not been previously used to locate the object, then the object is located based on the identifier stored in the reference. During the process of locating the object based on the object identifier, the virtual address of the tombstone associated with the object is stored in the reference, and the pseudo-timestamp stored in the tombstone is stored in the reference. When tombstones are reused, the pseudo-timestamp within the tombstone is incremented.

    摘要翻译: 提供了一种基于对象的引用来定位对象的方法和装置。 应用程序确定引用是否以前已被用于定位对象。 如果先前已经使用引用来定位对象,则基于存储在引用中的第一虚拟存储器地址来定位被称为与对象相关联的“墓碑”的数据结构。 一旦找到了墓碑,将存储在引用中的第一伪时间戳与存储在墓碑中的第二伪时间戳进行比较。 如果第一伪时间戳匹配第二伪时间戳,则基于存储在墓碑中的第二虚拟存储器地址来定位对象。 如果第一伪时间戳与第二伪时间戳不匹配,或者如果引用还没有用于定位对象,则基于存储在引用中的标识符来定位对象。 在基于对象标识符定位对象的过程中,将与该对象相关联的墓碑的虚拟地址存储在引用中,存储在该墓碑中的伪时间戳存储在引用中。 当墓碑被重新使用时,墓碑中的伪时间戳增加。

    Method and apparatus for interprocess communications in a database
environment
    9.
    发明授权
    Method and apparatus for interprocess communications in a database environment 失效
    数据库环境中进程间通信的方法和装置

    公开(公告)号:US5787300A

    公开(公告)日:1998-07-28

    申请号:US584910

    申请日:1996-01-11

    申请人: Joyo Wijaya

    发明人: Joyo Wijaya

    IPC分类号: G06F9/46 G06F13/00

    CPC分类号: G06F9/544

    摘要: The present invention provides interprocess communication in a DBMS. The present invention provides the ability for these processes to communicate with other DBMS processes or processes external to the DBMS. A pipe is implemented as an object of the general purpose object cache. The general purpose object cache resides in the systems shared memory space. It is concurrently accessible by many sessions, or processes. A pipe is located in a shared global memory area. The present invention provides the ability to send a message (i.e., record) to a pipe, and receive a message (i.e., record) from a pipe. A pipe is located in shared memory. Shared memory can contain multiple pipes. Each pipe is comprised of a linked list of records, and linked list of sessions, an exclusivity indicator, and a session waiting indicator. Multiple sessions can access the same pipe, and each pipe can contain multiple messages. A message is sent by a sending session to a local buffer. The contents of the local buffer is sent to a pipe. The contents of a pipe, one or more records, can be accessed by getting a record from the pipe and placing it in a local buffer. The contents of the local buffer can be accessed by the requesting session.

    摘要翻译: 本发明提供了一种DBMS中的进程间通信。 本发明提供了这些进程与DBMS外部的其他DBMS进程或进程通信的能力。 管道被实现为通用对象缓存的对象。 通用对象缓存驻留在系统共享内存空间中。 它可以通过许多会话或进程同时访问。 管道位于共享的全局存储区域中。 本发明提供了向管道发送消息(即,记录)并从管道接收消息(即,记录)的能力。 管道位于共享内存中。 共享内存可以包含多个管道。 每个管道由链接的记录列表,链接的会话列表,排他性指标和会话等待指示符组成。 多个会话可以访问相同的管道,每个管道可以包含多个消息。 消息由发送会话发送到本地缓冲区。 本地缓冲区的内容被发送到管道。 可以通过从管道获取记录并将其放在本地缓冲区中来访问管道的内容,一个或多个记录。 本地缓冲区的内容可以由请求会话访问。