US Patent No: 4,506,326
Number of patents in Portfolio can not be more than 2000
Apparatus and method for synthesizing a query for accessing a relational data base
Stats
-
Mar 19, 1985
Issued date -
Feb 28, 1983
filing date -
06/470,821
serial no -
Expired
status
Importance
Loading Importance Indicators...
Overall
|
US Family Size
|
International Coverage
|
Patent Longevity
|
Forward Citations
|
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.
Loading the Abstract Image...
First Claim
Related Publications
Loading Related Publications...
- 15 United States
- 10 France
- 8 Japan
- 7 China
- 5 Korea
- 2 Other
Patent Owner(s)
| Patent Owner | Address | Total Patents |
|---|---|---|
| INTERNATIONAL BUSINESS MACHINES CORPORATION | ARMONK, NY | 68180 |
International Classification(s)
- [Classification Symbol]
- [Patents Count]
Inventor(s)
| Inventor Name | Address | # of filed Patents | Total Citations |
|---|---|---|---|
| Shaw, Philip S | San Jose, CA | 1 | 96 |
| Sordi, Joseph J | Los Gatos, CA | 1 | 96 |
| Traiger, Irving L | San Jose, CA | 1 | 96 |
Cited Art
| Patent Info | (Count) | # Cites | Year |
|---|---|---|---|
|
|
|||
| 4,283,771 On-chip bubble domain relational data base system | 20 | 1978 | |
Patent Citation Ranking
Forward Cites
| Patent Info | (Count) | # Cites | Year |
|---|---|---|---|
|
|
|||
| 4,897,782 Local cache structure for maintaining updated file characteristics in a file sharing system | 44 | 1987 | |
| 4,888,681 Space management system for data files having shared access | 59 | 1987 | |
| 5,089,985 System and method for performing a sort operation in a relational database manager to pass results directly to a user without writing to disk | 27 | 1988 | |
| 4,956,774 Data base optimizer using most frequency values statistics | 94 | 1988 | |
| 4,965,763 Computer method for automatic extraction of commonly specified information from business correspondence | 188 | 1989 | |
| 5,161,223 Resumeable batch query for processing time consuming queries in an object oriented database management system | 51 | 1989 | |
| 5,161,225 Persistent stream for processing time consuming and reusable queries in an object oriented database management system | 93 | 1989 | |
| 5,210,870 Database sort and merge apparatus with multiple memory arrays having alternating access | 48 | 1990 | |
| 5,077,658 Data access system for a file access processor | 57 | 1990 | |
| 5,257,374 Bus flow control mechanism | 26 | 1991 | |
| 5,237,682 File management system for a computer | 33 | 1991 | |
| 5,386,557 Enforcement of referential constraints in a database system | 45 | 1992 | |
| 5,548,769 Database engine | 14 | 1992 | |
| 5,247,669 Persistent data interface for an object oriented programming system | 48 | 1993 | |
| 5,319,780 System that implicitly locks a subtree or explicitly locks a node based upon whether or not an explicit lock request is issued | 40 | 1993 | |
| 5,454,106 Database retrieval system using natural language for presenting understood components of an ambiguous query on a user interface | 80 | 1993 | |
| 5,608,899 Method and apparatus for searching a database by interactively modifying a database query | 39 | 1993 | |
| 5,504,886 System and method for applying user supplied relation definitions to application files for a relational database | 27 | 1993 | |
| 5,546,526 Reconfiguration of database by interactive manipulation of icons | 20 | 1993 | |
| 5,471,613 Tree structure representation of an SQL clause | 25 | 1994 | |
| 5,418,950 System for interactive clause window construction of SQL queries | 86 | 1994 | |
| 5,557,791 Outer join operations using responsibility regions assigned to inner tables in a relational database | 53 | 1994 | |
| 5,499,368 Scaled depiction of information from a database | 37 | 1994 | |
| 5,548,754 Optimization of SQL queries using early-out join transformations | 36 | 1995 | |
| 5,706,494 System and method for constraint checking bulk data in a database | 48 | 1995 | |
| 5,619,713 Apparatus for realigning database fields through the use of a crosspoint switch | 27 | 1995 | |
| 5,548,758 Optimization of SQL queries using early-out join transformations of column-bound relational tables | 42 | 1995 | |
| 5,551,031 Program storage device and computer program product for outer join operations using responsibility regions assigned to inner tables in a relational database | 32 | 1995 | |
| 5,701,456 System and method for interactively formulating database queries using graphical representations | 26 | 1995 | |
| 5,966,704 Storage plane organization and storage systems based thereon using queries and subqueries for data searching | 19 | 1996 | |
| 5,734,888 Apparatus and method of modifying a database query | 25 | 1997 | |
| 7,143,108 Apparatus and method for deletion of objects from an object-relational system in a customizable and database independent manner | 5 | 2000 | |
|
|
|||
| 4,833,597 Dictionary/directory management method in database system | 17 | 1987 | |
| 5,123,103 Method and system of retrieving program specification and linking the specification by concept to retrieval request for reusing program parts | 45 | 1987 | |
| 5,091,852 System for optimizing query processing in a relational database | 137 | 1989 | |
| 4,967,341 Method and apparatus for processing data base | 39 | 1989 | |
| 5,202,996 Software structuring system and method by data table translation | 17 | 1990 | |
|
|
|||
| 4,888,690 Interactive error handling means in database management | 65 | 1988 | |
| 4,805,099 Retrieval of related records from a relational database | 97 | 1988 | |
| 4,791,561 Interactive construction of means for database maintenance | 99 | 1988 | |
| 5,097,408 Apparatus for specifying a result relation in a relational database system by selection of rows | 22 | 1989 | |
|
|
|||
| 5,495,604 Method and apparatus for the modeling and query of database structures using natural language-like constructs | 28 | 1993 | |
| 5,592,668 Method and apparatus for specifying a query to an information system using natural language-like constructs | 29 | 1995 | |
| 5,574,908 Method and apparatus for generating a query to an information system specified using natural language-like constructs | 8 | 1995 | |
|
|
|||
| 5,555,403 Relational database access system using semantically dynamic objects | 151 | 1991 | |
| 6,578,027 Relational database access system using semantically dynamic objects | 16 | 2001 | |
| 7,899,810 Relational database access system using semantically dynamic objects | 0 | 2007 | |
|
|
|||
| 5,175,814 Direct manipulation interface for Boolean information retrieval | 84 | 1990 | |
| 5,752,016 Method and apparatus for database interrogation using a user-defined table | 12 | 1995 | |
| 5,778,354 Database management system with improved indexed accessing | 60 | 1995 | |
|
|
|||
| 5,664,173 Method and apparatus for generating database queries from a meta-query pattern | 60 | 1995 | |
| 5,787,411 Method and apparatus for database filter generation by display selection | 42 | 1996 | |
| 7,251,669 System and method for database versioning | 7 | 2003 | |
|
|
|||
| 5,412,804 Extending the semantics of the outer join operator for un-nesting queries to a data base | 139 | 1992 | |
| 7,016,903 Method for conditionally updating or inserting a row into a table | 5 | 2001 | |
| 8,311,974 Modularized extraction, transformation, and loading for a database | 0 | 2004 | |
|
|
|||
| 5,586,311 Object oriented data access and analysis system | 26 | 1994 | |
| 5,787,412 Object oriented data access and analysis system | 49 | 1996 | |
| 5,692,175 Decision modeling and analysis for object oriented data access and analysis system | 24 | 1996 | |
|
|
|||
| 7,320,122 Specification to ABAP code converter | 3 | 2004 | |
| 8,250,529 Specification to ABAP code converter | 0 | 2007 | |
|
|
|||
| 6,108,653 Method and apparatus for fast and comprehensive DBMS analysis | 11 | 1998 | |
| 6,584,474 Method and apparatus for fast and comprehensive DBMS analysis | 22 | 2000 | |
|
|
|||
| RE40526 Data processing system and method for retrieving and entity specified in a search path record from a relational database | 0 | 2005 | |
| RE40520 Easily expandable data processing system and method | 1 | 2005 | |
|
|
|||
| 8,005,870 System and method for syntax abstraction in query language generation | 0 | 2001 | |
| 7,430,562 System and method for efficient date retrieval and processing | 9 | 2001 | |
|
|
|||
| 5,584,024 Interactive database query system and method for prohibiting the selection of semantically incorrect query parameters | 138 | 1994 | |
| 5,812,840 Database query system | 107 | 1996 | |
|
|
|||
| 5,212,639 Method and electronic apparatus for the classification of combinatorial data for the summarization and/or tabulation thereof | 17 | 1990 | |
| 5,390,113 Method and electronic apparatus for performing bookkeeping | 47 | 1993 | |
|
|
|||
| 7,089,506 Method for selecting products | 3 | 2001 | |
|
|
|||
| 4,648,036 Method for controlling query and update processing in a database system | 63 | 1985 | |
|
|
|||
| 5,428,776 System for composing a graphical interface to a relational database which displays a network of query and source icons | 98 | 1993 | |
|
|
|||
| 5,239,663 Self-adapting and multifunctional process and structure for the automated evaluation of logical or arithmetic expressions, particularly for extended database consultation | 29 | 1992 | |
|
|
|||
| 5,737,592 Accessing a relational database over the Internet using macro language files | 179 | 1995 | |
|
|
|||
| 4,839,853 Computer information retrieval using latent semantic structure | 216 | 1988 | |
|
|
|||
| 4,829,427 Database query code generation and optimization based on the cost of alternate access methods | 112 | 1984 | |
|
|
|||
| 7,152,073 Method and system for defining sets by querying relational data using a set definition language | 13 | 2003 | |
|
|
|||
| 8,015,222 Virtual repository management | 0 | 2006 | |
|
|
|||
| 5,513,332 Database management coprocessor for on-the-fly providing data from disk media to all without first storing data in memory therebetween | 6 | 1988 | |
|
|
|||
| 5,737,538 System for remote microcomputer access and modification of information in host computer | 12 | 1996 | |
|
|
|||
| 5,276,870 View composition in a data base management system | 137 | 1990 | |
|
|
|||
| 4,769,772 Automated query optimization method using both global and parallel local optimizations for materialization access planning for distributed databases | 240 | 1985 | |
|
|
|||
| 5,894,311 Computer-based visual data evaluation | 85 | 1995 | |
|
|
|||
| 5,283,737 Mechanism for generating linguistic expressions based on synonyms and rules derived from examples | 8 | 1990 | |
|
|
|||
| 5,535,382 Document retrieval system involving ranking of documents in accordance with a degree to which the documents fulfill a retrieval condition corresponding to a user entry | 103 | 1993 | |
|
|
|||
| 7,305,410 Low-latency method to replace SQL insert for bulk data transfer to relational database | 4 | 2003 | |
|
|
|||
| 5,301,313 Manipulating data in a relational data base having operational manipulations defined in an input table and displayed results in an output table with a line displayed designating direction of data flow | 54 | 1991 | |
|
|
|||
| 6,185,560 System for automatically organizing data in accordance with pattern hierarchies therein | 31 | 1998 | |
|
|
|||
| 5,047,918 File management system | 139 | 1988 | |
|
|
|||
| 5,455,948 Method and system for providing data to an application program | 45 | 1994 | |
|
|
|||
| 4,931,928 Apparatus for analyzing source code | 81 | 1988 | |
| 5,008,819 Memory spaced array | 16 | 1989 | |
| 5,625,812 Method of data structure extraction for computer systems operating under the ANSI-92 SQL2 outer join protocol | 5 | 1994 | |
| 5,829,002 System for coordinating information transfer and retrieval | 15 | 1995 | |
Maintenance Fees
| Fee | Large entity fee | small entity fee | micro entity fee | due date |
|---|
| Fee | Large entity fee | small entity fee | micro entity fee |
|---|---|---|---|
| Surcharge after expiration - Late payment is unavoidable | $700.00 | $350.00 | $175.00 |
| Surcharge after expiration - Late payment is unintentional | $1,640.00 | $820.00 | $410.00 |