Patent ID: 8768966
Filing Date: 2014-07-01
Classification: G06F

Abstract:
1. A method for enforcing check-in and check-out policies in a database and automatically preventing out of process or simultaneous modification of a same database object in a shared database by more than one user during a database development stage comprising the steps of: a. providing one or more Data Definition Language (DDL) triggers to impose said enforcement of the check-in and check out policies and drive updates for each structural object of said database, which automatically execute in response to a DDL event, during any attempt to modify said database structural object; b. providing means for the users to request a modification permission to said database structural object by performing a check-out attempt; c. receiving a request from a user for modification permission with respect to a selected database structural object; d. automatically determining that the database object modification permission has not been granted to a second user who performed a check-out action but has not performed a check-in action yet and performing a check-out action to allow said user to modify said selected object causing a DDL event to commence automatically initiating a locking condition, using said one or more DDL triggers, with respect to said selected object by a control layer of said database upon detecting commencement of said event, whereby to block remaining users from performing modifications to said database structural object after imposing for said remaining users; e. a check-in action to thereby receive a termination notification for concluding the modification permission to said selected object, wherein said locking condition continues as long as said user has not concluded a modification operation; and f. upon conclusion of said modification operation, terminating said locking condition to enable one of said remaining users to perform a check-out action with respect to said selected object.