Patent | Date |
---|
Optimization of database queries including grouped aggregation functions Grant 9,244,974 - Muras , et al. January 26, 2 | 2016-01-26 |
Autonomically generating a query implementation that meets a defined performance specification Grant 9,135,298 - Day , et al. September 15, 2 | 2015-09-15 |
Adaptive query processing infrastructure Grant 9,087,102 - Bestgen , et al. July 21, 2 | 2015-07-21 |
Method and system for a self-healing query access plan Grant 8,775,412 - Day , et al. July 8, 2 | 2014-07-08 |
Intelligent open query cursor management Grant 8,768,904 - Baranczyk , et al. July 1, 2 | 2014-07-01 |
Database statistics for optimization of database queries containing user-defined functions Grant 8,682,875 - Barsness , et al. March 25, 2 | 2014-03-25 |
Generating statistics for temporary tables during query optimization Grant 8,650,179 - Driesch, Jr. , et al. February 11, 2 | 2014-02-11 |
Intelligent pre-started job affinity for non-uniform memory access computer system Grant 8,578,383 - Day , et al. November 5, 2 | 2013-11-05 |
Method And System For Data Mining For Automatic Query Optimization App 20130013586 - Muras; Brian Robert ;   et al. | 2013-01-10 |
Method and system for data mining for automatic query optimization Grant 8,346,761 - Muras , et al. January 1, 2 | 2013-01-01 |
Method of querying relational database management systems Grant 8,285,707 - Day , et al. October 9, 2 | 2012-10-09 |
Intelligent Pre-started Job Affinity For Non-uniform Memory Access Computer System App 20120174108 - Day; Paul Reuben ;   et al. | 2012-07-05 |
Intelligent pre-started job affinity for non-uniform memory access computer systems Grant 8,201,173 - Day , et al. June 12, 2 | 2012-06-12 |
Method for autonomically generating a query implementation that meets a defined performance specification Grant 8,161,037 - Day , et al. April 17, 2 | 2012-04-17 |
Optimizing execution of database queries containing user-defined functions Grant 8,099,410 - Day , et al. January 17, 2 | 2012-01-17 |
System for on demand task optimization Grant 8,055,941 - Day , et al. November 8, 2 | 2011-11-08 |
Method and apparatus for re-evaluating execution strategy for a database query Grant 8,046,354 - Day , et al. October 25, 2 | 2011-10-25 |
Optimizing execution of database queries containing user-defined functions Grant 8,041,708 - Day , et al. October 18, 2 | 2011-10-18 |
Dynamic look ahead predicate generation Grant 8,024,321 - Muras September 20, 2 | 2011-09-20 |
Tracking premature termination of a database query Grant 7,996,386 - Day , et al. August 9, 2 | 2011-08-09 |
Method and apparatus for predicting selectivity of database query join conditions using hypothetical query predicates having skewed value constants Grant 7,987,200 - Faunce , et al. July 26, 2 | 2011-07-26 |
Time-based rebuilding of autonomic table statistics collections Grant 7,949,631 - Faunce , et al. May 24, 2 | 2011-05-24 |
Building database statistics across a join network using skew values Grant 7,930,296 - Muras April 19, 2 | 2011-04-19 |
Method and system for dynamic join reordering Grant 7,917,498 - Day , et al. March 29, 2 | 2011-03-29 |
Background index bimapping for faster query performance Grant 7,890,495 - Day , et al. February 15, 2 | 2011-02-15 |
Intelligent job functionality Grant 7,882,399 - Day , et al. February 1, 2 | 2011-02-01 |
Dropping tautological predicates from SQL queries for reusability Grant 7,877,377 - Day , et al. January 25, 2 | 2011-01-25 |
Creating profiling indices Grant 7,865,509 - Barsness , et al. January 4, 2 | 2011-01-04 |
Estimating a number of rows returned by a recursive query Grant 7,840,592 - Muras November 23, 2 | 2010-11-23 |
Method and system for creating database profiling indices Grant 7,809,730 - Barsness , et al. October 5, 2 | 2010-10-05 |
Optimizing a computer database query that fetches N rows Grant 7,756,861 - Muras , et al. July 13, 2 | 2010-07-13 |
Optimizing a database query that fetches N rows Grant 7,734,620 - Muras , et al. June 8, 2 | 2010-06-08 |
Method applying transitive closure to group by and order by clauses Grant 7,720,840 - Day , et al. May 18, 2 | 2010-05-18 |
Query directives and access plan hints Grant 7,685,101 - Day , et al. March 23, 2 | 2010-03-23 |
Method and apparatus for query optimization and management of sleepy drives Grant 7,653,826 - Day , et al. January 26, 2 | 2010-01-26 |
Query directives and access plan hints Grant 7,630,958 - Day , et al. December 8, 2 | 2009-12-08 |
Optimizing a computer database query that fetches n rows Grant 7,567,952 - Muras , et al. July 28, 2 | 2009-07-28 |
Intelligent Pre-Started Job Affinity for Non-Uniform Memory Access Computer Systems App 20090183156 - Day; Paul Reuben ;   et al. | 2009-07-16 |
Intelligent Job Functionality App 20090158091 - Day; Paul Reuben ;   et al. | 2009-06-18 |
System For On Demand Task Optimization App 20090133030 - Day; Paul Reuben ;   et al. | 2009-05-21 |
Dynamic look ahead predicate generation Grant 7,536,380 - Muras May 19, 2 | 2009-05-19 |
Tracking Premature Termination Of A Database Query App 20090119249 - Day; Paul Reuben ;   et al. | 2009-05-07 |
Database Statistics for Optimization of Database Queries Containing User-Defined Functions App 20090112799 - Barsness; Eric Lawrence ;   et al. | 2009-04-30 |
Generating Statistics for Optimizing Database Queries Containing User-Defined Functions App 20090112792 - Barsness; Eric Lawrence ;   et al. | 2009-04-30 |
Adaptive Query Processing Infrastructure App 20090094192 - Bestgen; Robert Joseph ;   et al. | 2009-04-09 |
Cardinality Statistic for Optimizing Database Queries with Aggregation Functions App 20090077054 - Muras; Brian Robert ;   et al. | 2009-03-19 |
Canceling window close commands App 20090077487 - Day; Paul Reuben ;   et al. | 2009-03-19 |
Optimization of Database Queries Including Grouped Aggregation Functions App 20090077010 - Muras; Brian Robert ;   et al. | 2009-03-19 |
System for on demand task optimization Grant 7,500,140 - Day , et al. March 3, 2 | 2009-03-03 |
Adjusting an amount of data logged for a query based on a change to an access plan Grant 7,493,304 - Day , et al. February 17, 2 | 2009-02-17 |
Tracking premature termination of a database query Grant 7,493,306 - Day , et al. February 17, 2 | 2009-02-17 |
Creating Profiling Indices App 20090037372 - Barsness; Eric Lawrence ;   et al. | 2009-02-05 |
Method and apparatus for predicting selectivity of database query join conditions using hypothetical query predicates having skewed value constants Grant 7,483,888 - Faunce , et al. January 27, 2 | 2009-01-27 |
Canceling window close commands Grant 7,464,341 - Day , et al. December 9, 2 | 2008-12-09 |
Method and system for creating profiling indices Grant 7,461,089 - Barsness , et al. December 2, 2 | 2008-12-02 |
Evaluating Multi-Table Join Selectivity in a Computer Database App 20080288444 - Edwards; John Francis ;   et al. | 2008-11-20 |
Query Directives And Access Plan Hints App 20080281780 - Day; Paul Reuben ;   et al. | 2008-11-13 |
Query Directives And Access Plan Hints App 20080281779 - Day; Paul Reuben ;   et al. | 2008-11-13 |
Optimizing Execution of Database Queries Containing User-Defined Functions App 20080275858 - Day; Paul Reuben ;   et al. | 2008-11-06 |
Method and apparatus for optimizing execution of database queries containing user-defined functions Grant 7,447,680 - Day , et al. November 4, 2 | 2008-11-04 |
Optimizing Execution of Database Queries Containing User-Defined Functions App 20080270392 - Day; Paul Reuben ;   et al. | 2008-10-30 |
Method and system for query directives and access plan hints Grant 7,440,935 - Day , et al. October 21, 2 | 2008-10-21 |
Building Database Statistics Across A Join Network Using Skew Values App 20080228709 - Muras; Brian Robert | 2008-09-18 |
Building Database Statistics Across A Join Network Using Skew Values App 20080228710 - Muras; Brian Robert | 2008-09-18 |
Autonomically Generating A Query Implementation That Meets A Defined Performance Specification App 20080215536 - Day; Paul Reuben ;   et al. | 2008-09-04 |
Autonomically Generating A Query Implementation That Meets A Defined Performance Specification App 20080215535 - Day; Paul Reuben ;   et al. | 2008-09-04 |
Dynamic Index Selection for Database Queries App 20080183663 - Day; Paul Reuben ;   et al. | 2008-07-31 |
Method, Apparatus, and Computer Program Product for Intelligent Open Query Cursor Management App 20080172369 - Baranczyk; Shawn Joseph ;   et al. | 2008-07-17 |
Background index bitmapping for faster query performance Grant 7,401,069 - Day , et al. July 15, 2 | 2008-07-15 |
Building database statistics across a join network using skew values Grant 7,386,538 - Muras June 10, 2 | 2008-06-10 |
Background Index Bimapping For Faster Query Performance App 20080133470 - Day; Paul Reuben ;   et al. | 2008-06-05 |
Method of Querying Relational Database Management Systems App 20080109424 - Day; Paul Reuben ;   et al. | 2008-05-08 |
Method And System For Dynamic Join Reordering App 20080097963 - Day; Paul Reuben ;   et al. | 2008-04-24 |
Estimating a number of rows returned by a recursive query App 20080071754 - Muras; Brian Robert | 2008-03-20 |
Apparatus And Method For Optimizing A Computer Database Query That Fetches N Rows App 20080065595 - Muras; Brian Robert ;   et al. | 2008-03-13 |
Method and Apparatus for Predicting Selectivity of Database Query Join Conditions Using Hypothetical Query Predicates Having Skewed Value Constants App 20080065594 - Faunce; Michael S. ;   et al. | 2008-03-13 |
Method and apparatus for predicting selectivity of database query join conditions using hypothetical query predicates having skewed value constants Grant 7,343,369 - Faunce , et al. March 11, 2 | 2008-03-11 |
Optimizing a database query that returns a predetermined number of rows using a generated optimized access plan Grant 7,343,367 - Muras , et al. March 11, 2 | 2008-03-11 |
Method And System For Creating Profiling Indices App 20080059418 - Barsness; Eric Lawrence ;   et al. | 2008-03-06 |
Method and Apparatus for Predicting Selectivity of Database Query Join Conditions Using Hypothetical Query Predicates Having Skewed Value Constants App 20080052286 - Faunce; Michael S. ;   et al. | 2008-02-28 |
Dynamic Look Ahead Predicate Generation App 20080052282 - Muras; Brian Robert | 2008-02-28 |
Estimating a number of rows returned by a recursive query Grant 7,337,167 - Muras February 26, 2 | 2008-02-26 |
Apparatus And Method For Optimizing A Computer Database Query That Fetches N Rows App 20080021869 - Muras; Brian Robert ;   et al. | 2008-01-24 |
Apparatus And Method For Optimizing A Computer Database Query That Fetches N Rows App 20080021868 - Muras; Brian Robert ;   et al. | 2008-01-24 |
Method and system for dynamic join reordering Grant 7,321,888 - Day , et al. January 22, 2 | 2008-01-22 |
Apparatus and method for using values from a frequent values list to bridge additional keys in a database index Grant 7,313,553 - Faunce , et al. December 25, 2 | 2007-12-25 |
Optimization of queries using retrieval status of resources used thereby Grant 7,308,437 - Day , et al. December 11, 2 | 2007-12-11 |
Method, apparatus and computer program product for implementing autonomic testing and verification of software fix programs Grant 7,296,189 - Day , et al. November 13, 2 | 2007-11-13 |
Method, query optimizer, and computer program product for implementing live switchover to temporary sparse index for faster query performance Grant 7,191,174 - Day , et al. March 13, 2 | 2007-03-13 |
Highlighting entities in a display representation of a database query, results of a database query, and debug message of a database query to indicate associations App 20070050379 - Day; Paul Reuben ;   et al. | 2007-03-01 |
Generating statistics for temporary tables during query optimization App 20070043697 - Driesch; Robert Douglas JR. ;   et al. | 2007-02-22 |
Representing a distribution of data App 20070016603 - Muras; Brian Robert ;   et al. | 2007-01-18 |
Canceling window close commands App 20070006093 - Day; Paul Reuben ;   et al. | 2007-01-04 |
Tracking premature termination of a database query App 20060265351 - Day; Paul Reuben ;   et al. | 2006-11-23 |
Apparatus and method for optimizing a computer database query that Fetches n rows App 20060259457 - Muras; Brian Robert ;   et al. | 2006-11-16 |
Query access plan rebuilds Grant 7,133,861 - Day , et al. November 7, 2 | 2006-11-07 |
Estimating a number of rows returned by a recursive query App 20060235818 - Muras; Brian Robert | 2006-10-19 |
Dynamic look ahead predicate generation App 20060218129 - Muras; Brian Robert | 2006-09-28 |
Building database statistics across a join network using skew values App 20060218128 - Muras; Brian Robert | 2006-09-28 |
Breakpoint timers App 20060200807 - Bates; Cary Lee ;   et al. | 2006-09-07 |
Data management system that provides intelligent access plan caching Grant 7,099,858 - Aldrich , et al. August 29, 2 | 2006-08-29 |
Time-based rebuilding of autonomic table statistics collections App 20060167914 - Faunce; Michael S. ;   et al. | 2006-07-27 |
System for on demand task optimization App 20060143516 - Day; Paul Reuben ;   et al. | 2006-06-29 |
Method and apparatus for predicting selectivity of database query join conditions using hypothetical query predicates having skewed value constants App 20060106777 - Faunce; Michael S. ;   et al. | 2006-05-18 |
Adjusting an amount of data logged for a query based on a change to an access plan App 20060106786 - Day; Paul Reuben ;   et al. | 2006-05-18 |
Mirroring database statistics App 20060095405 - Anderson; Mark John ;   et al. | 2006-05-04 |
Method and system for access plan sampling App 20060085375 - Egan; Randy L. ;   et al. | 2006-04-20 |
Method and apparatus for re-evaluating execution strategy for a database query App 20060074874 - Day; Paul Reuben ;   et al. | 2006-04-06 |
Method and system for data mining for automatic query optimization App 20060031189 - Muras; Brian Robert ;   et al. | 2006-02-09 |
Method and apparatus for optimizing execution of database queries containing user-defined functions App 20060026116 - Day; Paul Reuben ;   et al. | 2006-02-02 |
Apparatus and method for autonomically generating a query implementation that meets a defined performance specification App 20060004695 - Day; Paul Reuben ;   et al. | 2006-01-05 |
Apparatus and method for dropping tautological predicates from SQL queries for reusability App 20060004696 - Day; Paul Reuben ;   et al. | 2006-01-05 |
Method and system for query directives and access plan hints App 20050262046 - Day, Paul Reuben ;   et al. | 2005-11-24 |
Apparatus and method for using values from a frequent values list to bridge additional keys in a database index App 20050228772 - Faunce, Michael S. ;   et al. | 2005-10-13 |
Method and system for creating profiling indices App 20050154757 - Barsness, Eric Lawrence ;   et al. | 2005-07-14 |
Method applying transitive closure to group by and order by clauses App 20050154725 - Day, Paul Reuben ;   et al. | 2005-07-14 |
Method and system for a self-healing query access plan App 20050154740 - day, Paul Reuben ;   et al. | 2005-07-14 |
Query access plan rebuilds App 20050125409 - Day, Paul Reuben ;   et al. | 2005-06-09 |
Optimization of queries using retrieval status of resources used thereby App 20050091196 - Day, Paul Reuben ;   et al. | 2005-04-28 |
Dynamic adjustment of system resource allocation during query execution in a database management system App 20050081210 - Day, Paul Reuben ;   et al. | 2005-04-14 |
Encryption of query execution details in a database management system App 20050071337 - Baranczyk, Shawn Joseph ;   et al. | 2005-03-31 |
Method, apparatus and computer program product for implementing autonomic testing and verification of software fix programs App 20050066233 - Day, Paul Reuben ;   et al. | 2005-03-24 |
Method and system for dynamic join reordering App 20050060292 - Day, Paul Reuben ;   et al. | 2005-03-17 |
Background index bitmapping for faster query performance App 20050060293 - Day, Paul Reuben ;   et al. | 2005-03-17 |
Method, query optimizer, and computer program product for implementing live switchover to temporary sparse index for faster query perfomance App 20040236727 - Day, Paul Reuben ;   et al. | 2004-11-25 |
Data management system that provides intelligent access plan caching App 20040153454 - Aldrich, Craig Stephen ;   et al. | 2004-08-05 |