Inventor

ZAIT MOHAMED

US55 patents

⚠️ This page may combine multiple inventors who share the name “ZAIT MOHAMED”. Patents are grouped by organization below to help distinguish them — per-person disambiguation is on the roadmap.

ZAIT MOHAMED

ORACLE INT CORP

Techniques for pruning a data object during operations that join multiple data objects

Automatic discovery and use of column correlations in tables

Automatic SQL tuning advisor

Adaptive memory allocation

Method and mechanism for database partitioning

Partition pruning with composite partitioning

Tracking and maintaining expression statistics across database queries

Auto-tuning SQL statements

Method and system for implementing a SQL profile

Method and mechanism for partition pruning

Parallel partition-wise joins

Techniques for evaluating query predicates during in-memory table scans

Executing alternative plans for a SQL statement

Method and mechanism for database partitioning

SQL structure analyzer

Dynamic and automatic memory management

Triggering hard parses

Delaying evaluation of expensive expressions in a query

Techniques for determining effects on system performance of a memory management parameter

Adaptive cursor sharing

Adaptive query optimization

Leveraging query-specific statistics in non-equivalent queries

SQL execution plan verification

Optimizing execution plans for in-memory-aware joins

Efficient search space analysis for join factorization

Join factorization of union/union all queries

Approximating a database statistic

Merging synopses to determine number of distinct values in large databases

Parallel partition-wise aggregation

Adaptive selection of a distribution method during execution of parallel join operations

Global hints

Memory-aware joins based in a database cluster

Method and system of collecting execution statistics of query statements

Selecting from OR-expansion states of a query

Automated real-time index management

Online optimizer statistics maintenance during load

Extended cursor sharing

Techniques for maintaining statistics in a database system

Statistics based query transformation

Techniques for maintaining statistics in a database system

Automated real-time index management

Creating hybrid and top-frequency histograms

Creating and using data that indicates misestimates of actual costs

Transforming a query by eliminating a subquery

IBM

System and method for defining shapes with which to mine time sequences in computerized databases

System and method for defining shapes with which to mine time sequences in computerized databases

DAS DINESH

SQL execution plan baselines

BELKNAP PETER

SQL execution plan verification

AHMED RAFI

Optimization technique of generalized disjunctive semi/anti join

LEE ALLISON

Method and system for performing query optimization using a hybrid execution plan