Database extender for storing, querying, and retrieving structured documents
AssigneeInternational Business Machines Corporation
InventorsDaniel T. Chang, Josephine M. Cheng, Jyh-Herng Chow, Jian Xu
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsDaniel T. Chang, Josephine M. Cheng, Jyh-Herng Chow, Jian Xu
Estimating the term…
An extender for a computer-implemented relational database system is disclosed for storing, querying, and retrieving structured documents. The extender provides a new abstract data type and includes a plurality of user defined functions for storing, querying, and retrieving structured documents internally, as character-based large objects (CLOB), or externally, in flat files or URLs, for example. A method and apparatus using an extender having a “conditional select” functionality is further disclosed for querying structured documents. The “conditional select” functionality is based on user defined functions residing within the extender being applied to a projection in a structured query in the database system. A method and apparatus using an extender having a set of user defined functions is further disclosed for creating one or more indexes for structured documents stored in the relational database system. The method uses the set of functions to create the indexes and uses already created B+ tree index structures implemented in the database system to support the indexes. A method and apparatus using an extender is further disclosed for creating and supporting structure indexes. The method includes a tag counting system for indexing structured documents and for implementing the structure indexes within the relational database.
A method of storing at least one structured document in a database system, using an extender for said database system, said extender enabling a user to store said at least one structured document in said database system, said method comprising the steps of:
In a computer-based apparatus for storing at least one structured document in a database system, using an extender for said database system, said extender enabling a user to store said at least one structured document in said database system,
In an article of manufacture for storing at least one structured document in a database system, using an extender for said database system, said extender enabling a user to store said at least one structured document in said database system, said article of manufacture comprising a program storage medium readable by a computer, wherein said extender includes at least one facility for:
An extender for a database system for storing at least one structured document in said database system, said extender enabling a user to store said at least one structured document in said database system, said extender comprising:
A computer-readable storage medium storing an extender for a database system, said extender enabling a user to store at least one structured document in said database system, said extender comprising:
A method of executing a structured query given by a user in a database system, using an extender for said database system, said extender enabling a user to query said database system, said database system containing at least one structured document and having at least one data type for said at least one structured document, said database system further containing a table having at least one column defined using said at least one data type, said at least one column storing each of said at least one structured document, said method comprising the steps of:
In an apparatus for executing a structured query given by a user in a database system, using an extender for said database system, said extender enabling said user to query said database system, said database system containing at least one structured document and having at least one data type for said at least one structured document, said database system further containing a table having at least one column defined using said at least one data type, said at least one column storing each of said at least one structured document, said apparatus comprising a computer having at least one data storage device connected thereto, wherein said at least one data storage device stores said extender and said database system, and
In an article of manufacture for executing a structured query given by a user in a database system, using an extender for said database system, said extender enabling said user to query said database system, said database system containing at least one structured document and having at least one data type for said at least one structured document, said database system further containing a table having at least one column defined using said at least one data type, said at least one column storing each of said at least one structured document, said article of manufacture comprising a program storage medium readable by a computer, wherein said extender includes at least one facility for:
An extender for a database system for executing a structured query given by a user in a database system, said extender enabling said user to query said database system, said database system containing at least one structured document and having at least one data type for said at least one structured document, said database system further containing a table having at least one column defined using said at least one data type, said at least one column storing each of said at least one structured document, said extender comprising at least one facility for:
A computer-readable storage medium storing an extender for a database system, said extender enabling a user to query at least one structured document in said database system, wherein said extender defines and implements new complex data types, including storing the attributes, structure, and behavior of the data types in a column of a relational database table;
A method of retrieving at least one structured document from a database system, using an extender for said database system, said extender enabling a user to retrieve said at least one structured document, said database system containing said at least one structured document and having at least one data type for said at least one structured document, said database system further containing a table having at least one column defined using said at least one data type, said at least one column storing each of said at least one structured document, said method comprising the steps of:
In a computer-based apparatus for retrieving at least one structured document from a database system, using an extender for said database system, said extender enabling a user to retrieve said at least one structured document, said database system containing at least one structured document and having at least one data type for said at least one structured document, said database system further containing a table having at least one column defined using said at least one data type, said at least one column storing each of said at least one structured document, said apparatus comprising a computer having at least one data storage device connected thereto, wherein said at least one data storage device stores said extender and said database system, and
In an article of manufacture for retrieving at least one structured document from a database system, using an extender for said database system, said extender enabling a user to retrieve said at least one structured document, said database system containing at least one structured document and having at least one data type for said at least one structured document, said database system further containing a table having at least one column defined using said at least one data type, said at least one column storing each of said at least one structured document, said article of manufacture comprising a program storage medium readable by a computer, wherein said extender includes at least one facility for:
An extender for a database system for retrieving at least one structured document from a database system, said extender enabling a user to retrieve said at least one structured document, said database system containing at least one structured document and having at least one data type for said at least one structured document, said database system further containing a table having at least one column defined using said at least one data type, said at least one column storing each of said at least one structured document, said extender comprising at least one facility for:
A computer-readable storage medium storing an extender for a database system, said extender enabling a user to retrieve at least one structured document from said database system, wherein said extender defines and implements new complex data types, including storing the attributes, structure, and behavior of the data types in a column of a relational database table;
Dependencies are inferred from the claim text.