Accessing large objects

A computer system for accessing large objects (LOBs) in a database system, the computer system comprising:

• a memory;
• and
• one or more processors in communication with the memory, wherein the computer system is configured to perform a method, said method comprising:
• identifying, by the one or more processors, in a query from a requestor, one or more predicates comprising a partial access of large object (LOB) data from a LOB, wherein the partial access of large object (LOB) data from the LOB comprises a portion of a full LOB;
• caching, by the one or more processors, a location of the partial access of the LOB data in a buffer, wherein the caching comprises labeling the location with at least one predicate of the one or more predicates;
• determining, by the one or more processors, based on comparing a pre-set access count to a count of accesses for the location, that the location is a frequently accessed location;
• based on determining that the location is the frequently accessed location, stabilizing, by the one or more processors, the location in an index;
• determining, by the one or more processors, that the location meets a length threshold and a frequency threshold;
• based on determining that the location meets the length threshold and the frequency threshold, saving, by the one or more processors, the LOB data requested in the partial access of the LOB data inline with a base row, the saving comprising storing the portion of the full LOB inline with the base row;
• and
• storing, by the one or more processors, the full LOB in LOB pages in a LOB table space.

A computer program product for accessing large objects (LOBs) in a database system, the computer program product comprising:

• one or more computer readable storage media and program instructions collectively stored on the one or more computer readable storage media readable by at least one processing circuit to:
• identify, in a query from a requestor, one or more predicates comprising a partial access of large object (LOB) data from a LOB, wherein the partial access of large object (LOB) data from the LOB comprises a portion of a full LOB;
• cache a location of the partial access of the LOB data in a buffer, wherein the caching comprises labeling the location with at least one predicate of the one or more predicates;
• determine, based on comparing a pre-set access count to a count of accesses for the location, that the location is a frequently accessed location;
• based on determining that the location is the frequently accessed location, stabilize the location in an index;
• determine that the location meets a length threshold and a frequency threshold;
• and
• based on determining that the location meets the length threshold and the frequency threshold, save the LOB data requested in the partial access of the LOB data inline with a base row, the saving comprising storing the portion of the full LOB inline with the base row;
• and
• store the full LOB in LOB pages in a LOB table space.