Patent Number: 7,085,786

Title: Apparatus and method to schedule and perform database maintenance

Abstract: A method to schedule and perform database maintenance, where the database includes information regarding one or more information storage media moveably disposed in a data storage and retrieval system, which includes selecting a first time period, commencing that first time period at a first time and ending that first time period at a third time, performing one or more database queries during that first time period, recording the number of database queries performed during each of the two or more first time intervals, determining the least utilized first time interval where that least utilized first time interval commenced at a second time, calculating a first time difference between the first time and the second time, and scheduling database maintenance at a fourth time. A data storage and retrieval system comprising a computer useable medium having computer readable program code disposed therein to implement Applicants' method to schedule and perform database maintenance. A computer program product usable with a programmable computer processor having computer readable program code embodied therein to implement Applicants' method to schedule and perform database maintenance.

Inventors: Carlson; Wayne Charles (Tucson, AZ), Fisher; James Arthur (Tucson, AZ), Shotwell; Kerri Renee (Tucson, AZ)

Assignee: International Business Machines Corporation

International Classification: G06F 17/30 (20060101)

Expiration Date: 8/01/02018