Apparatus and method for synthesizing a query for accessing a re

Details Apparatus and method for synthesizing a query for accessing a re Apparatus and method for synthesizing a query for accessing a re

1983-02-28

1985-03-19

Zache, Raulfe B.

Boots, shoes, and leggings

364900, G06F 1540

Patent

active

045063265

ABSTRACT:
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.

REFERENCES:
patent: 4283771 (1981-08-01), Chang
SQL/Data System Terminal User's Guide, IBM Publication SH24-5016-0.
SQL/Data System Application Programming, IBM Publication SH24-5018-0.
M. W. Blasgen et al., "System R: An Architectural Overview", IBM System Journal, vol. 20, No. 1, 1981, p. 41ff.
Query-by-Example Terminal User's Guide, IBM Publication SH20-2078-0.
M. M. Zloof, "Query-by-Example: A Data Base Language", IBM System Journal, vol. 16, No. 4, 1977, p. 324ff.
D. J. McLeod, "Sequel and Query-by-Example: Translation and Compatibility", IBM Publication RJ 1730, No. 25348, Feb. 27, 1976.

Affiliated with

Also associated with

Rating

Apparatus and method for synthesizing a query for accessing a re does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Apparatus and method for synthesizing a query for accessing a re, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for synthesizing a query for accessing a re will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-756334