Patent ID: 6119128
Filing Date: 2000-09-12
Classification: G06F,Y10S

Abstract:
A method of restoring a database in a computer, the database containing objects and being stored on a primary data storage device connected to the computer, the method comprising the steps of:copying objects of different types in the database from the primary data storage device to a secondary data storage device, wherein one of the objects is a table index for locating data in a table, and wherein one of the objects is a partitioning index for defining a scope of each partition and thereby assigning a row of the table to its respective partition;logging modifications to the objects, including the table index and the partitioning index, in a log file;receiving a recovery indicator indicating that recovery of the objects in the database is required;copying the objects, including the table index and the partitioning index, from the secondary data storage device to the database on the primary data storage device; andapplying the modifications in the log file to the copied objects, including the table index and the partitioning index, during one pass through the log file.