UNIQUE ATTRIBUTE CONSTRAINTS FOR VERSIONED DATABASE OBJECTS
First Claim
1. A computer-implemented method including executing, using at least one processor, instructions recorded on a non-transitory computer-readable storage medium, the method comprising:
- receiving a request to insert, in a main database table, a versioned database object having a first identifier (ID);
determining whether uniqueness of a first subset of attributes of the versioned database object versus other versioned database objects in the main database table having different IDs than the first ID is required; and
in the event it is determined that uniqueness of the first subset of attributes is required, evaluating uniqueness of the first subset of attributes of the versioned database object with the first ID as compared to the other versioned database objects based on respective records for the other versioned database objects stored in a secondary database table.
11 Assignments
0 Petitions
Accused Products
Abstract
Methods and apparatus for ensuring uniqueness of database object attributes are disclosed. An example computer-implemented method includes receiving a request to insert, update or delete a versioned database object having a first identifier (ID) in a main database table. The method further includes determining, based on the request, whether to fire an insert trigger, a delete trigger or an update trigger for the main database table. In the event an insert trigger is fired, the method includes performing, in a secondary database table, a record insertion process. In the event a delete trigger is fired, the method includes performing, in the secondary database table, a record deletion process. In the event an update trigger is fired, the method includes performing, in the secondary database table, at least one of the record insertion process for a post-update versioned database object and the record deletion process for a pre-update versioned database object.
-
Citations
25 Claims
-
1. A computer-implemented method including executing, using at least one processor, instructions recorded on a non-transitory computer-readable storage medium, the method comprising:
-
receiving a request to insert, in a main database table, a versioned database object having a first identifier (ID); determining whether uniqueness of a first subset of attributes of the versioned database object versus other versioned database objects in the main database table having different IDs than the first ID is required; and in the event it is determined that uniqueness of the first subset of attributes is required, evaluating uniqueness of the first subset of attributes of the versioned database object with the first ID as compared to the other versioned database objects based on respective records for the other versioned database objects stored in a secondary database table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer-implemented method including executing, using at least one processor, instructions recorded on a non-transitory computer-readable storage medium, the method comprising:
-
receiving a request to delete, from a main database table, a versioned database object having a first identifier (ID); determining whether uniqueness of a first subset of attributes of the versioned database object versus other versioned database objects in the main database table having different IDs than the first ID is required; and in the event it is determined that uniqueness of the first subset of attributes is required, updating or deleting a record corresponding with the versioned database object with the first ID in a secondary database table. - View Dependent Claims (10, 11, 12)
-
-
13. A computer-implemented method including executing, using at least one processor, instructions recorded on a non-transitory computer-readable storage medium, the method comprising:
-
receiving a request to update, in a main database table, a versioned database object having a first identifier (ID) from a pre-update versioned database object to a post-update versioned database object; determining whether to fire an update trigger for the main database table based on uniqueness requirements for respective, analogous first subsets of attributes of the pre-update versioned database object and the post-update versioned database object; and in the event that a determination to fire the update trigger is made, performing, in a secondary database table, at least one of; a delete process for a record corresponding with the pre-update versioned database object; and an insert process for a record corresponding with the post-update versioned database object. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 21, 22, 23)
-
-
24. A computer-implemented method including executing, using at least one processor, instructions recorded on a non-transitory computer-readable storage medium, the method comprising:
-
receiving a request to insert, update or delete a versioned database object having a first identifier (ID) in a main database table; determining, based on the request, whether to fire an insert trigger, a delete trigger or an update trigger for the main database table; in the event an insert trigger is fired, performing, in a secondary database table, a record insertion process for the versioned database object; in the event a delete trigger is fired, performing, in the secondary database table, a record deletion process for the versioned database object; and in the event an update trigger is fired, performing, in the secondary database table, at least one of; the record insertion process for a post-update versioned database object; and the record deletion process for a pre-update versioned database object.
-
-
25. A non-transitory computer-readable storage medium having instructions stored thereon that, when executed by one or more processors, cause a computing device to:
-
receive a request to insert, update or delete a versioned database object having a first identifier (ID) in a main database table; determine, based on the request, whether to fire an insert trigger, a delete trigger or an update trigger for the main database table; in the event an insert trigger is fired, perform, in a secondary database table, a record insertion process for the versioned database object; in the event a delete trigger is fired, perform, in the secondary database table, a record deletion process for the versioned database object; and in the event an update trigger is fired, perform, in the secondary database table, at least one of; the record insertion process for a post-update versioned database object; and the record deletion process for a pre-update versioned database object.
-
Specification