Abstract: A user interface can be used to associate data in a database. Data is presented in an assignment column, a first data element column, and a second data element column in the user interface, wherein the first and second data element columns show data elements stored in a database. First user input is received to select one or more data elements in the first data column. After receiving the first user input, the data assignment elements of the data assignment column are configured to correspond to the data elements of the second column Second user input is received in one or more of the data assignment elements indicating selection of one or more data elements of the second data column. The selected one or more data elements in the first data column are associated in the database with the selected one or more data elements in the second data column.

Abstract: A data assignment column, a first data element column, and a second data element column are presented in a graphical user interface, wherein the first and second data element columns show data elements stored in a database. First user input selecting one or more data elements in the first data column is received. Second user input in one or more of the data assignment elements indicates selection of one or more data elements of the second data column. The selected one or more data elements in the first data column are associated in the database with the selected one or more data elements in the second data column.

Abstract: Provided is a graphical user interface (GUI) to associate information with an object. Different views are maintained providing different hierarchical arrangements of a set of objects. Selection is received of one view and one object in the selected view. Information is associated with the selected object, wherein the associated information is accessible in all views in which the object with which the information is associated is accessible.

Abstract: Provided is a graphical user interface (GUI) to associate information with an object. Different views are maintained providing different hierarchical arrangements of a set of objects. Selection is received of one view and one object in the selected view. Information is associated with the selected object, wherein the associated information is accessible in all views in which the object with which the information is associated is accessible.

Abstract: A computer program product and method of visual cues is provided through the use of query templates with functional template blocks to assist in building queries by giving visual cues about valid options, expected constructs, and required syntax. The one or more visual cues each have one or more of a valid option, expected construct, and required syntax. The invention provides a graphic user interface display to assist a builder in query creation.

Abstract: A user interface can be used to associate data in a database. Data is presented in an assignment column, a first data element column, and a second data element column in the user interface, wherein the first and second data element columns show data elements stored in a database. First user input is received to select one or more data elements in the first data column. After receiving the first user input, the data assignment elements of the data assignment column are configured to correspond to the data elements of the second column Second user input is received in one or more of the data assignment elements indicating selection of one or more data elements of the second data column. The selected one or more data elements in the first data column are associated in the database with the selected one or more data elements in the second data column.

Abstract: A data assignment column, a first data element column, and a second data element column are presented in a graphical user interface, wherein the first and second data element columns show data elements stored in a database. First user input selecting one or more data elements in the first data column is received. Second user input in one or more of the data assignment elements indicates selection of one or more data elements of the second data column. The selected one or more data elements in the first data column are associated in the database with the selected one or more data elements in the second data column.

Abstract: Provided is a graphical user interface (GUI) to associate information with an object. Different views are maintained providing different hierarchical arrangements of a set of objects. Selection is received of one view and one object in the selected view. Information is associated with the selected object, wherein the associated information is accessible in all views in which the object with which the information is associated is accessible.

Abstract: A method for assisting a user in creating software code. In one implementation, the method includes receiving user input editing software code through a code editor, in which the software code is associated with a programming language having a plurality of software constructs. The method further includes receiving user input invoking a code assistant associated with the code editor. The code assistant comprises a plurality of panels that correspond to the plurality of software constructs. One or more of the plurality of panels contain a set of user-selectable options associated with a given software construct to assist the user in editing the software code.

Abstract: A system and computer program product for assisting a user in creating software code. In one implementation, the system includes a display; and a code editor configured to permit a user to edit software code that is displayable on the display. The software code is associated with a programming language having a plurality of software constructs. The code editor comprises a code assistant that is invokable by the user, in which the code assistant comprises a plurality of panels that correspond to the plurality of software constructs. One or more of the plurality of panels contain a set of user-selectable options associated with a given software construct to assist the user in editing the software code.

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 computer program product and method of visual cues is provided through the use of query templates with functional template blocks to assist in building queries by giving visual cues about valid options, expected constructs, and required syntax. The one or more visual cues each have one or more of a valid option, expected construct, and required syntax. The invention provides a graphic user interface display to assist a builder in query creation.

Abstract: A method for providing a query builder for at least one query language is disclosed. The method includes 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: Provided is a method, for generating a tree view of elements in a graphical user interface (GUI). Hierarchical information is processed including information on elements at different hierarchical levels. A tree view is generated in response to processing the hierarchical information enabled to be displayed in a graphical user interface (GUI) including graphical indicators representing elements at different hierarchical levels. In the tree view for at least one hierarchical level, graphical indicators for a subset of the elements at the hierarchical level and a graphical paging control enabling user selection of one of a plurality subset of elements at the hierarchical level are generated. In the tree view, graphical indicators representing elements in a selected subset of elements at one hierarchical level are generated in response to selection of the selected subset through the graphical paging control.

Abstract: A system and computer program product for assisting a user in creating software code. In one implementation, the system includes a display; and a code editor configured to permit a user to edit software code that is displayable on the display. The software code is associated with a programming language having a plurality of software constructs. The code editor comprises a code assistant that is invokable by the user, in which the code assistant comprises a plurality of panels that correspond to the plurality of software constructs. One or more of the plurality of panels contain a set of user-selectable options associated with a given software construct to assist the user in editing the software code.

Abstract: A method for assisting a user in creating software code. In one implementation, the method includes receiving user input editing software code through a code editor, in which the software code is associated with a programming language having a plurality of software constructs. The method further includes receiving user input invoking a code assistant associated with the code editor. The code assistant comprises a plurality of panels that correspond to the plurality of software constructs. One or more of the plurality of panels contain a set of user-selectable options associated with a given software construct to assist the user in editing the software code.

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: 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 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.