Inventor · disambiguated record
Mir Hamid Pirahesh
Also filed as: PIRAHESH MIR H · PIRAHESH MIR HAMID
78 granted patents·5,616 citations·filing 1991–2020
99Inventor score
Top patents by PatentIndex Score
78 records- 0197US6112198AOptimization of data repartitioning during parallel query optimizationIBM·Filed 1998·Granted Aug 29, 2000·335 cites·44 claims
- 0296US5822750AOptimization of correlated SQL queries in a relational database management systemIBM·Filed 1997·Granted Oct 13, 1998·345 cites·21 claims
- 0396US5280612AMultiple version database concurrency control systemIBM·Filed 1991·Granted Jan 18, 1994·321 cites·19 claims
- 0495US6081801AShared nothing parallel execution of procedural constructs in SQLIBM·Filed 1997·Granted Jun 27, 2000·269 cites·8 claims
- 0593US6983291B1Incremental maintenance of aggregated and join summary tablesIBM·Filed 2000·Granted Jan 3, 2006·90 cites·87 claims
- 0693US6453314B1System and method for selective incremental deferred constraint processing after bulk loading dataIBM·Filed 1999·Granted Sep 17, 2002·184 cites·63 claims
- 0793US5557791AOuter join operations using responsibility regions assigned to inner tables in a relational databaseIBM·Filed 1994·Granted Sep 17, 1996·89 cites·30 claims
- 0893US5367675AComputer automated system and method for optimizing the processing of a query in a relational database system by merging subqueries with the queryIBM·Filed 1991·Granted Nov 22, 1994·219 cites·18 claims
- 0992US7020649B2System and method for incrementally maintaining non-distributive aggregate functions in a relational databaseIBM·Filed 2002·Granted Mar 28, 2006·120 cites·12 claims
- 1092US6847962B1Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tablesIBM·Filed 2000·Granted Jan 25, 2005·85 cites·198 claims
- 1191US7395258B2System and method for adaptive database cachingIBM·Filed 2004·Granted Jul 1, 2008·68 cites·25 claims
- 1291US6339769B1Query optimization by transparently altering properties of relational tables using materialized viewsIBM·Filed 1998·Granted Jan 15, 2002·190 cites·72 claims
- 1391US5873075ASynchronization of SQL actions in a relational database systemIBM·Filed 1997·Granted Feb 16, 1999·190 cites·40 claims
- 1490US10176220B2Executing graph path queriesIBM·Filed 2015·Granted Jan 8, 2019·7 cites·17 claims
- 1590US5706494ASystem and method for constraint checking bulk data in a databaseIBM·Filed 1995·Granted Jan 6, 1998·176 cites·35 claims
- 1690US5546576AQuery optimizer system that detects and prevents mutating table violations of database integrity in a query before execution plan generationIBM·Filed 1995·Granted Aug 13, 1996·167 cites·20 claims
- 1789US10430100B2Transactional operations in multi-master distributed data management systemsIBM·Filed 2018·Granted Oct 1, 2019·5 cites·20 claims
- 1889US7945577B2System and method for adaptive database cachingIBM·Filed 2008·Granted May 17, 2011·26 cites·2 claims
- 1989US7716215B2System, method, and computer program product for progressive query processingIBM·Filed 2007·Granted May 11, 2010·32 cites·1 claims
- 2089US5960428AStar/join query optimizationIBM·Filed 1997·Granted Sep 28, 1999·119 cites·75 claims
- 2188US8326847B2Graph search system and method for querying loosely integrated dataBALMIN ANDREY·Filed 2008·Granted Dec 4, 2012·22 cites·11 claims
- 2288US5930795ASupporting dynamic tables in SQL query compilersIBM·Filed 1997·Granted Jul 27, 1999·151 cites·41 claims
- 2388US5548755ASystem for optimizing correlated SQL queries in a relational database using magic decorrelationIBM·Filed 1995·Granted Aug 20, 1996·153 cites·39 claims
- 2487US6625593B1Parallel query optimization strategies for replicated and partitioned tablesIBM·Filed 1999·Granted Sep 23, 2003·133 cites·108 claims
- 2587US6460027B1Automatic recognition and rerouting of queries for optimal performanceIBM·Filed 1998·Granted Oct 1, 2002·101 cites·66 claims
- 2686US7945557B2Method, system, and program for query optimization with algebraic rulesIBM·Filed 2007·Granted May 17, 2011·16 cites·21 claims
- 2786US7315852B2XPath containment for index and materialized view matchingIBM·Filed 2003·Granted Jan 1, 2008·55 cites·60 claims
- 2885US5963936AQuery processing system that computes GROUPING SETS, ROLLUP, and CUBE with a reduced number of GROUP BYs in a query graph modelIBM·Filed 1997·Granted Oct 5, 1999·92 cites·14 claims
- 2984US7383246B2System, method, and computer program product for progressive query processingIBM·Filed 2003·Granted Jun 3, 2008·37 cites·1 claims
- 3083US9910860B2Split elimination in MapReduce systemsIBM·Filed 2014·Granted Mar 6, 2018·8 cites·10 claims
- 3183US9141667B2Efficient join with one or more large dimension tablesIBM·Filed 2013·Granted Sep 22, 2015·7 cites·23 claims
- 3283US6763352B2Incremental maintenance of summary tables with complex grouping expressionsIBM·Filed 1999·Granted Jul 13, 2004·73 cites·19 claims
- 3383US6339768B1Exploitation of subsumption in optimizing scalar subqueriesIBM·Filed 1998·Granted Jan 15, 2002·73 cites·54 claims
- 3483US5590324AOptimization of SQL queries using universal quantifiers, set intersection, and max/min aggregation in the presence of nullable columnsIBM·Filed 1995·Granted Dec 31, 1996·113 cites·38 claims
- 3582US7240078B2Method, system, and program for query optimization with algebraic rulesIBM·Filed 2003·Granted Jul 3, 2007·30 cites·17 claims
- 3682US6339770B1Query simplification and optimization involving eliminating grouping column from group by operation corresponds to group by item that is constantIBM·Filed 1999·Granted Jan 15, 2002·64 cites·18 claims
- 3782US5864840AEvaluation of existential and universal subquery in a relational database management system for increased efficiencyIBM·Filed 1997·Granted Jan 26, 1999·94 cites·90 claims
- 3882US5548758AOptimization of SQL queries using early-out join transformations of column-bound relational tablesIBM·Filed 1995·Granted Aug 20, 1996·91 cites·21 claims
- 3981US5963933AEfficient implementation of full outer join and anti-joinIBM·Filed 1997·Granted Oct 5, 1999·95 cites·52 claims
- 4080US11216455B2Supporting synergistic and retrofittable graph queries inside a relational databaseIBM·Filed 2019·Granted Jan 4, 2022·3 cites·18 claims
- 4180US7478080B2Canonical abstraction for outerjoin optimizationIBM·Filed 2004·Granted Jan 13, 2009·30 cites·3 claims
- 4280US5987455AIntelligent compilation of procedural functions for query processing systemsIBM·Filed 1997·Granted Nov 16, 1999·64 cites·18 claims
- 4380US5546570AEvaluation strategy for execution of SQL queries involving recursion and table queuesIBM·Filed 1995·Granted Aug 13, 1996·68 cites·21 claims
- 4479US6665663B2Outerjoin and antijoin reordering using extended eligibility listsIBM·Filed 2001·Granted Dec 16, 2003·27 cites·36 claims
- 4578US6560594B2Cube indices for relational database management systemsIBM·Filed 1999·Granted May 6, 2003·56 cites·57 claims
- 4677US6032143AEvaluation of existential and universal subquery in a relational database management system for increased efficiencyIBM·Filed 1998·Granted Feb 29, 2000·73 cites·37 claims
- 4775US11119678B2Transactional operations in multi-master distributed data management systemsIBM·Filed 2019·Granted Sep 14, 2021·1 cites·19 claims
- 4875US6581205B1Intelligent compilation of materialized view maintenance for query processing systemsIBM·Filed 1999·Granted Jun 17, 2003·68 cites·36 claims
- 4975US6496828B1Support for summary tables in a heterogeneous database environmentIBM·Filed 1999·Granted Dec 17, 2002·67 cites·40 claims
- 5075US5548754AOptimization of SQL queries using early-out join transformationsIBM·Filed 1995·Granted Aug 20, 1996·61 cites·9 claims
Showing the top 50 of 78 patent records by PatentIndex Score.
Join the waitlist — get patent alerts
Get an alert when Mir Hamid Pirahesh files or is granted a new patent.
We store only your email — no account needed. See our privacy policy.
Identity basis: PatentsView inventor disambiguation (2025Q4-odp release). How scoring works →