Building A Unified Query That Spans Heterogeneous Environments

• US 20080281802A1
• Filed: 07/21/2008
• Published: 11/13/2008
• Est. Priority Date: 03/03/2006
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: PETERSON, Trenten, SINGH, Hardeep
• Application Number:
  US12/177,143
• Publication Number:
  US 20080281802A1
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/80 of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML content-based retrieval of web data G06F16/95
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

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.

Claims

1. A processor-implemented system of building a unified query that spans heterogeneous environments, comprising:

a data structure input for generating a source structure comprising a plurality of nodes from a data structure input of an identified data source;

a parser for presenting the generated source structure in a logical view;

user input actions for adding a node selected by a user from the plurality of nodes to a design query canvas;

a presentation module for generating a query object from the selected node based on a source type of the selected node;

a display module for presenting a logical view of a query function of a selected query object; and

a transformer for generating a unified query comprising the generated query object.

2. The system of claim 1, wherein the selected node comprises an element.

3. The system of claim 1, further comprising a graphical user interface for displaying the logical view.

4. The system of claim 1, wherein the design query canvas comprises a query design view.

5. The system of claim 1, wherein the parser includes an XML parser.

6. A computer product having a computer readable medium tangibly embodying computer executable code building a unified query that spans heterogeneous environments, comprising:

a program code for generating a source structure comprising a plurality of nodes from a data structure input of an identified data source;

a program code for presenting the generated source structure in a logical view;

a program code for adding a node selected by a user from the plurality of nodes to a design query canvas;

a program code for generating a query object from the selected node based on a source type of the selected node;

a program code for presenting a logical view of a query function of a selected query object; and

a program code for generating a unified query comprising the generated query object.

7. The computer program product of claim 6, wherein the selected node comprises an element.

8. The computer program product of claim 6, further comprising a graphical user interface for displaying the logical view.

9. The computer program product of claim 6, wherein the design query canvas comprises a query design view.

10. The computer program product of claim 6, wherein the parser includes an XML parser.