Relational database extenders for handling complex data types
First Claim
1. A computer-readable storage medium storing a relational extender for a computer-based relational database, the relational extender providing the relational database with access to object data, comprising:
- a first table having a user defined application database, and at least one column dedicated to an object handle created by the user for defining the complex data type of an object;
a second table containing at least one column defining a unique characteristic associated with said one object and one column dedicated to containing said object handle;
a third table containing at least one column defining a common characteristic associated with all objects defined within said first table and one column dedicated to containing said object handle and at least one column dedicated to containing a reference to object data associated with said object;
a fourth table storing each object handle and its associated complex data type as defined in said first table; and
a fifth table containing the names of said second and third tables for each object defined in said first table.
1 Assignment
0 Petitions
Accused Products
Abstract
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, and a fifth table containing the names of the second and third tables for each object defined in the first table.
-
Citations
3 Claims
-
1. A computer-readable storage medium storing a relational extender for a computer-based relational database, the relational extender providing the relational database with access to object data, comprising:
-
a first table having a user defined application database, and at least one column dedicated to an object handle created by the user for defining the complex data type of an object; a second table containing at least one column defining a unique characteristic associated with said one object and one column dedicated to containing said object handle; a third table containing at least one column defining a common characteristic associated with all objects defined within said first table and one column dedicated to containing said object handle and at least one column dedicated to containing a reference to object data associated with said object; a fourth table storing each object handle and its associated complex data type as defined in said first table; and a fifth table containing the names of said second and third tables for each object defined in said first table. - View Dependent Claims (2, 3)
-
Specification