Patent ID: 6553371
Filing Date: 2003-04-22
Classification: G06F,Y10S

Abstract:
A software method useable in a computer database system with a display device for inferring and displaying a selection of valid table joins for a relational database query specifying a plurality of user-selected database tables, the method comprising the following steps:(a) assisting in a user's selection of a table join by displaying all user-selected database tables in a join overview diagram and automatically inferring and displaying in a join grid each join grid row having a potential valid table join for a pair of user-selected database tables; (b) accepting the user's selection of a join grid row from the join grid; and (c) responsive to the user's selection of a join grid row from the join grid, placing a join indicator in the join overview diagram between icons representing the pair of user-selected database tables from the user-selected join grid row.