RELATIONAL DATABASE WITH COMPOUND IDENTIFIER
First Claim
1. A relational database system, comprising:
- a relational database configured to store and present data in a plurality of tables; and
a database application operatively coupled with the relational database and configured to execute in an intermediate language runtime environment that supports native treatment of user data type definitions, where the database application and the relational database are configured to populate the plurality of tables with records that are each uniquely identified by a key, and where for each of the records, the key is constructed in accordance with a compound user-defined data type, such that the key includes;
identification of an originating table for that record, the originating table being one of the plurality of tables; and
additional record-identifying information for that record.
2 Assignments
0 Petitions
Accused Products
Abstract
A relational database system. The system includes a relational database configured to store and present data in a plurality of tables and a database application operatively coupled with the relational database. The system is configured to execute in an intermediate language runtime environment that supports native treatment of user data type definitions, and the database application and the relational database are configured to populate the plurality of tables with records that are each uniquely identified by a key. For each record, the key is constructed in accordance with a compound user-defined data type, such that the key includes: identification of an originating table and additional record-identifying information for the record.
-
Citations
20 Claims
-
1. A relational database system, comprising:
-
a relational database configured to store and present data in a plurality of tables; and a database application operatively coupled with the relational database and configured to execute in an intermediate language runtime environment that supports native treatment of user data type definitions, where the database application and the relational database are configured to populate the plurality of tables with records that are each uniquely identified by a key, and where for each of the records, the key is constructed in accordance with a compound user-defined data type, such that the key includes;
identification of an originating table for that record, the originating table being one of the plurality of tables; and
additional record-identifying information for that record. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method of creating and handling data in a relational database, comprising:
-
defining a compound user-defined data type; establishing a plurality of tables in the relational database for storing and presenting data; populating the plurality of tables with a plurality of records, where for each of the plurality of records, said populating includes;
inserting an additional row into one of the plurality of tables, said additional row containing data pertaining to that record;using the compound user-defined data type to generate a key which uniquely identifies that record and uniquely identifies the one of the plurality of tables; and persisting the keys for the plurality of records into a database API that is executable and configured for use within an intermediate language runtime environment that supports native treatment of the compound user-defined data type. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A method of creating and handling data in a relational database, comprising:
-
establishing a plurality of tables in the relational database for storing and presenting data; adding a record to one of the plurality of tables in the form of an additional row to the table; generating a table identifier for the table to which the record is added; generating a row identifier for the additional row corresponding to the record; using a compound user-defined data type to combine the table identifier and the row identifier into a key which uniquely identifies the record; and retrieving the record from the table by providing the key to a database API executed and configured for use within an intermediate language runtime environment that supports native treatment of the compound user-defined data type. - View Dependent Claims (18, 19, 20)
-
Specification