Inventor
COCHRANE ROBERTA JO
US22 patents
Patents
22 patentsUS6339769B1Jan 15, 2002
Query optimization by transparently altering properties of relational tables using materialized views
IBM190 citations99
US5706494AJan 6, 1998
System and method for constraint checking bulk data in a database
IBM176 citations99
US6983291B1Jan 3, 2006
Incremental maintenance of aggregated and join summary tables
IBM90 citations98
US6763352B2Jul 13, 2004
Incremental maintenance of summary tables with complex grouping expressions
IBM73 citations98
US6460027B1Oct 1, 2002
Automatic recognition and rerouting of queries for optimal performance
IBM101 citations98
US6453314B1Sep 17, 2002
System and method for selective incremental deferred constraint processing after bulk loading data
IBM184 citations98
US6081801AJun 27, 2000
Shared nothing parallel execution of procedural constructs in SQL
IBM269 citations98
US5930795AJul 27, 1999
Supporting dynamic tables in SQL query compilers
IBM151 citations98
US5873075AFeb 16, 1999
Synchronization of SQL actions in a relational database system
IBM190 citations98
US7020649B2Mar 28, 2006
System and method for incrementally maintaining non-distributive aggregate functions in a relational database
IBM120 citations97
US6847962B1Jan 25, 2005
Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tables
IBM85 citations96
US6581205B1Jun 17, 2003
Intelligent compilation of materialized view maintenance for query processing systems
IBM68 citations96
US6560594B2May 6, 2003
Cube indices for relational database management systems
IBM56 citations96
US6546402B1Apr 8, 2003
System and method for asynchronous view maintenance
IBM149 citations96
US6496828B1Dec 17, 2002
Support for summary tables in a heterogeneous database environment
IBM67 citations96
US5963936AOct 5, 1999
Query processing system that computes GROUPING SETS, ROLLUP, and CUBE with a reduced number of GROUP BYs in a query graph model
IBM92 citations96
US7315852B2Jan 1, 2008
XPath containment for index and materialized view matching
IBM55 citations95
US5987455ANov 16, 1999
Intelligent compilation of procedural functions for query processing systems
IBM64 citations94
US5963934AOct 5, 1999
Intelligent compilation of scripting language for query processing systems
IBM57 citations94
US7167853B2Jan 23, 2007
Matching and compensation tests for optimizing correlated subqueries within query using automatic summary tables
IBM21 citations92
US6532470B1Mar 11, 2003
Support for summary tables in a database system that does not otherwise support summary tables
IBM13 citations79
US11108559B2Aug 31, 2021
Producing proof of receipt, existence and other data provenance evidence
IBM1 citations59