09552392 cites 1 patents.

A nested database query can be optimized by effectively representing a filtering function or operation (e.g., SQL filtering operation) of its outer sub-query by a qualification or qualify operation (e.g., SQL qualification operation) associated with at least one windowing function of at least one of its inner sub-queries. It will be appreciated that this representation can yield a modified query that would be equivalent (e.g., semantically equivalent) to the original nested query as its execution can produce the same results when optimization rules are applied.

Title
Optimizing nested database queries that include windowing operations
Application Number
13/340665
Publication Number
9552392 (B2)
Application Date
December 29, 2011
Publication Date
January 24, 2017
Inventor
Ahmad Ghazal
Redondo Beach
CA, US
Agent
Ramin Mahboubian
Assignee
Teradata US
OH, US
IPC
G06F 15/16
G06F 17/30
View Original Source