04506326 is referenced by 96 patents and cites 1 patents.

A linear query for accessing a relation data base in computer storage is synthesized from a graphic query input at a user terminal. The graphic query may be one of a combined print query, a target print query, an insert query, a delete query, or an update query. According to one embodiment, the linear query is expressed in Structured Query Language (SQL) syntax, and the graphic query in Query By Example (QBE) syntax. Responsive to a QBE combined print query or target print query, an SQL select query is generated comprising the UNION of one or more generated select statements. Responsive to a QBE delete query, an SQL delete query is generated from the logical OR of generated condition statements including an outer query DELETE and a SELECT* subquery. Responsive to a QBE update query, an SQL update query is generated including a SET clause and any generated WHERE clause and subquery. Responsive to a QBE insert query, an SQL insert query is generated to include an INSERT statement and any generated SELECT statement.

Title
Apparatus and method for synthesizing a query for accessing a relational data base
Application Number
6/470821
Publication Number
4506326
Application Date
February 28, 1983
Publication Date
March 19, 1985
Inventor
Irving L Traiger
San Jose
CA, US
Joseph J Sordi
Los Gatos
CA, US
Philip S Shaw
San Jose
CA, US
Agent
Shelley M Beckstrand
Assignee
International Business Machines Corporation
NY, US
IPC
G06F 15/40
View Original Source