Patents by Inventor Joseph J. Sordi

Joseph J. Sordi has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Patent number: 4506326
    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.
    Type: Grant
    Filed: February 28, 1983
    Date of Patent: March 19, 1985
    Assignee: International Business Machines Corporation
    Inventors: Philip S. Shaw, Joseph J. Sordi, Irving L. Traiger