Data processing: database and file management or data structures – Data integrity – Fragmentation – compaction and compression
Reexamination Certificate
2008-10-07
2011-12-27
Breene, John E (Department: 2162)
Data processing: database and file management or data structures
Data integrity
Fragmentation, compaction and compression
C707S748000, C707S968000, C707S972000
Reexamination Certificate
active
08086576
ABSTRACT:
An apparatus and system are disclosed for reorganizing a set of database partitions based on a ranked set of database partitions. The apparatus includes an evaluation module to determine a fragmentation indicator for each database partition within a set of database partitions. A ranking module ranks the set of database partitions according to a rank criteria. The rank criteria includes, at a minimum, the fragmentation indicator. A reorganization module 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 dynamic 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: 5835755 (1998-11-01), Stellwagen, Jr.
patent: 5903757 (1999-05-01), Gretz et al.
patent: 5991761 (1999-11-01), Mahoney et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6292178 (2001-09-01), Bernstein et al.
patent: 6553383 (2003-04-01), Martin
patent: 6557014 (2003-04-01), Cellis et al.
patent: 6633884 (2003-10-01), Martin et al.
patent: 2002/0143763 (2002-10-01), Martin et al.
patent: 2004/0143589 (2004-07-01), Martin, Jr.
patent: 2005/0091009 (2005-04-01), Belcher et al.
patent: 2005/0165713 (2005-07-01), Lafforet
patent: 2006/0206507 (2006-09-01), Dahbour
patent: 2008/0028199 (2008-01-01), Armstrong et al.
Klara Nahrstedt and Jonathan Smith—“Design, Implementation, and Experiences of the OMEGA End-Point Architecture”—Selected Areas in Communications, IEEE Journal on Sep. 1996, vol. 14, Issue 7 (pp. 1265-1279:1-17).
Guoray Cai—“GeoVIBE: A Visual Interface for Geographic Digital Libaries”—Visual Interfaces to Digital Libraries,, Computer Science, 2002, vol. 2539/2002, (pp. 171-187)—Springer-Verlag Berlin Heidelberg, 2002.
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 Data Base Pointer Checker User's Guide Release 1.0 (Program No. 5668-856, Document No. SH2O-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.
Bruni, Paolo 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) Sections: 6.6.4 Performance considerations using new statistics columns (pp. 141-146).
Bruni, Paolo et al., DB2 for zJOS 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.
McIver, Jr., “An Approach to Self-Adaptive, On-Line Reclustering of Complex Object Data”, Section 2.4, Chapters 3 and 4.
McIver, Jr., “Self-Adaptive, On-Line Reclustering of Complex Object Data”, all pages.
Plow Gregory Maurice
Pourmirzaie Farrokh E.
Shiomi Tatsuyuki
Breene John E
International Business Machines - Corporation
Kunzler Needham Massey & Thorpe
Ly Anh
LandOfFree
Apparatus and system for reorganizing a set of database... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Apparatus and system for reorganizing a set of database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and system for reorganizing a set of database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4255967