Method and process for end users to query hierarchical data
AssigneeInternational Business Machines Corporation
InventorHardeep Singh
Life of this patent
Estimating the term…
Abstract
Embodiments of the invention provide techniques for specifying precise queries of hierarchical data. In one embodiment, a mapping template is created to represent the hierarchical data in terms that are easy to for users to understand. The mapping template is used to generate a query tool having a tree structure made up of nodes that are queried by the user. The user may compose a query by navigating the tree structure to select nodes of interest, and specifying predicates for the selected nodes. Once the query is composed, it may be executed against the hierarchical data.
Claims21
A computer-implemented method of composing a query of hierarchical data, comprising:
- receiving a selection of at least one query node from a set of one or more query nodes included in a query tool, wherein each query node represents elements of the hierarchical data, and wherein a mapping template specifies mappings from the one or more query nodes of the query tool to the elements of the hierarchal data
- presenting, in the query tool, a form for entering a query predicate corresponding to the at least one selected query node;
- receiving, in the query tool, one or more query predicates specified in the form;
- composing a query of the hierarchical data from a base query, the one or more query predicates, and the mapping template, wherein the base query identifies a data source for the composed query;
- and
- modifying the base query to include the one or more query predicates.
A computer program product comprising a computer-useable storage medium having a computer readable program resident thereon, wherein the computer readable program, when executed on by one or more processors, causes the one or more processors to perform an operation comprising:
- receiving a selection of at least one query node from a set of one or more query nodes included in a query tool, wherein each query node represents elements of the hierarchical data, and wherein a mapping template specifies mappings from the one or more query nodes of the query tool to the elements of the hierarchal data;
- presenting, in the query tool, a form for entering a query predicate corresponding to the at least one selected query node;
- receiving, in the query tool, one or more query predicates specified in the form;
- composing a query of the hierarchical data from a base query, the one or more query predicates, and the mapping template, wherein the base query identifies a data source for the composed query;
- and
- modifying the base query to include the one or more query predicates.
A system, comprising:
- a processor;
- and
- a memory containing a program configured to compose a query of hierarchical data by performing an operation, comprising:
- receiving a selection of at least one query node from a set of one or more query nodes included in a query tool, wherein each query node represents elements of the hierarchical data, and wherein a mapping template specifies mappings from the one or more query nodes of the query tool to the elements of the hierarchal data;
- presenting, in the query tool, a form for entering a query predicate corresponding to the at least one selected query node;
- receiving, in the query tool, one or more query predicates specified in the form;
- composing a query of the hierarchical data from a base query, the one or more query predicates, and the mapping template, wherein the base query identifies a data source for the composed query;
- and
- modifying the base query to include the one or more query predicates.
Dependencies are inferred from the claim text.