System for composing a graphical interface to a relational database which displays a network of query and source icons

Claim 3

The method of claim 1, wherein said constructing step comprises steps of: displaying a palette of icons including an icon generically representing a source table, and a plurality of other icons generically representing respective relational query operators; selecting one of said icons in response to input from a user; displaying a copy of said icon as a new node in said network; and interconnecting said new node to other nodes in said network in response to input from said user.

Claim 4

The method of claim 2, wherein said constructing step further comprises steps of: selecting a node in said network, in response to input from said user; and associating criteria with said selected node in response to input from said user.

Claim 5

The method of claim 3, wherein said associating step includes the steps of: displaying a request for criteria for said selected node; accepting information representing said criteria from said user in response to said displayed request; and associating said criteria representative information with said selected node.

Claim 6

The method of claim 4, wherein if said selected node is a generic source table representative node, said step of displaying a request comprises the step of displaying a listing of names of said plurality of source tables in a dialog box.

Claim 7

The method of claim 4, wherein if said selected node is a generic relational query operator representative node, said step of displaying a request comprises the step of displaying a dialog box requesting parameters relating to said the relational query operator represented by said selected node.

Claim 8

The method of claim 2, wherein if said selected icon is said generic source table representative icon, said step of displaying a copy of said icon comprises the step of displaying a generic source table representative node including said output icon representing contents of the source table represented by that node.

Claim 9

The method of claim 2, wherein if said selected icon is one of said plurality of other icons generically representing respective relational query operators, said step of displaying a copy of said icon comprises the step of displaying a relational query operator representative node including an input terminal representing an input table to be operated upon, and said output icon representing an output table containing the result of performing the relational query operation represented by said node on the input table to said node.

Claim 10

The method of claim 2, wherein if said selected icon is one of a subset of said plurality of other icons generically representing respective relational query operator, said step of displaying a copy of said icon comprises the step of displaying a relational query operator representative node including a first and a second input terminal representing respective input tables to be operated upon, and an output icon representing an output table containing the result of performing the relational query operator represented by said node on the respective input tables to said node.

Claim 11

The method of claim 2, wherein: one of said plurality of other icons generically representing respective relational query operators represents a sort operation; and if said selected icon is said sort operation representative icon, said step of displaying a copy of said icon comprises a step of displaying a sort operation representative node including an input terminal representing an input table to be sorted.

Claim 13

The method of claim 2, wherein said step of selecting one of said icons comprises steps of: displaying a menu including choices of available icons for said network; and accepting information from said user representing a desired icon.

Claim 14

The method of claim 12, wherein one of said choices is to add a generic source table representative node to said network.

Claim 15

The method of claim 3, wherein predetermined pairs of said plurality of source tables are related, and said step of selecting one of said icons comprises steps of: selecting a node in said network, in response to input from said user; displaying a menu including choices of available icons for said network, wherein one of said choices is to add a generic source table representative node to said network which is related to said selected node; and accepting information from said user representing a desired icon.

Claim 16

The method of claim 1, comprising further steps of: specifying a node in said network in response to input from a user; selecting from a menu a desired type of information related to said specified node in response to input from said user; and displaying said desired type of information.

Claim 17

The method of claim 15, wherein said step of selecting a desired type of information comprises steps of: displaying said menu including choices of available information related to said selected node; and accepting information from said user representing said desired type of information.

Claim 18

The method of claim 15, wherein a desired type of information includes metadata describing the structure of the data resulting from operation of said selected node.

Claim 19

The method of claim 15, wherein a desired type of information includes said generated query corresponding to said selected node.

Claim 20

The method of claim 15, wherein a desired type of information includes a result of operation of said selected node.

Claim 21

The method of claim 1, wherein said step of constructing comprises a step of annotating said network in response to input from a user.

Claim 22

The method of claim 1, wherein said generating step generates said query in SQL.

Claim 23

Apparatus for graphically composing a query of a preexisting independent relational data base system, comprising: means for storing data belonging in said data base system; means, coupled to said data storing means and responsive to a query, for retrieving data stored in said data storing means, and generating a result of said query; means for displaying said result of said query; means, responsive to input from a user, for constructing a graphically displayed network of interconnected nodes generically representing source tables and relational query operators, respectively, each table node including an output icon representing contents of said represented source table, and each operator node including an output icon representing a table containing the result of said represented relational query operator; and means, responsive to said network constructing means, for automatically generating said query corresponding to a designated node in the network.

Claim 24

Apparatus for graphically composing a query of a preexisting independent relational data base system, comprising: means for storing data belonging in said data base system; means, coupled to said data storing means and responsive to a query, for retrieving data stored in said data storing means, and generating a result of said query; means for displaying said result of said query; means, responsive to input from a user, for constructing a graphically displayed network of interconnected nodes generically representing source tables and relational query operators, respectively, each table node including an output icon representing contents of said represented source table, and each operator node including an output icon representing a table containing the result of said represented relational query operator; and means, responsive to said network constructing means, for automatically generating said query corresponding to a designated node in the network.

Claim 25

The apparatus of claim 22, wherein: said data storing means comprises means for storing information representing the structure of said data.