Structured large object (LOB) data

• US 8,832,081 B2
• Filed: 04/11/2012
• Issued: 09/09/2014
• Est. Priority Date: 03/13/2012
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Charlet, Kyle J., Church, Nathan D., Hite, Kevin D., Holtz, Christopher M., Tran, Richard V.
• Primary Examiner(s): Beausoliel, Jr., Robert
• Assistant Examiner(s): ALLEN, NICHOLAS E
• Application Number:
  US13/444,698
• Publication Number:
  US 20130246395A1
• Time in Patent Office: 881 Days
• Field of Search: 707/609, 707/611, 707/627, 707/705, 707/729, 707/732, 707/758, 707/763, 707/781, 707/801
• US Class Current: 707/722
• CPC Class Codes: G06F 16/2219 Large Object storage; Management thereof
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/289 Object oriented databases

Abstract

Provided are techniques for processing structured content within Large Object (LOB) data that is stored in a column of a database table. Structural metadata describing structures that each define a different format of the structured content is stored. A request for data in the database table is received. The structural metadata is used to create an empty result set with columns defined by at least two of the structures. For each row of data in the database table that includes LOB data, control data is used to identify one of the structures to be applied to the structured content within the LOB data stored in that row of data, and the structured content within the LOB data in that row of data is mapped to the columns in the result set based on the identified one of the structures. The result set is returned.

Claims

1. A method, comprising:

storing, using a processor of a computer, structural metadata describing a first structure and a second structure that each define a different format of structured content, wherein the structured content is a subset of Large Object (LOB) data, wherein the first structure has a first set of columns, and wherein the second structure has a second set of columns;

using the structural metadata to create a result set that is empty with the first set of columns and the second set of columns;

for each row of data in the database table that includes the LOB data,

in response to control data identifying the LOB data as having the first structure, mapping the structured content within the LOB data in that row of data to the first set of columns in the result set by generating queries using the structural metadata describing the first structure; and

in response to the control data identifying the LOB data has having the second structure, mapping the structured content within the LOB data in that row of data to the second set of columns in the result set by generating queries using the structure metadata describing the second structure; and

returning the result set.

2. The method of claim 1, wherein the structured content comprises a field and further comprising:

in response to receiving the request,

creating a first query using the structural metadata to retrieve a field value from the structured content; and

creating a second query using the structural metadata to insert the field value into a column of the result set.

3. The method of claim 1, wherein the structural metadata includes offsets and lengths of structured content in the LOB data.

4. The method of claim 1, wherein the control data is part of the LOB data.

5. The method of claim 1, wherein the control data is stored as a separate column.

6. The method of claim 1, wherein the LOB data includes structured content and unstructured content, and further comprising:

receiving a request to retrieve the structured content in the LOB data;

identifying an offset and a length of the structured content in the LOB data;

retrieving the structured content at the identified offset for the identified length; and

returning the retrieved structured content.

7. The method of claim 1, wherein the LOB data includes structured content and unstructured content, and further comprising:

storing an index to elements in the structured content;

receiving a request to search for a specific element in the structured content in the LOB data;

locating the specific element in the structured content using the index; and

returning the located specific element.

8. The method of claim 1, further comprising:

receiving a Variable length LOB (VLOB) record having multiple fields; and

in response to determining that a field in the VLOB record extends beyond physical space allocated to the VLOB record, treating the field as null.

9. The method of claim 8, further comprising:

processing a query that references a null field in the VLOB record.