Cost-based optimizations for join queries with union all views and derived tables

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 11113283
APP PUB NO 20190188299A1
SERIAL NO

15844685

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A query having a Union All view is identified. A logical join between Union AH view/derived table and other tables is broken down into multiple physical joins. The physical joins are pushed to the branches. Cost-based processing statistics are obtained for the branches. An optimal plan for the joins is selected based on the statistics; representing an optimal query execution for the query. The optimal query execution plan is provided to a database engine for executing the optimal query execution plan against a data warehouse.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

  • TERADATA US, INC.

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Al-Kateb, Mohammed Rolling Hills Estates, US 17 61
Au, Grace Kwan-On Rancho Palos Verdes, US 21 177
Korlapati, Rama Krishna El Segundo, US 11 80
Ma, Lu Tenafly, US 30 294
Nair, Sanjay El Segundo, US 27 184

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation

Maintenance Fees

Fee Large entity fee small entity fee micro entity fee due date
3.5 Year Payment $1600.00 $800.00 $400.00 Mar 7, 2025
7.5 Year Payment $3600.00 $1800.00 $900.00 Mar 7, 2029
11.5 Year Payment $7400.00 $3700.00 $1850.00 Mar 7, 2033
Fee Large entity fee small entity fee micro entity fee
Surcharge - 3.5 year - Late payment within 6 months $160.00 $80.00 $40.00
Surcharge - 7.5 year - Late payment within 6 months $160.00 $80.00 $40.00
Surcharge - 11.5 year - Late payment within 6 months $160.00 $80.00 $40.00
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