Computer automated system and method for optimizing the processing of a query in a relational database system by merging subqueries with the query
US5367675A · kind A · utility
171Cited by
4References
18Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 13, 1991 |
| Grant date | Nov 22, 1994 |
| Priority date | — |
| Expiry date | Dec 13, 2011 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99932
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An automated method is provided for optimizing a query for retrieving data from a relational database in a computer relational database management system. The method uses rules for identifying queries for which duplicates are a factor in retrieving the proper data from the database. The method then merges queries with table expressions, views and subqueries when possible without causing duplicates to be unnecessarily retrieved.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.