METHOD AND SYSTEM FOR SPECIFYING AND DISPLAYING TABLE JOINS IN RELATIONAL DATABASE QUERIES

METHOD AND SYSTEM FOR SPECIFYING AND DISPLAYING TABLE JOINS IN RELATIONAL DATABASE QUERIES

A system, a program storage device and a software method, useable in a computer database system with a display device, is provided for displaying and selecting table joins. The method is capable of assisting in a user's selection of a table join by displaying all user-selected database tables i...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: GUTIERREZ-RIVAS HUMBERTO, ISMERIO FERNANDO CARDOSO, PAYTON BRIAN GERRIT
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:A system, a program storage device and a software method, useable in a computer database system with a display device, is provided for displaying and selecting table joins. The method is capable of 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. The method accepts the user's selection of a join grid row from the join grid, and, in response, places 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. The user's join grid row selection is performed with a single operation.