Database Large Object Reorganization

1. A method for database large object (LOB) reorganization, comprising: calculating, by a computer, an activity of an inline LOB, wherein the activity of the inline LOB is calculated by dividing an inline LOB hit counter, which is a number of times that the inline LOB has been accessed during a time period, by a data row hit counter, which is calculated using the number of times a data row of the inline LOB has been accessed over the period of time, or a data page hit counter, which is calculated using the number of times a data page of the inline LOB has been accessed over the period of time; redefining a length of the inline LOB according to the activity of the inline LOB by determining whether the activity of the inline LOB exceeds a predetermined threshold and in response to determining that the activity of the inline LOB does not exceed the predetermined threshold, redefining the length of the inline LOB as zero; based on determining that the length of the inline LOB has been redefined to zero: storing the inline LOB in a separate LOB table space; and inserting an indicator corresponding to the inline LOB at an original position of the inline LOB, wherein the indicator points to a position of the inline LOB in the separate LOB table space; and performing LOB reorganization based on the redefined length of the inline LOB.

2. The method of claim 1 , wherein redefining the length of the inline LOB according to the activity of the inline LOB comprises: calculating row activities of a plurality of inline LOBs; sorting the row activities of the plurality of inline LOBs; determining whether a sorted position of the row activity of an inline LOB of the plurality of inline LOBs meets a specified condition; and in response to determining that the sorted position of the row activity of the inline LOB meets the specified condition, redefining the length of the inline LOB to zero.

3. The method of claim 1 , wherein redefining the length of the inline LOB according to the activity of the inline LOB comprises: calculating page activities of a plurality of inline LOBs; sorting the page activities of the plurality of inline LOBs; determining whether a sorted position of the page activity of an inline LOB in the plurality of inline LOBs meets a specified condition; and in response to determining that the sorted position of the page activity of the inline LOB meets the specified condition, redefining the length of the inline LOB as zero.

4. A system having a processor for database large object (LOB) reorganization, comprising: a calculating component configured to calculate an activity of an inline LOB, wherein the activity of the inline LOB is calculated by dividing an inline LOB hit counter, which is a number of times that the inline LOB has been accessed over a period of time, by a data row hit counter, which is calculated using the number of times a data row of the inline LOB has been accessed over the period of time, or a data page hit counter, which is calculated using the number of times a data page of the inline LOB has been accessed over the period of time; a defining component configured to redefine a length of the inline LOB according to the activity of the inline LOB by determining whether the activity of the inline LOB exceeds a predetermined threshold and in response to determining that the activity of the inline LOB does not exceed the predetermined threshold, redefining the length of the inline LOB as zero; and a reorganization component configured to perform LOB reorganization based on the redefined length of the inline LOB, wherein the defining component is further configured to: store the inline LOB in a separate LOB table space; and insert an indicator corresponding to the inline LOB at an original position of the inline LOB based on determining that the length of the LOB has been redefined to zero, wherein the indicator points to a position of the inline LOB in the separate LOB table space.

5. The system of claim 4 , wherein the calculating component is further configured to calculate row activities of a plurality of inline LOBs, and the system further comprises: a sorting component configured to sort the row activities of the plurality of inline LOBs; and a determining component configured to determine whether a sorted position of the row activity of an inline LOB in the plurality of inline LOBs meets a specified condition; wherein the defining component is further configured to redefine the length of the inline LOB to zero in response to determining that the sorted position of the row activity of the inline LOB meets the specified condition.

6. The system of claim 4 , wherein the calculating component is further configured to calculate page activities of a plurality of inline LOBs, and the system further comprises: a sorting component configured to sort the page activities of the plurality of inline LOBs; and a determining component configured to determine whether a sorted position of the page activity of an inline LOB in the plurality of inline LOBs meets a specified condition; wherein the defining component is further configured to redefine the length of the inline LOB to zero, in response to the sorted position of the page activity of the inline LOB meeting the specified condition.

7. A computer program product for database large object (LOB) reorganization, comprising: a non-transitory computer readable storage medium; a first program instruction to calculate an activity of an inline LOB by dividing an inline LOB hit counter, which is a number of times that the inline LOB has been accessed during a time period, by a data row hit counter, which is calculated using the number of times a data row of the inline LOB has been accessed over the period of time, or a data page hit counter, which is calculated using the number of times a data page of the inline LOB has been accessed over the period of time; a second program instruction to redefine a length of the inline LOB by determining whether the activity of the inline LOB exceeds a predetermined threshold and in response to determining that the activity of the inline LOB does not exceed the predetermined threshold, redefining the length of the inline LOB as zero; a fourth program instruction to store the inline LOB in a separate LOB table space and insert an indicator corresponding to the inline LOB at an original position of the inline LOB based on determining that the length of the LOB has been redefined to zero, wherein the indicator points to a position of the inline LOB in the separate LOB table space; and a third program instruction to perform LOB reorganization based on the redefined length of the inline LOB, wherein the first, second, third, and fourth program instructions are stored on the computer readable storage medium.

8. The computer program product of claim 7 , wherein the first program instruction additionally calculates row activities of a plurality of inline LOBs, and the computer program product further comprises: a fifth program instruction, stored on the computer readable storage medium, to sort the row activities of the plurality of inline LOBs; and a sixth program instruction, stored on the computer readable storage medium, to determine whether a sorted position of the row activity of an inline LOB in the plurality of inline LOBs meets a specified condition; wherein the second program instruction additionally redefines the length of the inline LOB to zero in response to determining that the sorted position of the row activity of the inline LOB meets the specified condition.

9. The computer program product of claim 7 , wherein the first program instruction calculates the page activity of the inline LOB using a number of times the inline LOB has been accessed and the number of times the page in which the inline LOB is located has been accessed over a period of time.

10. The computer program product of claim 9 , further comprising: a seventh program instruction, stored on the computer readable storage medium, to determine whether the page activity of the inline LOB exceeds a predetermined threshold, and in response to determining that the page activity of the inline LOB does not exceed the predetermined threshold, redefining the length of the inline LOB to zero.