Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-11-20
2007-11-20
Wong, Don (Department: 2163)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
10034438
ABSTRACT:
An improved method and system for controlling free space distribution by key range within a database. In one embodiment, a data structure including key ranges of a plurality of database tables and indexes, and a plurality of key range free space parameters is created. The plurality of database tables and indexes may include a plurality of page sets, which may include rows of data and keys. Time values may be associated with the plurality of free space parameters. The key range free space parameters may have values assigned to them. The key range free space parameters may be user-defined or automatically generated using growth trend analysis, based on key range growth statistics. The rows of data and keys within the plurality of page sets may be redistributed by a reorganization process. The redistributing may reference the key ranges of the data structure and the key range free space parameters.
REFERENCES:
patent: 4774657 (1988-09-01), Anderson et al.
patent: 5649196 (1997-07-01), Woodhill et al.
patent: 5732402 (1998-03-01), Lehman
patent: 5764593 (1998-06-01), Turpin et al.
patent: 5799290 (1998-08-01), Dolan et al.
patent: 5852822 (1998-12-01), Srinivasan et al.
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6021408 (2000-02-01), Ledain et al.
patent: 6032160 (2000-02-01), Lehman
patent: 6052698 (2000-04-01), Bennett et al.
patent: 6108653 (2000-08-01), Pereira
patent: 6115705 (2000-09-01), Larson
patent: 6122664 (2000-09-01), Boukobza et al.
patent: 6144970 (2000-11-01), Bonner et al.
patent: 6259448 (2001-07-01), McNally et al.
patent: 6269375 (2001-07-01), Ruddy et al.
patent: 6285996 (2001-09-01), Jou et al.
patent: 6334134 (2001-12-01), Haderle et al.
patent: 6351850 (2002-02-01), van Gilluwe et al.
patent: 6411964 (2002-06-01), Iyer et al.
patent: 6442539 (2002-08-01), Amundsen et al.
patent: 6453383 (2002-09-01), Stoddard et al.
patent: 6578039 (2003-06-01), Kawamura
patent: 6584474 (2003-06-01), Pereira
patent: 6591269 (2003-07-01), Ponnekanti
patent: 6606631 (2003-08-01), Martin et al.
patent: 6622142 (2003-09-01), Murray et al.
patent: 6636879 (2003-10-01), Doucette et al.
patent: 6658437 (2003-12-01), Lehman
patent: 6668263 (2003-12-01), Cranston et al.
patent: 2001/0047360 (2001-11-01), Huras et al.
patent: 2002/0083033 (2002-06-01), Abdo et al.
Black Linh
BMC Software Inc.
Wong Don
Wong Cabello Lutsch Rutherford & Brucculeri LLP
LandOfFree
System and method for controlling free space distribution by... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for controlling free space distribution by..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for controlling free space distribution by... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3824607