利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

3 条记录 (耗时 0.057 秒)

    Computer program product for database relational extenders
    3.
    发明授权
    Computer program product for database relational extenders 失效
    用于数据库关系扩展器的计算机程序产品

    公开(公告)号：US6078925A

    公开(公告)日：2000-06-20

    申请号：US487988

    申请日：1995-06-07

    申请人： Matthew Paul Anderson ,  Siyi Terry Donn ,  David Couttie Fallside ,  Tri Quac Ha ,  Douglas Michael Hembry ,  Jean C. Ho ,  Jing-Song Jang ,  Nelson Mattos ,  Carlton Wayne Niblack ,  Dragutin Petkovic ,  Frank Chin Tung ,  Peter Paval Uhrowczik ,  Mimi Phuong-Thao Thi Vo ,  Gerald Johann Wilmot ,  Peter C. Yanker ,  Josephine Min-Kung Cheng

    发明人： Matthew Paul Anderson ,  Siyi Terry Donn ,  David Couttie Fallside ,  Tri Quac Ha ,  Douglas Michael Hembry ,  Jean C. Ho ,  Jing-Song Jang ,  Nelson Mattos ,  Carlton Wayne Niblack ,  Dragutin Petkovic ,  Frank Chin Tung ,  Peter Paval Uhrowczik ,  Mimi Phuong-Thao Thi Vo ,  Gerald Johann Wilmot ,  Peter C. Yanker ,  Josephine Min-Kung Cheng

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30595 ,  Y10S707/954 ,  Y10S707/961 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99943 ,  Y10S707/99944

    摘要： This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business, table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handle and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, a fifth table containing the names of the second and third tables for each object defined in the first table, a sixth table containing a reference to each object handle removed from the first table and including one column dedicated to containing a reference to the location of the object data associated with the removed object handle, and a seventh table having at least one column which describes a property of the data type of each object defined in the first table. The relational extender further includes an eighth table as a temporary holding table for the second table, and a ninth table as a temporary holding table for the third table. Both the eighth and ninth tables are used in conjunction with the extender triggers to ensure data integrity.

    摘要翻译： 本发明涉及用于基于计算机的关系数据库的关系扩展器。 每个关系扩展器包括至少一列，在包含用户定义的应用数据库的第一业务表中，专用于定义对象的复杂数据类型的对象句柄的至少一列; 第二属性表包含至少一列，定义与一个对象相关联的唯一特征，以及一列专用于包含对象句柄; 以及第三个元数据表，其包含至少一列，其定义与业务表中定义的所有对象相关联的共同特征，以及专用于包含对象句柄的专栏和至少一列专用于包含与该对象句柄相关联的对象数据的引用 目的。 关系扩展器还包括第四表，其包含对在第一表中定义的每个对象句柄列的引用，第五表包含在第一表中定义的每个对象的第二和第三表的名称，第六表包含引用 每个对象句柄从第一表中移除并且包括专用于包含与被移除的对象句柄相关联的对象数据的位置的引用的一列，以及具有描述每个对象句柄的数据类型的属性的至少一列的第七表 对象在第一个表中定义。 关系扩展器还包括作为第二表的临时保持表的第八表和作为第三表的临时保持表的第九表。 第八和第九表与扩展器触发器一起使用以确保数据完整性。