Inventor

ZIAUDDIN MOHAMED

US47 patents

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

ZIAUDDIN MOHAMED

ORACLE INT CORP

Systems and methods of optimizing database queries for efficient delivery of query data subsets

Automatic SQL tuning advisor

SQL tuning sets

Self-managing database architecture

Optimizer dynamic sampling

Auto-tuning SQL statements

Method and system for implementing a SQL profile

Techniques for using zone map information for post index access pruning

Pruning disk blocks of a clustered table in a relational database management system

Query optimization with switch predicates

SQL structure analyzer

Techniques for partition pruning based on aggregated zone map information

Maintaining staleness information for aggregate data

Query optimizer cost model

SQL execution plan verification

Clustering a table in a relational database management system

Global hints

Dual purpose zone maps

Efficient SQL-based graph random walk

Bitmap-based count distinct query rewrite in a relational SQL algebra

Parallel execution of queries with a recursive clause

Automatic prevention of plan regressions

Efficient SQL-based graph random walk

Outer semi join for disjunctive subquery unnesting

Method and system to implement error handling with fine-grained SQL hints

Static data caching for queries with a clause that requires multiple iterations to execute

Automatic error mitigation in database statements using alternate plans

Automatic creation and maintenance of zone maps

Pruning disk blocks in a relational database management system

Densification of expression value domain for efficient bitmap-based count(distinct) in SQL

Efficient data retrieval based on aggregate characteristics of composite tables

Efficient data retrieval in staged use of in-memory cursor duration temporary tables

ORACLE CORP

Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer

Rewriting a query in terms of a summary based on functional dependencies and join backs, and based on join derivability

Method and apparatus for efficiently refreshing sets of summary tables and materialized views in a database management system

Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer

Rewriting a query in terms of a summary based on aggregate computability and canonical format, and when a dimension table is on the child side of an outer join

Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins

Rewriting queries to access materialized views that group along an ordered dimension

Techniques for handling function-defined hierarchical dimensions

Method and apparatus for determining distinct cardinality dual hash bitmaps

DAS DINESH

SQL execution plan baselines

Maintaining and utilizing SQL execution plan histories

DAGEVILLE BENOIT

Automatic recognition and capture of SQL execution plans

BELKNAP PETER

SQL execution plan verification

LAWANDE SHILPA

Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer

RAMACHER MARK

SQL tuning base