Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2003-02-13
2004-07-20
Corrielus, Jean M. (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
06766318
ABSTRACT:
FIELD OF THE INVENTION
The present invention relates to information systems, and more specifically, to an approach for performing administrative functions in information systems.
BACKGROUND OF THE INVENTION
Information systems, and in particular database systems, routinely perform a variety of administrative functions to maintain their orderliness and efficiency. Examples of administrative functions include creating and updating data structures and indexes, backing up and archiving data and collecting statistical information about stored data. An administrative function includes a set of one or more administrative steps. The steps are an ordered sequence of tasks which are performed to complete the administrative function. Administrative functions such as these are sometimes collectively referred to as “housekeeping” functions.
Performing administrative functions consumes system resources and time which can interfere with other processing. This problem is exacerbated in information systems containing large amounts of data, e.g. warehousing systems and large database systems, since the amount of system resources and time attributable to performing administrative functions, such as updating indexes and gathering statistical information, usually increases as the amount of data increases.
Administrative functions are often performed during scheduled system “down times” or during times of minimal user activity to reduce interference with online user processing. However, administrative functions that are initiated during down times cannot always be completed during the allocated time period. When administrative functions cannot be completed during the allocated time period, either the administrative functions must be allowed to continue until they have completed, or be prematurely terminated. Allowing administrative functions to continue beyond scheduled down times can interfere with other time critical processing. On the other hand, prematurely terminating administrative functions can be problematic because administrative functions traditionally cannot be stopped and restarted at a later time since the data that the administrative functions operated on may change before the next scheduled down time. As a result, prematurely terminated administrative functions must be completely re-executed at a later time.
Another approach for performing administrative functions is for a system operator (SYSOP) to manually select a particular set of administrative steps of the function to be performed during an allocated time period. Whether administrative functions can be completed within scheduled down times depends upon the ability of the SYSOP to select particular administrative steps of the function that can be completed during the allocated time period. Since it can be difficult to predict the amount of time that is required to perform a particular administrative step, it can be difficult for the SYSOP to estimate the amount of time that will be required to complete a set of administrative steps.
Sometimes a SYSOP underestimates the amount of time that will be required to perform a particular administrative function and the particular administrative function must be prematurely terminated and completely re-executed at another scheduled down time. Other times a SYSOP overestimates the amount of time that will be required to perform a particular administrative function and the particular administrative function is completed earlier than expected, resulting in unused down time. One solution to this problem is for a SYSOP to manually break down an administrative function into steps and partially complete the steps within the allocated time period. However, this can require a large amount of labor and still relies upon the judgment of the SYSOP to complete tasks within the allocated time period.
Based on the need to perform administrative functions in information systems and the limitations in the prior approaches, an approach for efficiently performing administrative functions in information systems during scheduled down times is highly desirable.
REFERENCES:
patent: 5325292 (1994-06-01), Crockett
patent: 5625820 (1997-04-01), Hermsmeier et al.
patent: 5778350 (1998-07-01), Adams et al.
patent: 5873091 (1999-02-01), Garth et al.
patent: 5899986 (1999-05-01), Ziauddin
patent: 5940832 (1999-08-01), Hamada et al.
patent: 5991733 (1999-11-01), Aleia et al.
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6035306 (2000-03-01), Lowenthal et al.
patent: 6070160 (2000-05-01), Geary
patent: 6085191 (2000-07-01), Fisher et al.
patent: 6122664 (2000-09-01), Boukobza et al.
patent: 6173154 (2001-01-01), Kucinski et al.
patent: 6189022 (2001-02-01), Binns
patent: 6195676 (2001-02-01), Spix et al.
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 6321218 (2001-11-01), Guay et al.
patent: 6356880 (2002-03-01), Goossens et al.
patent: 6370522 (2002-04-01), Agarwal et al.
patent: 6377943 (2002-04-01), Jakobsson
patent: 6389430 (2002-05-01), Parker
patent: 6470330 (2002-10-01), Das et al.
patent: 6539371 (2003-03-01), Bleizeffer et al.
patent: 6553369 (2003-04-01), Guay et al.
patent: 6564207 (2003-05-01), Abdoh
Feng Yong
Guay Todd
Rossiter Jay
Shah Vipul
Soule Jonathan
Becker Edward A.
Corrielus Jean M.
Hickman Palermo & Truong & Becker LLP
Ly Anh
Oracle International Corporation
LandOfFree
Approach for collecting statistical information in... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Approach for collecting statistical information in..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Approach for collecting statistical information in... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3234060