OPTIMIZATION OF AGGREGATE QUERIES IN DATABASE MANAGEMENT SYSTEMS USING AN EARLY OUT JOIN WHEN PROCESSING MIN AND MAX FUNCTIONS
Patent №
US 9,524,317
Granted
2016-12-20
Filed 2007
Owner
INTERNATIONAL BUSINESS MACHINES CORPORATION
Lab
AI components
4
nlp · kr · planning · hardware
Assignment
Recorded
Dataset
AIPD
2023_r1 edition
Application
11845031
A method, computer program product, and system for optimizing aggregate queries are provided. The method, computer program product, and system provide for receiving an aggregate query comprising a GROUP BY operation and an aggregate function, creating an access plan for executing the aggregate query, the access plan including a join between an outer relation and an inner relation, and designating the join included in the access plan as an early out join.
AI classification
Ownership
INTERNATIONAL BUSINESS MACHINES CORPORATION
assignment · 199210859
Assignors
BRANISH, EDWARD GUST, II, HORNIBROOK, JOHN F., LA, DIEU QUANG, ZUZARTE, CALISTO PAUL
On an employer assignment, the assignors are typically the inventors.