×

System and method for improving database reorganization time

  • US 7,430,557 B1
  • Filed: 03/19/2003
  • Issued: 09/30/2008
  • Est. Priority Date: 03/19/2003
  • Status: Expired due to Term
First Claim
Patent Images

1. A system for effecting the reorganisation of a database in a computing system, comprising,(a) means for determining a plurality of operations necessary to effect the reorganisation of data elements in the database from one schema to another schema;

  • (b) means for estimating the completion time for each one of said plurality of operations, said means including;

    (b1) means for determining the number of data elements within the database;

    (b2) means for deriving a proportional relationship between the number of data elements that must be reorganised and the total time required to complete the operation; and

    (c) means for scheduling each one of said plurality of operations to be executed in the order of decreasing estimated completion time, so that the longer completion times are executed before the shorter completion times.

View all claims
  • 13 Assignments
Timeline View
Assignment View
    ×
    ×