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.

Abstract: A unified query building system generates a source structure comprising nodes from a data structure input of an identified data source, displays the generated source structure in a logical view, adds a selected node or element from the nodes to a design query canvas, generates a query object from the selected node based on a source type of the selected node, presents a logical view of a query function of a selected query object, and generates a unified query comprising the generated query objects. The logical view is displayed in a graphical user interface comprising a design query canvas comprising grids corresponding to functions in a query language such as SQL or XML. The generated unified query is displayed in an actual query view and is outlined in a query outline view.

Abstract: A system and method for building an XQuery using a model-based XQuery building tool is presented. An XQuery builder includes a general user interface (GUI) that enables a user to graphically interpret XML source documents and create a query model. The XQuery builder then optimizes the query model by generating relative paths for nodes and converting FLWOR expressions to XPath expressions. In addition, the XQuery builder inserts runtime parameters into the query model that correspond to XML documents that are required to test the XQuery. Subsequently, the XQuery builder generates an XQuery from the optimized query model, and provides the XQuery and required XML documents to a query engine that, in turn, produces query results.

Abstract: A unified query building system generates a source structure comprising nodes from a data structure input of an identified data source, displays the generated source structure in a logical view, adds a selected node or element from the nodes to a design query canvas, generates a query object from the selected node based on a source type of the selected node, presents a logical view of a query function of a selected query object, and generates a unified query comprising the generated query objects. The logical view is displayed in a graphical user interface comprising a design query canvas comprising grids corresponding to functions in a query language such as SQL or XML. The generated unified query is displayed in an actual query view and is outlined in a query outline view.

Abstract: An XPath generation system generates a default XPath expression (XPath) from a selected destination node. The system provides to a user the default XPath with modification options. The system modifies the default XPath according to selected modification options to generate a resulting XPath. If none of the modifications options are selected, the system selects the default XPath as the resulting XPath. The modification options comprise selecting a different node as a destination node of the XPath, selecting a context node as a starting node of the XPath, selecting an axis for specifying a path between the context node and the destination node, specifying selection of a node by name or by type, specifying selection of any node, and specifying return of only unique values of the resulting XPath.

Abstract: A search string is received to be applied to structured data. A concatenated version of the structured data is obtained and the search string is applied to the concatenated version to obtain search results. A list of results is generated and comprises search string correlated information from different portions of the structured data.

Abstract: A method and system for providing a query builder for at least one query language is disclosed. The method and system include providing a plurality of grids and at least one resource for a grid set including at least one of the plurality of grids. The grids correspond to a plurality of functional units of the query language(s). The grid set corresponds to one of the functional units. The resource(s) correspond to the functional unit and to the grid set. The resource(s) are capable of being used as at least one argument for the grid set.

Abstract: An information handling system comprises an input for receiving a spreadsheet application in static HTML form; a compiler for compiling the spreadsheet application to produce a generic XML document; an interpreter for interpreting the XML document to produce a browser-specific hypertext document representing the spreadsheet; and an output for serving the hypertext document to a client.

Abstract: A method including importing data objects from different data sources to define a data source model, associating each data object with one or more cells in a spreadsheet, and binding data from the data objects to the one or more cells upon request. The binding is based on information from the data source.