Inventor
SIMMEN DAVID E
US21 patents
⚠️ This page may combine multiple inventors who share the name “SIMMEN DAVID E”. Patents are grouped by organization below to help distinguish them — per-person disambiguation is on the roadmap.
IBM
19 patentsUS7080062B1Jul 18, 2006
Optimizing database queries using query execution plans derived from automatic summary table determining cost based queries
IBM184 citations99
US6339769B1Jan 15, 2002
Query optimization by transparently altering properties of relational tables using materialized views
IBM190 citations99
US6112198AAug 29, 2000
Optimization of data repartitioning during parallel query optimization
IBM335 citations99
US7890491B1Feb 15, 2011
Query optimization technique for obtaining improved cardinality estimates using statistics on automatic summary tables
IBM56 citations98
US6625593B1Sep 23, 2003
Parallel query optimization strategies for replicated and partitioned tables
IBM133 citations98
US6092062AJul 18, 2000
Relational database query optimization to perform query evaluation plan, pruning based on the partition properties
IBM334 citations98
US5619692AApr 8, 1997
Semantic optimization of query order requirements using order detection by normalization in a query compiler system
IBM103 citations98
US6345267B1Feb 5, 2002
Method and system for look ahead query evaluation planning based on interesting partition properties
IBM94 citations97
US5590324ADec 31, 1996
Optimization of SQL queries using universal quantifiers, set intersection, and max/min aggregation in the presence of nullable columns
IBM113 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
US6738755B1May 18, 2004
Query optimization method for incrementally estimating the cardinality of a derived relation when statistically correlated predicates are applied
IBM82 citations95
US8386450B2Feb 26, 2013
Query optimization technique for obtaining improved cardinality estimates using statistics on pre-defined queries
IBM40 citations94
US7007006B2Feb 28, 2006
Method for recommending indexes and materialized views for a database workload
IBM90 citations94
US5615361AMar 25, 1997
Exploitation of uniqueness properties using a 1-tuple condition for the optimization of SQL queries
IBM68 citations93
US7783625B2Aug 24, 2010
Using data in materialized query tables as a source for query optimization statistics
IBM19 citations92
US6085189AJul 4, 2000
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
IBM38 citations92
US5960426ASep 28, 1999
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
IBM39 citations92
US6513034B1Jan 28, 2003
Deriving uniqueness for indices on summary tables
IBM15 citations84