Rafi Ahmed

Person

Fremont, CA, US

People

Patents Grantslast 30 patents

Information Patent Grant
Outer semi join for disjunctive subquery unnesting
- Patent number 12,197,439
- Issue date Jan 14, 2025
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Automatic partitioning of materialized views
- Patent number 12,135,719
- Issue date Nov 5, 2024
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Join-based containment for set operation-based sub query removal
- Patent number 11,714,810
- Issue date Aug 1, 2023
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Automatic generation of materialized views
- Patent number 11,615,107
- Issue date Mar 28, 2023
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Materialized view rewrite technique for one-sided outer-join queries
- Patent number 11,086,868
- Issue date Aug 10, 2021
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimization technique of generalized disjunctive semi/anti join
- Patent number 10,726,010
- Issue date Jul 28, 2020
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Sort-merge band join optimization
- Patent number 10,635,671
- Issue date Apr 28, 2020
- Oracle International Corporation
- Lei Sheng
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Duplicate reduction or elimination with hash join operations
- Patent number 10,572,484
- Issue date Feb 25, 2020
- Oracle International Corporation
- Srikanth Bondalapati
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Redundant group by and distinct removal
- Patent number 10,558,660
- Issue date Feb 11, 2020
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Transforming a query by eliminating a subquery
- Patent number 10,133,776
- Issue date Nov 20, 2018
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Outer-joined and cross-joined table elimination for duplicate-insig...
- Patent number 9,965,516
- Issue date May 8, 2018
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Selecting from OR-expansion states of a query
- Patent number 9,870,390
- Issue date Jan 16, 2018
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Transforming a single-table join predicate into a pseudo-join predi...
- Patent number 8,554,761
- Issue date Oct 8, 2013
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Technique of decorrelation of lateral views
- Patent number 8,548,983
- Issue date Oct 1, 2013
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Transforming correlated scalar subqueries
- Patent number 8,521,723
- Issue date Aug 27, 2013
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Techniques for bushy tree execution plans for snowstorm schema
- Patent number 8,438,152
- Issue date May 7, 2013
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Table elimination optimizations
- Patent number 8,352,461
- Issue date Jan 8, 2013
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Table elimination technique for group-by query optimization
- Patent number 8,209,322
- Issue date Jun 26, 2012
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Techniques for coalescing subqueries
- Patent number 8,150,865
- Issue date Apr 3, 2012
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Join predicate push-down optimizations
- Patent number 7,945,562
- Issue date May 17, 2011
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Technique for removing subquery in group by—having clauses using wi...
- Patent number 7,945,560
- Issue date May 17, 2011
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Delaying evaluation of expensive expressions in a query
- Patent number 7,877,379
- Issue date Jan 25, 2011
- Oracle International Corporation
- Allison Waingold
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Multi-tiered query processing techniques for minus and intersect op...
- Patent number 7,814,091
- Issue date Oct 12, 2010
- Oracle International Corporation
- Bhaskar Ghosh
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Selecting candidate queries
- Patent number 7,814,042
- Issue date Oct 12, 2010
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Efficient search space analysis for join factorization
- Patent number 7,809,713
- Issue date Oct 5, 2010
- Oracle International Corporation
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Efficient interaction among cost-based transformations
- Patent number 7,702,627
- Issue date Apr 20, 2010
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Null aware anti-join
- Patent number 7,676,450
- Issue date Mar 9, 2010
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Join factorization of union/union all queries
- Patent number 7,644,062
- Issue date Jan 5, 2010
- Oracle International Corporation
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Parallel query processing techniques for minus and intersect operators
- Patent number 7,617,189
- Issue date Nov 10, 2009
- Oracle International Corporation
- Bhaskar Ghosh
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Reusing optimized query blocks in query processing
- Patent number 7,246,108
- Issue date Jul 17, 2007
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING

Patents Applicationslast 30 patents

Information Patent Application
GROUP-BY AND DISTINCT PUSHDOWN INTO UNION-ALL VIEWS
- Publication number 20240289330
- Publication date Aug 29, 2024
- ORACLE INTERNATIONAL CORPORATION
- RAFI AHMED
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
OUTER SEMI JOIN FOR DISJUNCTIVE SUBQUERY UNNESTING
- Publication number 20240126757
- Publication date Apr 18, 2024
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
AUTOMATIC PARTITIONING OF MATERIALIZED VIEWS
- Publication number 20240054131
- Publication date Feb 15, 2024
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SUBSUMPTION OF VIEWS AND SUBQUERIES
- Publication number 20230024553
- Publication date Jan 26, 2023
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
JOIN-BASED CONTAINMENT FOR SET OPERATION-BASED SUBQUERY REMOVAL
- Publication number 20220309062
- Publication date Sep 29, 2022
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
MATERIALIZED VIEW REWRITE TECHNIQUE FOR ONE-SIDED OUTER-JOIN QUERIES
- Publication number 20210124742
- Publication date Apr 29, 2021
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
AUTOMATIC GENERATION OF MATERIALIZED VIEWS
- Publication number 20210026847
- Publication date Jan 28, 2021
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
REDUNDANT GROUP BY AND DISTINCT REMOVAL
- Publication number 20190026332
- Publication date Jan 24, 2019
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SORT-MERGE BAND JOIN OPTIMIZATION
- Publication number 20180101573
- Publication date Apr 12, 2018
- ORACLE INTERNATIONAL CORPORATION
- Lei Sheng
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DUPLICATE REDUCTION OR ELIMINATION WITH HASH JOIN OPERATIONS
- Publication number 20180081946
- Publication date Mar 22, 2018
- ORACLE INTERNATIONAL CORPORATION
- Srikanth BONDALAPATI
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
OUTER-JOINED AND CROSS-JOINED TABLE ELIMINATION FOR DUPLICATE-INSIG...
- Publication number 20150339349
- Publication date Nov 26, 2015
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Selecting From OR-Expansion States Of A Query
- Publication number 20150234888
- Publication date Aug 20, 2015
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TRANSFORMING A QUERY BY ELIMINATING A SUBQUERY
- Publication number 20140379690
- Publication date Dec 25, 2014
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
OPTIMIZATION TECHNIQUE OF GENERALIZED DISJUNCTIVE SEMI/ANTI JOIN
- Publication number 20140067789
- Publication date Mar 6, 2014
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TECHNIQUES FOR COALESCING SUBQUERIES
- Publication number 20100030756
- Publication date Feb 4, 2010
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TECHNIQUE FOR REMOVING SUBQUERY USING WINDOW FUNCTIONS
- Publication number 20090292669
- Publication date Nov 26, 2009
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TECHNIQUES FOR BUSHY TREE EXECUTION PLANS FOR SNOWSTORM SCHEMA
- Publication number 20090112793
- Publication date Apr 30, 2009
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TABLE ELIMINATION OPTIMIZATIONS
- Publication number 20090070315
- Publication date Mar 12, 2009
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TABLE ELIMINATION TECHNIQUE FOR GROUP-BY QUERY OPTIMIZATION
- Publication number 20090055349
- Publication date Feb 26, 2009
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Join factorization of union/union all queries
- Publication number 20070219969
- Publication date Sep 20, 2007
- ORACLE INTERNATIONAL CORPORATION
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Null aware anti-join
- Publication number 20070219952
- Publication date Sep 20, 2007
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Join predicate push-down optimizations
- Publication number 20070219951
- Publication date Sep 20, 2007
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Efficient search space analysis for join factorization
- Publication number 20070219977
- Publication date Sep 20, 2007
- ORACLE INTERNATIONAL CORPORATION
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Efficient interaction among cost-based transformations
- Publication number 20070179947
- Publication date Aug 2, 2007
- Oracle International Corporation
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Delaying evaluation of expensive expressions in a query
- Publication number 20070078812
- Publication date Apr 5, 2007
- ORACLE INTERNATIONAL CORPORATION
- Allison Waingold
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Parallel query processing techniques for minus and intersect operators
- Publication number 20070073642
- Publication date Mar 29, 2007
- Bhaskar Ghosh
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Multi-tiered query processing techniques for minus and intersect op...
- Publication number 20070073643
- Publication date Mar 29, 2007
- Bhaskar Ghosh
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Selecting candidate queries
- Publication number 20060041537
- Publication date Feb 23, 2006
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Reusing optimized query blocks in query processing
- Publication number 20060026115
- Publication date Feb 2, 2006
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Determining query cost based on subquery filtering factor
- Publication number 20060026133
- Publication date Feb 2, 2006
- ORACLE INTERNATIONAL CORPORATION
- Rafi Ahmed
- G06 - COMPUTING CALCULATING COUNTING

Person

Patents Grantslast 30 patents

Outer semi join for disjunctive subquery unnesting

Automatic partitioning of materialized views

Join-based containment for set operation-based sub query removal

Automatic generation of materialized views

Materialized view rewrite technique for one-sided outer-join queries

Optimization technique of generalized disjunctive semi/anti join

Sort-merge band join optimization

Duplicate reduction or elimination with hash join operations

Redundant group by and distinct removal

Transforming a query by eliminating a subquery

Outer-joined and cross-joined table elimination for duplicate-insig...

Selecting from OR-expansion states of a query

Transforming a single-table join predicate into a pseudo-join predi...

Technique of decorrelation of lateral views

Transforming correlated scalar subqueries

Techniques for bushy tree execution plans for snowstorm schema

Table elimination optimizations

Table elimination technique for group-by query optimization

Techniques for coalescing subqueries

Join predicate push-down optimizations

Technique for removing subquery in group by—having clauses using wi...

Delaying evaluation of expensive expressions in a query

Multi-tiered query processing techniques for minus and intersect op...

Selecting candidate queries

Efficient search space analysis for join factorization

Efficient interaction among cost-based transformations

Null aware anti-join

Join factorization of union/union all queries

Parallel query processing techniques for minus and intersect operators

Reusing optimized query blocks in query processing

Patents Applicationslast 30 patents

GROUP-BY AND DISTINCT PUSHDOWN INTO UNION-ALL VIEWS

OUTER SEMI JOIN FOR DISJUNCTIVE SUBQUERY UNNESTING

AUTOMATIC PARTITIONING OF MATERIALIZED VIEWS

SUBSUMPTION OF VIEWS AND SUBQUERIES

JOIN-BASED CONTAINMENT FOR SET OPERATION-BASED SUBQUERY REMOVAL

MATERIALIZED VIEW REWRITE TECHNIQUE FOR ONE-SIDED OUTER-JOIN QUERIES

AUTOMATIC GENERATION OF MATERIALIZED VIEWS

REDUNDANT GROUP BY AND DISTINCT REMOVAL

SORT-MERGE BAND JOIN OPTIMIZATION

DUPLICATE REDUCTION OR ELIMINATION WITH HASH JOIN OPERATIONS

OUTER-JOINED AND CROSS-JOINED TABLE ELIMINATION FOR DUPLICATE-INSIG...

Selecting From OR-Expansion States Of A Query

TRANSFORMING A QUERY BY ELIMINATING A SUBQUERY

OPTIMIZATION TECHNIQUE OF GENERALIZED DISJUNCTIVE SEMI/ANTI JOIN

TECHNIQUES FOR COALESCING SUBQUERIES

TECHNIQUE FOR REMOVING SUBQUERY USING WINDOW FUNCTIONS

TECHNIQUES FOR BUSHY TREE EXECUTION PLANS FOR SNOWSTORM SCHEMA

TABLE ELIMINATION OPTIMIZATIONS

TABLE ELIMINATION TECHNIQUE FOR GROUP-BY QUERY OPTIMIZATION

Join factorization of union/union all queries

Null aware anti-join

Join predicate push-down optimizations

Efficient search space analysis for join factorization

Efficient interaction among cost-based transformations

Delaying evaluation of expensive expressions in a query

Parallel query processing techniques for minus and intersect operators

Multi-tiered query processing techniques for minus and intersect op...

Selecting candidate queries

Reusing optimized query blocks in query processing

Determining query cost based on subquery filtering factor