Quest Software Inc.

Ross Doering

William James Romine

Eyal Aronoff

Thomas Pugh

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.

Systems and methods for reorganizing a database object

System and method for quiescing select data modification operations against an object of a database during one or more structural operations

The invention is a reorganization planning system having a reorganization planner, a database management system, and one or more database files. The reorganization planner communicates with the database management system and the one or more database files to develop a reorganization plan for reorganizing one or more objects of the database files. According to various embodiments, the reorganization planner also provides for in-place object reorganization and application of a benefit threshold. The benefit threshold limits the number of objects recommended for reorganization.

Growing community of inventors

Aliso Viejo, CA, United States of America

Ross Doering