Patent ID: 7054862
Filing Date: 2006-05-30
Classification: G06F,Y10S

Abstract:
1. A method for allowing update and edit control over an extended time period in a database system, the method comprising: defining library control functions in a database system, including providing a checkout function to lock at least one cell in a managed database table of the database system; wherein defining library control functions further comprises creating a set of update and delete triggers in correspondence with the checkout function, wherein defining library control functions further comprises creating a set of control tables for each selected table that contains columns enabled for control under the library control functions; and utilizing the library control functions via structured query language statements to ensure data integrity during accessing of complex data objects comprising opaque data types in the database system, wherein utilizing the library control functions further comprises utilizing the set of control tables to designate a primary key, the primary key being based on an identity of a user accessing data as well as a column name of the data being accessed, further comprising utilizing the primary key as an edit control mechanism for a checked-out cell until an update occurs by the user.