Back to results
US 8,521,789 B2Granted
Undrop objects and dependent objects in a database system
AssigneeOracle International Corporation
InventorVineet Marwah
Life of this patent
Estimating the term…
Abstract
Techniques for undropping objects (e.g., tables) and dependent objects in a database systems are provided. When an object is dropped, the object is moved to a recycle bin where it resides until the user undrops the objects or the object is purged. Dependent objects are also moved into the recycle bin with the object to which they depend. The object can be purged from the recycle bin explicitly by a user or when more storage space is needed. Purging of dependent objects and partitions can be deferred if not required to obtain more storage space.
Claims33
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.
7 more elements
One or more non-transitory computer-readable storage media storing software that allows undrop in a relational database system, comprising:
- computer code to receive a command to drop a first object in a relational database;
- computer code to associate the first object with a schema to uniquely identify the first object;
- computer code to move the first object to a recycle bin;
- computer code, responsive to a determination that at least a second object depends on the first object, to move the second object to the recycle bin subsequent to moving the first object to the recycle bin;
- computer code to purge at least a portion of the second object from the recycle bin so that the second object is purged before the first object;
- computer code, responsive to a command to undrop the first object, to move at least the first object out of the recycle bin;
- computer code, responsive to the command to undrop, to reconstruct the second object based on determination that the second object was built by using data in the first object and based on determination that the second object has been purged from the recycle bin;
- and
- computer code to use the schema to restore at least the first object and the second object to the relational database without shutting down the relational database during restoration.
6 more elements
A relational database system comprising:
- one or more non-transitory computer-readable storage media comprising a relational database that stores information in tables and includes a table implementing a recycle bin that indicates objects that have been dropped;
- one or more processors to execute instructions, the instructions comprising:
- computer code, responsive to a command to drop a first object in the relational database, to associate the first object with a schema to uniquely identify the first object;
- computer code, to move the first object to a recycle bin;
- computer code, responsive to a determination that at least a second object depends on the first object, to move the second object to the recycle bin subsequent to moving the first object to the recycle bin;
- computer code to purge at least a portion of the second object from the recycle bin, the second object being purged before the first object;
- computer code, responsive to a command to undrop the first object, to move at least the first object out of the recycle bin;
- computer code, responsive to the command to undrop, to reconstruct 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
- computer code to use 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.
7 more elements
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 at least that a second object is related to the first object, moving the second object to the recycle bin;
- purging at least the second object from the recycle bin;
- and
- upon receiving a command to undrop the first object, moving the first object out of the recycle bin, reconstructing at least the second object using at least the first object, based on determining that the second object is reconstructable and based on determining that the second object is purged from the recycle bin, and using the schema to restore the first object and the second object to the relational database without shutting down the relational database during restoration:
- wherein the method is performed by one or more processors.
5 more elements
One or more non-transitory computer-readable storage media storing software that allows undrop in a relational database system, comprising:
- computer code to receive a command to drop a first object in a relational database;
- computer code to associate the first object with a schema to uniquely identify the first object;
- computer code to move the first object to a recycle bin;
- computer code, responsive to a determination at least that a second object is related to the first object, to move the second object to the recycle bin;
- computer code to purge at least a portion of the second object from the recycle bin;
- and
- computer code, responsive to a command to undrop the first object, to move the first object out of the recycle bin, reconstruct at least the second object using at least the first object, based on determination that the second object is reconstructable and based on determination that the second object is purged from the recycle bin, and use the schema to restore the first object and the second object to the relational database without shutting down the relational database during restoration.
4 more elements
A relational database system, comprising:
- one or more non-transitory computer-readable storage media comprising a relational database that stores information in tables and includes a table implementing a recycle bin;
- one or more processors to execute instructions, the instructions comprising:
- computer code to receive a command to drop a first object in a relational database;
- computer code to associate the first object with a schema to uniquely identify the first object;
- computer code to move the first object to a recycle bin;
- computer code responsive to a determination at least that a second object is related the first object, to move the second object to the recycle bin;
- computer code to purge at least the second object from the recycle bin;
- and
- computer code, responsive to a command to undrop the first object, to move the first object out of the recycle bin, reconstruct at least the second object, using at least the first object, based on determination that the second object is reconstructable and based on determination that the second object is purged from the recycle bin, and use the schema to restore the first object and the second object to the relational database without shutting down the relational database during restoration.
6 more elements
A method of processing an undrop operation in a relational database system, the method comprising:
- receiving a command to drop a first object in a relational database;
- marking the first object as dropped without purging the first object;
- based on at least determining that there is a second object related to the first object, marking the second object as dropped;
- purging at least a portion of the second object from the relational database;
- and
- upon receiving a command to undrop the first object after the portion of the second object is purged, reconstructing the second object using at least the first object, based on determining that the second object is reconstructable, and restoring, using a schema, 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 schema uniquely identifies at least the first object;
- and
- wherein the method is performed by one or more processors.
6 more elements
One or more non-transitory computer-readable storage media storing software that allows undrop in a relational database system, comprising:
- computer code that receives a command to drop a first object in a relational database;
- computer code that marks the first object as dropped without purging the first object;
- computer code that, based on at least determining that there is a second object related to the first object, marks the second object as dropped;
- computer code to purge at least a portion of the second object from the relational database;
- and
- computer code, responsive to receiving a command to undrop the first object after the portion of the second object is purged, to reconstruct the second object using at least the first object, based on determining that the second object is reconstructable, and to restore, using a schema, 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 schema uniquely identifies at least the first object.
4 more elements
A relational database system comprising:
- one or more non-transitory computer-readable storage media comprising a relational database that stores information in tables;
- one or more processors to execute instructions, the instructions comprising:
- computer code that receives a command to drop a first object in the relational database;
- computer code that marks the first object as dropped without purging the first object;
- computer code that, based on at least determining that there is a second object related to the first object, marks the second object as dropped;
- computer code to purge at least a portion of the second object from the relational database;
- and
- computer code, responsive to receiving a command to undrop the first object after the portion of the second object is purged, to reconstruct the second object using at least the first object, based on determining that the second object is reconstructable, and to restore, using a schema, 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 schema uniquely identifies at least the first object.
6 more elements
Dependencies are inferred from the claim text.