Mohamed ZAIT

Person

San Jose, CA, US

People

Patents Grantslast 30 patents

Information Patent Grant
Techniques for maintaining statistics in a database system
- Patent number 12,147,440
- Issue date Nov 19, 2024
- Oracle International Corporation
- Mohamed Zait
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Statistics based query transformation
- Patent number 11,561,973
- Issue date Jan 24, 2023
- Oracle International Corporation
- Sunil P. Chakkappen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Techniques for maintaining statistics in a database system
- Patent number 11,468,073
- Issue date Oct 11, 2022
- Oracle International Corporation
- Mohamed Zait
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Creating hybrid and top-frequency histograms
- Patent number 11,403,295
- Issue date Aug 2, 2022
- Oracle International Corporation
- Sunil P. Chakkappen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Leveraging query-specific statistics in non-equivalent queries
- Patent number 11,321,317
- Issue date May 3, 2022
- Oracle International Corporation
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Online optimizer statistics maintenance during load
- Patent number 11,113,282
- Issue date Sep 7, 2021
- Oracle International Corporation
- Sunil P. Chakkappen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Automated real-time index management
- Patent number 11,068,460
- Issue date Jul 20, 2021
- Oracle International Corporation
- Mohamed Zait
- 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
Database system feature management
- Patent number 10,599,651
- Issue date Mar 24, 2020
- Oracle International Corporation
- Mohamed Zait
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Tracking and maintaining expression statistics across database queries
- Patent number 10,372,706
- Issue date Aug 6, 2019
- Oracle International Corporation
- Shasank K. Chavan
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
One-pass join size estimation with correlated sampling
- Patent number 10,353,897
- Issue date Jul 16, 2019
- Oracle International Corporation
- David Vengerov
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
SQL execution plan verification
- Patent number 10,229,158
- Issue date Mar 12, 2019
- Oracle International Corporation
- Peter Belknap
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Techniques for evaluating query predicates during in-memory table s...
- Patent number 10,216,794
- Issue date Feb 26, 2019
- Oracle International Corporation
- Dinesh Das
- 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
Optimizing execution plans for in-memory-aware joins
- Patent number 10,025,822
- Issue date Jul 17, 2018
- Oracle International Corporation
- Dinesh Das
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Techniques for evaluating query predicates during in-memory table s...
- Patent number 10,025,823
- Issue date Jul 17, 2018
- Oracle International Corporation
- Dinesh Das
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Adaptive selection of a distribution method during execution of par...
- Patent number 10,019,481
- Issue date Jul 10, 2018
- Oracle International Corporation
- Unmesh Jagtap
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Memory-aware joins based in a database cluster
- Patent number 10,002,148
- Issue date Jun 19, 2018
- Oracle International Corporation
- Niloy Mukherjee
- 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
Approximate distinct counting in a bounded memory
- Patent number 9,852,185
- Issue date Dec 26, 2017
- Oracle International Corporation
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Triggering hard parses
- Patent number 9,727,609
- Issue date Aug 8, 2017
- Oracle International Corporation
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Adaptive query optimization
- Patent number 9,720,967
- Issue date Aug 1, 2017
- Oracle International Corporation
- Allison W. Lee
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Creating and using data that indicates misestimates of actual costs
- Patent number 9,471,631
- Issue date Oct 18, 2016
- Oracle International Corporation
- Sunil P. Chakkappen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
SQL execution plan baselines
- Patent number 9,189,522
- Issue date Nov 17, 2015
- Oracle International Corporation
- Dinesh Das
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
SQL execution plan baselines
- Patent number 9,058,356
- Issue date Jun 16, 2015
- Oracle International Corporation
- Dinesh Das
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Method and system for performing query optimization using a hybrid...
- Patent number 8,903,805
- Issue date Dec 2, 2014
- Oracle International Corporation
- Allison Lee
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
SQL execution plan verification
- Patent number 8,700,608
- Issue date Apr 15, 2014
- Oracle International Corporation
- Peter Belknap
- 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
Executing alternative plans for a SQL statement
- Patent number 7,877,373
- Issue date Jan 25, 2011
- Oracle International Corporation
- Mohamed Zait
- 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

Patents Applicationslast 30 patents

Information Patent Application
PROCESSING DYNAMIC STATISTICS FOR EXPENSIVE QUERIES
- Publication number 20220215026
- Publication date Jul 7, 2022
- ORACLE INTERNATIONAL CORPORATION
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TECHNIQUES FOR MAINTAINING STATISTICS IN A DATABASE SYSTEM
- Publication number 20220012240
- Publication date Jan 13, 2022
- ORACLE INTERNATIONAL CORPORATION
- Mohamed Zait
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
AUTOMATED REAL-TIME INDEX MANAGEMENT
- Publication number 20210303539
- Publication date Sep 30, 2021
- ORACLE INTERNATIONAL CORPORATION
- Mohamed Zait
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
AUTOMATED REAL-TIME INDEX MANAGEMENT
- Publication number 20200042524
- Publication date Feb 6, 2020
- MOHAMED ZAIT
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TECHNIQUES FOR MAINTAINING STATISTICS IN A DATABASE SYSTEM
- Publication number 20200042522
- Publication date Feb 6, 2020
- ORACLE INTERNATIONAL CORPORATION
- Mohamed Zait
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
STATISTICS BASED QUERY TRANSFORMATION
- Publication number 20190102428
- Publication date Apr 4, 2019
- ORACLE INTERNATIONAL CORPORATION
- Sunil P. Chakkappen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
ONLINE OPTIMIZER STATISTICS MAINTENANCE DURING LOAD
- Publication number 20190102427
- Publication date Apr 4, 2019
- ORACLE INTERNATIONAL CORPORATION
- Sunil P. Chakkappen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TECHNIQUES FOR EVALUATING QUERY PREDICATES DURING IN-MEMORY TABLE S...
- Publication number 20180232417
- Publication date Aug 16, 2018
- ORACLE INTERNATIONAL CORPORATION
- DINESH DAS
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
LEVERAGING QUERY-SPECIFIC STATISTICS IN NON-EQUIVALENT QUERIES
- Publication number 20170357692
- Publication date Dec 14, 2017
- ORACLE INTERNATIONAL CORPORATION
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DATABASE SYSTEM FEATURE MANAGEMENT
- Publication number 20170116230
- Publication date Apr 27, 2017
- ORACLE INTERNATIONAL CORPORATION
- Mohamed ZAIT
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
CREATING HYBRID AND TOP-FREQUENCY HISTOGRAMS
- Publication number 20170031990
- Publication date Feb 2, 2017
- ORACLE INTERNATIONAL CORPORATION
- Sunil P. Chakkappen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TRACKING AND MAINTAINING EXPRESSION STATISTICS ACROSS DATABASE QUERIES
- Publication number 20170031967
- Publication date Feb 2, 2017
- ORACLE INTERNATIONAL CORPORATION
- Shasank K. Chavan
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
APPROXIMATE DISTINCT COUNTING IN A BOUNDED MEMORY
- Publication number 20170024387
- Publication date Jan 26, 2017
- ORACLE INTERNATIONAL CORPORATION
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
ONE-PASS JOIN SIZE ESTIMATION WITH CORRELATED SAMPLING
- Publication number 20160378829
- Publication date Dec 29, 2016
- ORACLE INTERNATIONAL CORPORATION
- David VENGEROV
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
OPTIMIZING EXECUTION PLANS FOR IN-MEMORY-AWARE JOINS
- Publication number 20160350375
- Publication date Dec 1, 2016
- ORACLE INTERNATIONAL CORPORATION
- DINESH DAS
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TECHNIQUES FOR EVALUATING QUERY PREDICATES DURING IN-MEMORY TABLE S...
- Publication number 20160350347
- Publication date Dec 1, 2016
- ORACLE INTERNATIONAL CORPORATION
- DINESH DAS
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
MEMORY-AWARE JOINS BASED IN A DATABASE CLUSTER
- Publication number 20160026667
- Publication date Jan 28, 2016
- ORACLE INTERNATIONAL CORPORATION
- Niloy Mukherjee
- 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
METHOD AND SYSTEM FOR PERFORMING QUERY OPTIMIZATION USING A HYBRID...
- Publication number 20150088857
- Publication date Mar 26, 2015
- ORACLE INTERNATIONAL CORPORATION
- Allison LEE
- 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
ADAPTIVE SELECTION OF A DISTRIBUTION METHOD DURING EXECUTION OF PAR...
- Publication number 20140280023
- Publication date Sep 18, 2014
- Unmesh Jagtap
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SQL EXECUTION PLAN VERIFICATION
- Publication number 20140236921
- Publication date Aug 21, 2014
- ORACLE INTERNATIONAL CORPORATION
- Peter Belknap
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TRIGGERING HARD PARSES
- Publication number 20140095475
- Publication date Apr 3, 2014
- ORACLE INTERNATIONAL CORPORATION
- Hong Su
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
CREATING AND USING DATA THAT INDICATES MISESTIMATES OF ACTUAL COSTS
- Publication number 20140095474
- Publication date Apr 3, 2014
- ORACLE INTERNATIONAL CORPORATION
- Sunil P. Chakkappen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
ADAPTIVE QUERY OPTIMIZATION
- Publication number 20140095472
- Publication date Apr 3, 2014
- ORACLE INTERNATIONAL CORPORATION
- Allison W. Lee
- 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
METHOD AND SYSTEM FOR PERFORMING QUERY OPTIMIZATION USING A HYBRID...
- Publication number 20120047158
- Publication date Feb 23, 2012
- ORACLE INTERNATIONAL CORPORATION
- Allison LEE
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
COMPUTING SELECTIVITIES FOR GROUP OF COLUMNS AND EXPRESSIONS
- Publication number 20100030728
- Publication date Feb 4, 2010
- Oracle International Corporation
- Sunil P. Chakkappen
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SQL Execution Plan Baselines
- Publication number 20090106306
- Publication date Apr 23, 2009
- Dinesh Das
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SQL Execution Plan Verification
- Publication number 20090106219
- Publication date Apr 23, 2009
- Peter Belknap
- G06 - COMPUTING CALCULATING COUNTING

Mohamed ZAIT

Person

Patents Grantslast 30 patents

Techniques for maintaining statistics in a database system

Statistics based query transformation

Techniques for maintaining statistics in a database system

Creating hybrid and top-frequency histograms

Leveraging query-specific statistics in non-equivalent queries

Online optimizer statistics maintenance during load

Automated real-time index management

Optimization technique of generalized disjunctive semi/anti join

Database system feature management

Tracking and maintaining expression statistics across database queries

One-pass join size estimation with correlated sampling

SQL execution plan verification

Techniques for evaluating query predicates during in-memory table s...

Transforming a query by eliminating a subquery

Optimizing execution plans for in-memory-aware joins

Techniques for evaluating query predicates during in-memory table s...

Adaptive selection of a distribution method during execution of par...

Memory-aware joins based in a database cluster

Selecting from OR-expansion states of a query

Approximate distinct counting in a bounded memory

Triggering hard parses

Adaptive query optimization

Creating and using data that indicates misestimates of actual costs

SQL execution plan baselines

SQL execution plan baselines

Method and system for performing query optimization using a hybrid...

SQL execution plan verification

Delaying evaluation of expensive expressions in a query

Executing alternative plans for a SQL statement

Efficient search space analysis for join factorization

Patents Applicationslast 30 patents

PROCESSING DYNAMIC STATISTICS FOR EXPENSIVE QUERIES

TECHNIQUES FOR MAINTAINING STATISTICS IN A DATABASE SYSTEM

AUTOMATED REAL-TIME INDEX MANAGEMENT

AUTOMATED REAL-TIME INDEX MANAGEMENT

TECHNIQUES FOR MAINTAINING STATISTICS IN A DATABASE SYSTEM

STATISTICS BASED QUERY TRANSFORMATION

ONLINE OPTIMIZER STATISTICS MAINTENANCE DURING LOAD

TECHNIQUES FOR EVALUATING QUERY PREDICATES DURING IN-MEMORY TABLE S...

LEVERAGING QUERY-SPECIFIC STATISTICS IN NON-EQUIVALENT QUERIES

DATABASE SYSTEM FEATURE MANAGEMENT

CREATING HYBRID AND TOP-FREQUENCY HISTOGRAMS

TRACKING AND MAINTAINING EXPRESSION STATISTICS ACROSS DATABASE QUERIES

APPROXIMATE DISTINCT COUNTING IN A BOUNDED MEMORY

ONE-PASS JOIN SIZE ESTIMATION WITH CORRELATED SAMPLING

OPTIMIZING EXECUTION PLANS FOR IN-MEMORY-AWARE JOINS

TECHNIQUES FOR EVALUATING QUERY PREDICATES DURING IN-MEMORY TABLE S...

MEMORY-AWARE JOINS BASED IN A DATABASE CLUSTER

Selecting From OR-Expansion States Of A Query

METHOD AND SYSTEM FOR PERFORMING QUERY OPTIMIZATION USING A HYBRID...

TRANSFORMING A QUERY BY ELIMINATING A SUBQUERY

ADAPTIVE SELECTION OF A DISTRIBUTION METHOD DURING EXECUTION OF PAR...

SQL EXECUTION PLAN VERIFICATION

TRIGGERING HARD PARSES

CREATING AND USING DATA THAT INDICATES MISESTIMATES OF ACTUAL COSTS

ADAPTIVE QUERY OPTIMIZATION

OPTIMIZATION TECHNIQUE OF GENERALIZED DISJUNCTIVE SEMI/ANTI JOIN

METHOD AND SYSTEM FOR PERFORMING QUERY OPTIMIZATION USING A HYBRID...

COMPUTING SELECTIVITIES FOR GROUP OF COLUMNS AND EXPRESSIONS

SQL Execution Plan Baselines

SQL Execution Plan Verification