Method for processing structured documents stored in a database

• US 7,512,608 B2
• Filed: 09/11/2006
• Issued: 03/31/2009
• Est. Priority Date: 08/28/2003
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Loeser, Henrik, Vickery, Brian S., Van der Linden, Robbert C.
• Primary Examiner(s): Alam; Shahid A
• Application Number:
  US11/530,839
• Publication Number:
  US 20070005620A1
• Time in Patent Office: 932 Days
• Field of Search: 707/1, 707/100, 707/101, 707/9, 707/10, 717/108, 715/227, 715/229, 715/234
• US Class Current: 1/1
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A method for processing a structured document are disclosed. The method includes identifying a plurality of strings processed by a database, assigning an identifier to each of the plurality of strings, storing each of the plurality of strings and its assigned identifier in a table in the database, and utilizing the table during document processing.

Claims

1. A method for processing a structured document, the method comprising:

identifying a plurality of strings processed by a database;

assigning an identifier to each of the plurality of strings;

storing each of the plurality of strings and its assigned identifier in a table in the database, wherein at least one of the plurality of strings is not derived from one or more structured documents stored in the database and at least another of the plurality of strings is derived from the one or more structured documents stored in the database;

utilizing the table during document processing;

designating a status for each of the plurality of strings, wherein the status is one of a temporary status or a permanent status;

storing the status in the table; and

providing a cache in the database for storing a portion of the table, wherein utilizing the table during document processing comprises;

receiving a request to store a structured document in the database, wherein the structured document comprises a plurality of element, attribute, and namespace strings;

transforming the structured document by replacing the plurality of element, attribute, and namespace strings with their respective identifiers; and

storing the transformed structured document in the database, and wherein transforming the structured document comprises;

requesting an identifier for one of the plurality of element, attribute, and namespace strings in the structured document;

checking the cache for the one string;

returning an identifier assigned to the one string when the one string is located in the cache;

performing a lookup on the table for the one string when the one string is not located in the cache;

returning the identifier assigned to the one string when the one string is located in the table; and

assigning a new identifier to the one string, storing the one string and the new identifier in the table, designating a status of the one string as permanent, and returning the new identifier when the one string is not located in the table.

2. The method of claim 1, wherein transforming the structured document further comprises:

checking a current status of the one string when it is located in the table; and

changing the status of the one string to permanent when the current status is temporary.

3. The method of claim 1, wherein utilizing the table during document processing comprises:

receiving a query, wherein the query comprises a plurality of element, attribute, and namespace strings;

transforming the query by replacing the plurality of element, attribute, and namespace strings with their respective identifiers; and

processing the transformed query.

4. The method of claim 1, wherein the identifier is a fixed-sized integer.

5. The method of claim 1, wherein the at least one string is derived from a query to the database.

6. A method for processing a structured document, the method comprising:

identifying a plurality of strings processed by a database;

assigning an identifier to each of the plurality of strings;

storing each of the plurality of strings and its assigned identifier in a table in the database, wherein at least one of the plurality of strings is not derived from one or more structured documents stored in the database and at least another of the plurality of strings is derived from the one or more structured documents stored in the database;

utilizing the table during document processing

designating a status for each of the plurality of strings, wherein the status is one of a temporary status or a permanent status;

storing the status in the table; and

providing a cache in the database for storing a portion of the table, wherein utilizing the table during document processing comprises;

receiving a query, wherein the query comprises a plurality of element, attribute, and namespace strings;

transforming the query by replacing the plurality of element, attribute, and namespace strings with their respective identifiers; and

processing the transformed query, and wherein transforming the query comprises;

requesting an identifier for one of the plurality of element, attribute, and namespace strings in the query;

checking the cache for the one string;

returning an identifier assigned to the one string when the one string is located in the cache;

performing a lookup on the table for the one string when the one string is not located in the cache;

returning the identifier assigned to the one string when the one string is located in the table; and

assigning a new identifier to the one string, storing the one string and the new identifier in the table, designating a status of the one string as temporary, and returning the new identifier when the one string is not located in the table.