Inventor
PIRAHESH MIR H
US15 patents
Patents
15 patentsUS5548755AAug 20, 1996
System for optimizing correlated SQL queries in a relational database using magic decorrelation
IBM153 citations98
US5546576AAug 13, 1996
Query optimizer system that detects and prevents mutating table violations of database integrity in a query before execution plan generation
IBM167 citations98
US5280612AJan 18, 1994
Multiple version database concurrency control system
IBM321 citations98
US5590324ADec 31, 1996
Optimization of SQL queries using universal quantifiers, set intersection, and max/min aggregation in the presence of nullable columns
IBM113 citations96
US5557791ASep 17, 1996
Outer join operations using responsibility regions assigned to inner tables in a relational database
IBM89 citations96
US5548754AAug 20, 1996
Optimization of SQL queries using early-out join transformations
IBM61 citations96
US5548758AAug 20, 1996
Optimization of SQL queries using early-out join transformations of column-bound relational tables
IBM91 citations96
US5367675ANov 22, 1994
Computer automated system and method for optimizing the processing of a query in a relational database system by merging subqueries with the query
IBM219 citations96
US5615361AMar 25, 1997
Exploitation of uniqueness properties using a 1-tuple condition for the optimization of SQL queries
IBM68 citations93
US5546570AAug 13, 1996
Evaluation strategy for execution of SQL queries involving recursion and table queues
IBM68 citations93
US5551031AAug 27, 1996
Program storage device and computer program product for outer join operations using responsibility regions assigned to inner tables in a relational database
IBM52 citations92
US7505957B2Mar 17, 2009
Incremental AST maintenance using work areas
IBM3 citations62
US10503731B2Dec 10, 2019
Efficient analysis of distinct aggregations
IBM1 citations58
US9774682B2Sep 26, 2017
Parallel data streaming between cloud-based applications and massively parallel systems
IBM0 citations46
US10642741B2May 5, 2020
Accessing tables with heterogeneous partitions
IBM0 citations38