METHOD, SYSTEM, AND COMPUTER PROGRAM PRODUCT FOR DYNAMICALLY DETERMINING DATA PLACEMENT

• US 20080021865A1
• Filed: 07/20/2006
• Published: 01/24/2008
• Est. Priority Date: 07/20/2006
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Wurth, Gregory P., Sobik, Peter S., Corkill, Brian L., Dawson, Erika M.
• Application Number:
  US11/458,736
• Publication Number:
  US 20080021865A1
• Time in Patent Office: Days
• US Class Current: 707/2
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof

Abstract

A method, system, and computer program product for determining storage locations for data objects is provided. The method includes providing user-selectable options for assigning storage locations for data objects, which is based upon a minimum threshold size of the data objects defined for a storage group. The options are implemented via a binary large object storage structure (LSS)-enablement indicator. The storage locations are further defined by a view associated with storage groups within an administrative table. Upon receiving a request to store a data object that exceeds the minimum threshold size, the method includes retrieving the selected options from the LSS-enablement indicator. If the LSS-enablement indicator is enabled for a portion of the storage groups, the method includes determining whether a view for the data table of the second storage subsystem for the assigned storage group exists via the administrative table. If the view exists, the data object is stored in the second storage subsystem. Otherwise, the data object is stored in the first storage subsystem.

Claims

1. A method of determining storage locations for data objects, comprising:

providing user-selectable options for assigning storage locations for data objects, the assigning based upon a minimum threshold size of the data objects that are each defined for a storage group, the user-selectable options implemented via a binary large object storage structure (LSS)-enablement indicator, the storage locations further defined by a view associated with selected storage groups within an administrative table that tracks data tables and views for corresponding storage groups;

storing selected options in an internal control block of a storage support system; and

upon receiving a request to store a data object that exceeds the minimum threshold size;

retrieving the selected options from the LSS-enablement indicator of the internal control block;

if the selected options reflect that the LSS-enablement indicator is disabled for all of the storage groups, storing the data object in a data table of a first storage subsystem for a storage group to which the data object is assigned;

if the selected options reflect that the LSS-enablement indicator is enabled for all of the storage groups, storing the data object in a data table of a second storage subsystem for a storage group to which the data object is assigned; and

if the selected options reflect that the LSS-enablement indicator is enabled for a portion of the storage groups;

accessing the administrative table and determining whether a view for the data table of the second storage subsystem for the assigned storage group exists;

if the view exists, storing the data object in the data table of the second storage subsystem for the assigned storage group; and

if the view does not exist, storing the data object in the data table of the first storage subsystem for the assigned storage group;

wherein the storage groups include a logical grouping of the data objects.

2. The method of claim 1, further comprising storing data objects that meet or do not exceed the minimum threshold size in a data table of a third storage subsystem for a storage group to which the data object is assigned.

3. The method of claim 2, wherein the first and second storage subsystems are binary large object storage subsystems.

4. The method of claim 2, wherein the third storage subsystem is a 4K data table.

5. The method of claim 1, wherein the first storage subsystem is a 32K data table and the minimum threshold size is 32K.

6. The method of claim 1, wherein the second storage subsystem is a binary large object storage structure (LSS) and the minimum threshold size is 32K.

12. The system of claim 1, wherein the second storage subsystem is a binary large object storage structure (LSS) and the minimum threshold size is 32K.

7. A system of determining storage locations for data objects, comprising:

a host system;

a storage support system executing on the host system, the storage support system implementing a method, comprising;

providing user-selectable options for assigning storage locations for data objects, the assigning based upon a minimum threshold size of the data objects that are each defined for a storage group, the user-selectable options implemented via a binary large object storage structure (LSS)-enablement indicator, the storage locations further defined by a view associated with selected storage groups within an administrative table that tracks data tables and views for corresponding storage groups;

storing selected options in an internal control block of the storage support system; and

upon receiving a request to store a data object that exceeds the minimum threshold size;

retrieving the selected options from the LSS-enablement indicator of the internal control block;

if the selected options reflect that the LSS-enablement indicator is disabled for all of the storage groups, storing the data object in a data table of a first storage subsystem for a storage group to which the data object is assigned;

if the selected options reflect that the LSS-enablement indicator is enabled for all of the storage groups, storing the data object in a data table of a second storage subsystem for a storage group to which the data object is assigned; and

if the selected options reflect that the LSS-enablement indicator is enabled for a portion of the storage groups;

accessing the administrative table and determining whether a view for the data table of the second storage subsystem for the assigned storage group exists;

if the view exists, storing the data object in the data table of the second storage subsystem for the assigned storage group; and

if the view does not exist, storing the data object in the data table of the first storage subsystem for the assigned storage group;

wherein the storage groups include a logical grouping of the data objects.

8. The system of claim 7, wherein the storage support system further performs:

storing data objects that meet or do not exceed the minimum threshold size in a data table of a third storage subsystem of a storage group to which the data object is assigned.

9. The system of claim 8, wherein the first and second storage subsystems are binary large object storage subsystems.

10. The system of claim 8, wherein the third storage subsystem is a 4K data table.

11. The system of claim 7, wherein the first storage subsystem is a 32K data table and the minimum threshold size is 32K.

13. A computer program product for determining data storage locations for data objects, the computer program product including instructions for implementing a method, comprising:

providing user-selectable options for assigning storage locations for data objects, the assigning based upon a minimum threshold size of the data objects that are each defined for a storage group, the user-selectable options implemented via a binary large object storage structure (LSS)-enablement indicator, the storage locations further defined by a view associated with selected storage groups within an administrative table that tracks data tables and views for corresponding storage groups;

storing selected options in an internal control block of a storage support system; and

upon receiving a request to store a data object that exceeds the minimum threshold size;

retrieving the selected options from the LSS-enablement indicator of the internal control block;

if the selected options reflect that the LSS-enablement indicator is disabled for all of the storage groups, storing the data object in a data table of a first storage subsystem for a storage group to which the data object is assigned;

if the selected options reflect that the LSS-enablement indicator is enabled for all of the storage groups, storing the data object in a data table of a second storage subsystem for a storage group to which the data object is assigned; and

if the selected options reflect that the LSS-enablement indicator is enabled for a portion of the storage groups;

accessing the administrative table and determining whether a view for the data table of the second storage subsystem for the assigned storage group exists;

if the view exists, storing the data object in the data table of the second storage subsystem for the assigned storage group; and

if the view does not exist, storing the data object in the data table of the first storage subsystem for the assigned storage group;

wherein the storage groups include a logical grouping of the data objects.

14. The computer program product of claim 13, further comprising instructions for storing data objects that meet or do not exceed the minimum threshold size in a data table of a third storage subsystem for a storage group to which the data object is assigned.

15. The computer program product of claim 14, wherein the first and second storage subsystems are binary large object storage subsystems.

16. The computer program product of claim 14, wherein the third storage subsystem is a 4K data table.

17. The computer program product of claim 13, wherein the first storage subsystem is a 32K data table and the minimum threshold size is 32K.

18. The computer program product of claim 13, wherein the second storage subsystem is a binary large object storage structure (LSS) and the minimum threshold size is 32K.