05519859 is referenced by 77 patents and cites 8 patents.

A method and apparatus is provided for generating structured query language instructions for communication to a database. In response to receipt of user-supplied input dimensions, an output table is automatically selected that represents the user's query of the relational database. The system automatically identifies and generates the links between data in predefined data tables within the database and the automatically selected output table. From the output table and data links, structured query language instructions are automatically generated. A technique is included to select the minimum number of tables reflective of the input dimensions. Each link between the input data tables and the output table is checked bi-directionally to ensure the integrity of the table selected.

Title
Method and apparatus for automatic table selection and generation of structured query language instructions
Application Number
8/153136
Publication Number
5519859
Application Date
November 15, 1993
Publication Date
May 21, 1996
Inventor
John A Grace
616 N. York, Hinsdale, 60521
IL, US
Agent
Willian Brinks Hofer Gilson & Lione
IPC
G06F 17/30
View Original Source