Patent ID: 8521789
Filing Date: 2013-08-27
Classification: G06F

Abstract:
1. A method of processing an undrop operation in a relational database system, comprising: receiving a command to drop a first object in a relational database; associating the first object with a schema to uniquely identify the first object; moving the first object to a recycle bin; based on determining that at least a second object depends on the first object, moving the second object to the recycle bin subsequent to moving the first object to the recycle bin; purging at least a portion of the second object from the recycle bin, the second object being purged before the first object; upon receiving a command to undrop the first object, moving at least the first object out of the recycle bin; in response to the command to undrop, reconstructing the second object on determining that the second object was built by using data in the first object and on determining that the second object has been purged from the recycle bin; and using the schema to restore at least the first object and the second object to the relational database without shutting down the relational database in responding to the command to undrop; wherein the method is performed by one or more processors.