Brian Robert Muras

METHOD AND SYSTEM FOR DATA MINING FOR AUTOMATIC QUERY OPTIMIZATION

Intelligent pre-started job affinity for non-uniform memory access computer system

Method and apparatus for query optimization and management of sleepy drives

Intelligent pre-started job affinity for non-uniform memory access computer systems

Intelligent job functionality

System for on demand task optimization

Tracking premature termination of a database query

Database statistics for optimization of database queries containing user-defined functions

Generating Statistics for Optimizing Database Queries Containing User-Defined Functions

Adaptive query processing infrastructure

Canceling window close commands

Cardinality Statistic for Optimizing Database Queries with Aggregation Functions

Optimization of database queries including grouped aggregation functions

Creating profiling indices

Evaluating Multi-Table Join Selectivity in a Computer Database

Query directives and access plan hints

Query directives and access plan hints

Optimizing execution of database queries containing user-defined functions

Optimizing execution of database queries containing user-defined functions

BUILDING DATABASE STATISTICS ACROSS A JOIN NETWORK USING SKEW VALUES

Building database statistics across a join network using skew values

AUTONOMICALLY GENERATING A QUERY IMPLEMENTATION THAT MEETS A DEFINED PERFORMANCE SPECIFICATION

Autonomically generating a query implementation that meets a defined performance specification

Dynamic Index Selection for Database Queries

Intelligent open query cursor management

Background index bimapping for faster query performance

Method of querying relational database management systems

Method and system for dynamic join reordering

Estimating a number of rows returned by a recursive query

Optimizing a computer database query that fetches n rows

Method and apparatus for predicting selectivity of database query join conditions using hypothetical query predicates having skewed value constants

Method and system for creating database profiling indices

Method and apparatus for predicting selectivity of database query join conditions using hypothetical query predicates having skewed value constants

Dynamic look ahead predicate generation

Optimizing a computer database query that fetches N rows

Optimizing a database query that fetches N rows

Method, query optimizer, and computer program product for implementing live switchover to temporary sparse index for faster query performance

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

Generating statistics for temporary tables during query optimization

Representing a distribution of data

Canceling window close commands

Tracking premature termination of a database query

Optimizing a database query that returns a predetermined number of rows using a generated optimized access plan

Estimating a number of rows returned by a recursive query

Dynamic look ahead predicate generation

Building database statistics across a join network using skew values

Breakpoint timers

Data management system that provides intelligent access plan caching

Time-based rebuilding of autonomic table statistics collections

System for on demand task optimization

Adjusting an amount of data logged for a query based on a change to an access plan

Method and apparatus for predicting selectivity of database query join conditions using hypothetical query predicates having skewed value constants

Mirroring database statistics

Method and system for access plan sampling

Method and apparatus for re-evaluating execution strategy for a database query

Method and system for data mining for automatic query optimization

Method and apparatus for optimizing execution of database queries containing user-defined functions

Dropping tautological predicates from SQL queries for reusability

Method for autonomically generating a query implementation that meets a defined performance specification

Method and system for query directives and access plan hints

Apparatus and method for using values from a frequent values list to bridge additional keys in a database index

Method and system for creating profiling indices

Method and system for a self-healing query access plan

Method applying transitive closure to group by and order by clauses

Query access plan rebuilds

Optimization of queries using retrieval status of resources used thereby

Dynamic adjustment of system resource allocation during query execution in a database management system

Encryption of query execution details in a database management system

Method, apparatus and computer program product for implementing autonomic testing and verification of software fix programs

Background index bitmapping for faster query performance

Method and system for dynamic join reordering