US6535895B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Technique to avoid processing well clustered LOB's during reorganization of a LOB table space
Assignee: International Business Machines Corp
•
Filing: 1999-05-28
•
Granted: 2003-03-18
•
Expires: 2019-05-28
Abstract
Abstract A method, apparatus, and article of manufacture for a computer implemented reorganization system. A table space is reorganized in a database stored on a data storage device connected to a computer. When inserting or updating a LOB into a portion of the table space, a space map is marked to indicate whether the LOB was well inserted. When reorganizing the table space, when the space map indicates that a LOB was well inserted, reorganization of the portion of the table space in which the LOB was well inserted is avoided.
Inventors
- 👤 Charles Roy Bonner
- 👤 Robert William Lyle
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 06:54
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/90; G06F16/95; G06F16/955; G06F16/20; G06F16/22; G06F16/2219; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953; Y10S707/99956
Claims Analysis
Total Claims: 29
Claim 1
Independent Claim
97 words
A method of reorganizing a table space stored on a data storage device connected to a computer, the method comprising: when inserting or updating data into a portion of the table space, setting a flag in a space map which is associated with the data to indicate whether the data was well inserted, wherein the space map is stored in the table space with the data; and when reorganizing the table space, when the flag indicates that data was well inserted, avoiding reorganization of the portion of the table space in which the data was well inserted.
Claim 2
Independent Claim
97 words
A method of reorganizing a table space stored on a data storage device connected to a computer, the method comprising: when inserting or updating data into a portion of the table space, setting a flag in a space map which is associated with the data to indicate whether the data was well inserted, wherein the space map is stored in the table space with the data; and when reorganizing the table space, when the flag indicates that data was well inserted, avoiding reorganization of the portion of the table space in which the data was well inserted.
Claim 3
Dependent Claim
36 words
The method of claim 1 , wherein the method further comprises, when reorganizing the table space, when the flag indicates that the data was not well inserted, processing the data so that it is well inserted.
Claim 4
Dependent Claim
23 words
The method of claim 1 , wherein the method further comprises, as data is being inserted, tracking how the data is being inserted.
Claim 5
Dependent Claim
29 words
The method of claim 3 , wherein the method further comprises, after inserting the data, using information obtained from the tracking to determine whether the data was well inserted.
Claim 6
Dependent Claim
24 words
The method of claim 3 , wherein the method further comprises, as data is being updated, tracking of how the data is being updated.
Claim 7
Dependent Claim
29 words
The method of claim 5 , wherein the method further comprises, after updating the data, using information obtained from the tracking to determine whether the data was well inserted.
Claim 8
Independent Claim
113 words
An apparatus for reorganizing a table space, comprising: a computer having a data storage device connected thereto, wherein the data storage device stores the table space; one or more computer programs, performed by the computer, for, when inserting or updating data into a portion of the table space, setting a flag in a space map which is associated with the data to indicate whether the data was well inserted, wherein the space map is stored in the table space with the data, and, when reorganizing the table space, when the flag indicates that data was well inserted, avoiding reorganization of the portion of the table space in which the data was well inserted.
Claim 9
Independent Claim
113 words
An apparatus for reorganizing a table space, comprising: a computer having a data storage device connected thereto, wherein the data storage device stores the table space; one or more computer programs, performed by the computer, for, when inserting or updating data into a portion of the table space, setting a flag in a space map which is associated with the data to indicate whether the data was well inserted, wherein the space map is stored in the table space with the data, and, when reorganizing the table space, when the flag indicates that data was well inserted, avoiding reorganization of the portion of the table space in which the data was well inserted.
Claim 10
Dependent Claim
36 words
The apparatus of claim 7 , further comprising the means for, when reorganizing the table space, when the flag indicates that the data was not well inserted, processing the data so that it is well inserted.
Claim 11
Dependent Claim
23 words
The apparatus of claim 7 , further comprising the means for, as data is being inserted, tracking how the data is being inserted.
Claim 12
Dependent Claim
31 words
The apparatus of claim 9 , further comprising the means for, after inserting the data, using information obtained from the means for tracking to determine whether the data was well inserted.
Claim 13
Dependent Claim
24 words
The apparatus of claim 7 , further comprising the means for, as data is being updated, tracking of how the data is being updated.
Claim 14
Dependent Claim
31 words
The apparatus of claim 11 , further comprising the means for, after updating the data, using information obtained from the means for tracking to determine whether the data was well inserted.
Claim 15
Dependent Claim
122 words
An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform a method for reorganizing a table space stored in a data storage device connected to the computer, the method comprising: when inserting or updating data into a portion of the table space, setting a flag in a space map which is associated with the data to indicate whether the data was well inserted, wherein the space map is stored in the table space with the data; and when reorganizing the table space, when the flag indicates that data was well inserted, avoiding reorganization of the portion of the table space in which the data was well inserted.
Claim 16
Dependent Claim
122 words
An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform a method for reorganizing a table space stored in a data storage device connected to the computer, the method comprising: when inserting or updating data into a portion of the table space, setting a flag in a space map which is associated with the data to indicate whether the data was well inserted, wherein the space map is stored in the table space with the data; and when reorganizing the table space, when the flag indicates that data was well inserted, avoiding reorganization of the portion of the table space in which the data was well inserted.
Claim 17
Dependent Claim
38 words
The article of manufacture of claim 13 , wherein the method further comprises, when reorganizing the table space, when the flag indicates that the data was not well inserted, processing the data so that it is well inserted.
Claim 18
Dependent Claim
25 words
The article of manufacture of claim 13 , wherein the method further comprises, as data is being inserted, tracking how the data is being inserted.
Claim 19
Dependent Claim
31 words
The article of manufacture of claim 15 , wherein the method further comprises, after inserting the data, using information obtained from the tracking to determine whether the data was well inserted.
Claim 20
Dependent Claim
26 words
The article of manufacture of claim 13 , wherein the method further comprises, as data is being updated, tracking of how the data is being updated.
Claim 21
Dependent Claim
31 words
The article of manufacture of claim 17 , wherein the method further comprises, after updating the data, using information obtained from the tracking to determine whether the data was well inserted.
Claim 22
Dependent Claim
39 words
The apparatus of claim 7 , further comprising one or more computer programs that, when reorganizing the table space, when the flag indicates that the data was not well inserted, process the data so that it is well inserted.
Claim 23
Dependent Claim
26 words
The apparatus of claim 7 , further comprising one or more computer programs that, as data is being inserted, track how the data is being inserted.
Claim 24
Dependent Claim
38 words
The apparatus of claim 20 , further comprising one or more computer programs that, after inserting the data, use information obtained from the one or more computer programs that track to determine whether the data was well inserted.
Claim 25
Dependent Claim
27 words
The apparatus of claim 7 , further comprising one or more computer programs that, as data is being updated, track of how the data is being updated.
Claim 26
Dependent Claim
37 words
The apparatus of claim 22 , further comprising one or more computer programs that, after updating the data, use information obtained from one or more computer programs that track to determine whether the data was well inserted.
Claim 27
Dependent Claim
12 words
The method of claim 1 , wherein the data is LOB data.
Claim 28
Dependent Claim
12 words
The apparatus of claim 7 , wherein the data is LOB data.
Claim 29
Dependent Claim
14 words
The article of manufacture of claim 13 , wherein the data is LOB data.
References Cited (Backward Citations)
US5222235A
Cited
US5517641A
Cited
US5758357A
Cited
US5721915A
Cited
US5732402A
Cited
US5778392A
Cited
US5930828A
Cited
US6070170A
Cited
US5999943A
Cited
US6061690A
Cited
US6209000B1
Cited
US6243718B1
Cited
US6343286B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2006-03-17 | 2006-09-16 | 2007-03-18 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2010-03-17 | 2010-09-16 | 2011-03-18 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2014-03-17 | 2014-09-16 | 2015-03-18 | $7700.00 | Window Closed / Lapsed |