Method for reorganizing a set of database partitions

Details Method for reorganizing a set of database partitions Method for reorganizing a set of database partitions

2005-12-20

2008-11-18

Alam, Shahid Al (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C715S968000

Reexamination Certificate

active

07454449

ABSTRACT:
A method is disclosed for reorganizing a set of database partitions based on a ranked set of database partitions. The method includes a step to determine a fragmentation indicator for each database partition within a set of database partitions. A step ranks the set of database partitions according to a rank criteria. The rank criteria includes, at a minimum, the fragmentation indicator. A step reorganizes a subset of the database partitions in the ranked set of database partitions. The subset is selected, at least in part, by a rank order for the ranked set of database partitions. The subset may be selected such that ranked database partitions satisfying a reorganization threshold are included in the subset.

REFERENCES:
patent: 5721915 (1998-02-01), Sockut et al.
patent: 5758144 (1998-05-01), Eberhard et al.
patent: 5832491 (1998-11-01), Tatsumi et al.
patent: 5903757 (1999-05-01), Gretz et al.
patent: 5991761 (1999-11-01), Mahoney et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6553383 (2003-04-01), Martin
patent: 2002/0143763 (2002-10-01), Martin et al.
patent: 2005/0165713 (2005-07-01), Lafforet
IMS/VS Data Base Tool, Data Entry Data Base Tuning Aid User's Guide Release 1.0 (Program No. 5668-856; Document No. SH20-6590-0; First Edition: Mar. 1985), pp. 6-7, 16-21, 27-32, 38.
IMS/VS Data Base Tool, Data Entry Base Pointer Checker User's Guide Release 1.0 (Program No. 5668-856, Document No. SH20-6584-0; First Edition: Mar. 1985), pp. 2, 5-6, 14, 16, 29-31, 37-41, 47-52, 59-77, 84, 88-89, 91-93.
Paolo Bruni et al.:DB2 for z/OS and OS/390 Version 7 Performance Topics,IBM ITSO Redbook, SG24-6129-00, Jul. 2001 (http://www.redbooks.ibm.com/abstracts/sg246129.html), Section: 6.6.4 Performance considerations using new statistics columns (pp. 141-146).
Paolo Bruni et al.: DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite, IBM ITSO Redbook, SG24-6289-00, Aug. 2001 (http://www.redbooks.ibm.com/abstracts/sg246289.html), Chapter 7, pp. 162-163, pp. 161-190.
“An Approach to Self-Adaptive, On-Line Reclustering of Complex Object Data,” William James McIver, Jr., Section 2.4, Chapters 3 and 4.
“Self-adaptive, on-line reclustering of complex object data,” William J. McIver et al., all pages.

Affiliated with

Also associated with

Rating

Method for reorganizing a set of database partitions does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for reorganizing a set of database partitions, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for reorganizing a set of database partitions will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4033901