Building A Unified Query That Spans Heterogeneous Environments

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.

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.