| 摘要 |
Method and computer database system for implementing an interactive prompted query system in a database system having a plurality of named database tables which a user can link together for query purposes by entering join statements. The join statements are analyzed by determining that one or more groups of separately linked database table names are referenced in the join statements. If more than one group exists, then the join statements are adjusted so that only a single group of separately linked database table names is referenced by the join statements. The single group of names may be determined by selecting the group which contains the name first entered by the user, by selecting the group which contains the highest number of names, by prompting the user to select the group or by any other logical means. More particularly, the join statements are analyzed using a graphical technique to determine the groups of tables. The tables are represented as nodes and the join relationships are represented as lines. The lines are traced to determine all of the nodes connected to form a single graph. Each graph represents a separately linked group of database tables.
|
