System and method for quiescing select data modification operations against an object of a database during one or more structural operations
First Claim
1. A method of reorganizing an object in a database file, the method comprising:
- reorganizing an original object by copying data of the original object to a reorganized object;
applying a first partial lock to the original object, the first partial lock configured to block select data modification operations against the original object;
substituting the reorganized object for the original object; and
applying a second partial lock to the reorganized object, the second partial lock configured to block select data modification operations to the reorganized object during said substituting.
0 Assignments
0 Petitions
Accused Products
Abstract
The invention is a reorganization system having a reorganization application, a database management system, and one or more database files. The reorganization application communicates with the database management system and the one or more database files to reorganize an object, such as, for example, a table or index, while providing one or more clients substantially continuous access to the object. The reorganization application employs one or more trigger locks to synchronize the data in an original table and a reorganized table. The one or more trigger locks block select data modification operations while allowing one or more read-only operations and structural modification operations.
107 Citations
20 Claims
-
1. A method of reorganizing an object in a database file, the method comprising:
-
reorganizing an original object by copying data of the original object to a reorganized object;
applying a first partial lock to the original object, the first partial lock configured to block select data modification operations against the original object;
substituting the reorganized object for the original object; and
applying a second partial lock to the reorganized object, the second partial lock configured to block select data modification operations to the reorganized object during said substituting. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer-executable software program for a database system, the software program comprising:
-
first software instructions capable of reorganizing an original object of a database by copying data of the original object to a reorganized object;
second software instructions capable of applying a first partial lock to the original object, the first partial lock configured to block select data modification operations against the original object;
third software instructions capable of substituting the reorganized object for the original object; and
fourth software instructions capable of applying a second partial lock to the reorganized object, the second partial lock configured to block select data modification operations to the reorganized object during said substitution of the reorganized object for the original object. - View Dependent Claims (10, 11, 12, 13, 14)
-
-
15. A method of reorganizing a database object, the method comprising:
-
reorganizing an original object by copying data from the original object to a reorganized object;
applying a partial lock to at least one of the original object and the reorganized object, the partial lock blocking data modification operations from modifying the at least one of the original object and the reorganized object while allowing other operations to access the at least one of the original object and the reorganized object; and
substituting the reorganized object for the original object such that the reorganized object remains readable while substituting the reorganized object for the original object. - View Dependent Claims (16, 17)
-
-
18. A reorganization system comprising:
-
means for reorganizing an original object by copying data of the original object to a reorganized object;
means for blocking select data modification operations against the original object while allowing other operations against the original object during reorganization; and
means for blocking select data modification operations against the reorganized object during substitution of the reorganized object for the original object. - View Dependent Claims (19, 20)
-
Specification