Apparatus and method for executing different query language queries on tree structured data using pre-computed indices of selective document paths
A method of operating a tree structured database includes receiving a document, forming a top-down tree characterizing the document, generating pre-computed indices characterizing the document, combining subsets of the pre-computed indices to dynamically create a table of information characterizing the document, and resolving a structured query language query against the table to form collected data.
1. A method of operating a tree structured database, comprising:
receiving a document;
forming a top-down tree characterizing the document;
generating pre-computed indices characterizing the document
loading the top-down tree and pre-computed indices into a tree structured database;
resolving a structured query language query against the tree structured database by temporarily forming a relational table, wherein subsets of the pre-computed indices are used to dynamically create the relational table, wherein the relational table is formed in response to the query and the information characterizing the document is retrieved from the document utilizing the pre-computed indices; and
collecting data from the relational table in response to the structured query language query.
2. The method of claim 1 wherein the pre-computed indices are selected from an element range index, an element-attribute range index, a path range index, a field range index and a geospatial range index.
3. The method of claim 1 wherein the pre-computed indices define range indices on components of the top-down tree characterizing the document, wherein the components are selected from elements, attributes, paths, composite fields, geospatial elements, geospatial element attributes, geospatial element pairs and geospatial element-attribute pairs.
4. The method of claim 1 wherein the pre-computed indices define type range indices on metadata selected from document locators and document collections.
5. The method of claim 1 further comprising combining subsets of pre-computed indices based upon mapping indices to named, typed columns of the table of information.
6. The method of claim 1 wherein the pre-computed indices are defined in a configuration file.
7. The method of claim 6 wherein the configuration file specifies range indexes on composite fields and included and excluded elements in the composite fields.
8. The method of claim 6 wherein the configuration file identifies elements using at least one of element names, path expressions and hierarchical relationships in the top-down tree characterizing the document.
9. The method of claim 1 wherein the structured query language query includes a full text word query on the documents from which indexes are pre-computed.
10. The method of claim 1 wherein the tree structured database is a markup language database.