Inventor

PIRAHESH MIR HAMID

US64 patents

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

PIRAHESH MIR HAMID

IBM

Query optimization by transparently altering properties of relational tables using materialized views

Optimization of data repartitioning during parallel query optimization

System and method for constraint checking bulk data in a database

Incremental maintenance of aggregated and join summary tables

Incremental maintenance of summary tables with complex grouping expressions

Parallel query optimization strategies for replicated and partitioned tables

Automatic recognition and rerouting of queries for optimal performance

System and method for selective incremental deferred constraint processing after bulk loading data

Shared nothing parallel execution of procedural constructs in SQL

Efficient implementation of full outer join and anti-join

Supporting dynamic tables in SQL query compilers

Synchronization of SQL actions in a relational database system

System and method for adaptive database caching

System and method for incrementally maintaining non-distributive aggregate functions in a relational database

Star/join query optimization

Optimization of correlated SQL queries in a relational database management system

Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tables

Intelligent compilation of materialized view maintenance for query processing systems

Cube indices for relational database management systems

Support for summary tables in a heterogeneous database environment

Query simplification and optimization involving eliminating grouping column from group by operation corresponds to group by item that is constant

Exploitation of subsumption in optimizing scalar subqueries

Query processing system that computes GROUPING SETS, ROLLUP, and CUBE with a reduced number of GROUP BYs in a query graph model

Evaluation of existential and universal subquery in a relational database management system for increased efficiency

XPath containment for index and materialized view matching

Efficient implementation of typed view hierarchies for ORDBMS

No preprocessor for embedded SQL in a 3GL

Evaluation of existential and universal subquery in a relational database management system for increased efficiency

Intelligent compilation of procedural functions for query processing systems

Intelligent compilation of scripting language for query processing systems

System, method and computer program product for passing host variables to a database management system

Method, system, and program for specifying multidimensional calculations for a relational OLAP engine

Canonical abstraction for outerjoin optimization

System and method for transforming queries using window aggregation

Method, system, and program for query optimization with algebraic rules

Matching and compensation tests for optimizing correlated subqueries within query using automatic summary tables

Outerjoin and antijoin reordering using extended eligibility lists

Database system and method for supporting current of cursor updates and deletes from a select query from one or more updatable tables in single node and MPP environments

Database system and method for supporting current of cursor updates and deletes from a select query from one or more updatable tables in single node and mpp environments

Method of performing a parallel relational database query in a multiprocessor environment

System, method, and computer program product for progressive query processing

Method, system and program for executing a query having a UNION operator

System, method, and computer program product for progressive query processing

Method for providing a system maintained materialized functionally dependent column for a database management system

No preprocessor and a source level debugger for embedded SQL in a 3GL

System and method for adaptive database caching

Executing graph path queries

Efficient join with one or more large dimension tables

Method, system, and program for query optimization with algebraic rules

BALMIN ANDREY

Graph search system and method for querying loosely integrated data