U.S. patents available from 1976 to present.
U.S. patent applications available from 2005 to present.

Comprehensive bilateral translation between SQL and graphically depicted queries

Patent 5428737 Issued on June 27, 1995. Estimated Expiration Date: Icon_subject June 27, 2012. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.

Patent References

Editing of a superblock data structure
Patent #: 4723211
Issued on: 02/02/1988
Inventor: Barker ,   et al.

Direct manipulation interface for Boolean information retrieval Patent #: 5175814
Issued on: 12/29/1992
Inventor: Anick, et al.

Inventors

Application

No. 778048 filed on 10/16/1991

US Classes:

707/4Query formulation, input preparation, or translation

Examiners

Primary: Heckler, Thomas M.

Attorney, Agent or Firm

International Classes

G06F 003/153
G06F 017/30

Abstract

A method, system and program providing comprehensive bilateral translation between text format and visual format relational database queries. In a preferred form, tables and lists are configured to define a common data structure. Translation between structured query language (SQL) query statements and the common data structure is accomplished by clause. Similarly, a common data structure for the visual or graphical format queries is defined, preferably employing graphics symbols and multiple windows. Bidirectional translation is thereafter accomplished through the common data structure. The method, system and program is comprehensive in the SQL clauses available, together with providing full resources for hierarchical subselect clauses.

Other References

  • Database Manager Structured Query Language (SQL) Concepts IBM Copyright 1988, 1990
  • Graphical User Languages For Querying Information: Where To Look For Criteria?, Gabriele Rohr, 1988IEEE, pp. 21-28
  • Design and Implementation of an Interactive Graphical Query Interface for a Relational Database, Bogdan Czejdo, Venugopal Reddy, Marek Rusinkiewicz, 1988 IEEE, pp. 14-20
  • End-User Access to Relational Databases Metaphor Database Server, Art Benjamin and David Rossetti, 1987
  • Engineering with Computers, User Interfaces for Structural Engineering Relational Data Base, H. Craig Howard and Cynthia Stotts Howard, 198
PatentsPlus Images
Enhanced PDF formats
loading...
PatentsPlus: add to cart
PatentsPlus: add to cartSearch-enhanced full patent PDF image
$9.95more info
PatentsPlus: add to cart
PatentsPlus: add to cartIntelligent turbocharged patent PDFs with marked up images
$16.95more info
 
Sign InRegister
Username  
Password   
forgot password?