COMPUTER AUTOMATED SYSTEM AND METHOD FOR OPTIMIZING THE PROCESSING OF A QUERY IN A RELATIONAL DATABASE SYSTEM BY MERGING SUBQUERIES WITH THE QUERY
Patent №
US 5,367,675
Granted
1994-11-22
Filed 1991
Owner
INTERNATIONAL BUSINESS MACHINES CORPORATION
Lab
AI components
4
nlp · kr · planning · hardware
Assignment
Recorded
Dataset
AIPD
2023_r1 edition
Application
07807281
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.
AI classification
Ownership
INTERNATIONAL BUSINESS MACHINES CORPORATION
assignment · 60100221
Assignors
CHENG, JOSEPHINE MIU-KUNG, FINKELSTEIN, SHELDON J., HADERLE, DONALD J., PIRAHESH, MIR HAMID, WANG, YUN
On an employer assignment, the assignors are typically the inventors.