Hornibrook, Markham
John Hornibrook, Markham CA
Patent application number | Description | Published |
---|---|---|
20090193041 | METHOD FOR AUTOMATED DESIGN OF ROW COMPRESSION ON TABLES IN A RELATIONAL DATABASE - A workload specification is obtained for the database. Based on the workload specification, candidate ones of the tables are identified and ranked. Compression impact is evaluated for the candidate ones of the tables. A design for the database is developed, specifying at least one of: (i) which of the tables should be compressed, and (ii) which of the tables should not be compressed. | 07-30-2009 |
20090193042 | SYSTEM AND COMPUTER PROGRAM PRODUCT FOR AUTOMATED DESIGN OF ROW COMPRESSION ON TABLES IN A RELATIONAL DATABASE - A workload specification is obtained for the database. Based on the workload specification, candidate ones of the tables are identified and ranked. Compression impact is evaluated for the candidate ones of the tables. A design for the database is developed, specifying at least one of: (i) which of the tables should be compressed, and (ii) which of the tables should not be compressed. | 07-30-2009 |
John F. Hornibrook, Markham, CA US
Patent application number | Description | Published |
---|---|---|
20090063398 | STATISTICS COLLECTION FOR DATABASE TABLES - A method and system for collecting statistics on database tables. In one embodiment, the method includes identifying a plurality of tables for statistics collection, wherein each table of the plurality of tables are remote tables; examining at least one attribute for each table identified for statistics collection; prioritizing the tables for statistics collection based on the at least one attribute; and collecting statistics on the identified tables in a priority sequence. | 03-05-2009 |
John F. Hornibrook, Markham CA
Patent application number | Description | Published |
---|---|---|
20090012977 | SYSTEM FOR ESTIMATING CARDINALITY IN A DATABASE SYSTEM - A system for estimating cardinalities for a plurality of columns in a database system is disclosed. The system include obtaining statistics collected for the plurality of columns. A first portion of the statistics indicates at least one relationship between at least a portion of the plurality of columns, while a second portion of the statistics includes single column statistics. The system also include utilizing the first portion and the second portion of the statistics to estimate the cardinality for the plurality of columns. | 01-08-2009 |
20090055350 | AGGREGATE QUERY OPTIMIZATION - A method, computer program product, and system for optimizing aggregate queries are provided. The method, computer program product, and system provide for receiving an aggregate query comprising a GROUP BY operation and an aggregate function, creating an access plan for executing the aggregate query, the access plan including a join between an outer relation and an inner relation, and designating the join included in the access plan as an early out join. | 02-26-2009 |
20090063527 | PROCESSING OF DATABASE STATEMENTS WITH JOIN PREDICATES ON RANGE-PARTITIONED TABLES - A method for processing database statements with join predicates on range-partitioned tables is provided. The method provides for receiving a database statement with a join predicate between a first table and a second table for processing, responsive to the join predicate involving one or more leading columns of a partition key for the first table, a nested-loop join operation being selected to join the first table and the second table, the first table being an outer table of the nested-loop join operation, and data from the second table being piped, calculating maximum and minimum join key values for the second table, creating a partition elimination bitmap for the first table based on the maximum and minimum join key values of the second table, and pushing the partition elimination bitmap onto a scan of the first table to exclude one or more partitions of the first table from the scan. | 03-05-2009 |
20130198164 | Executing CASE Expressions Containing Subqueries - Methods and apparatus, including computer program products, implementing and using techniques for executing a query in a computer to retrieve data from a relational database stored on a data storage device. A query is received that contains a CASE expression having one or more subqueries. A query execution plan is generated. The query execution plan uses a parameterized union all operator to keep the semantics of the CASE expression, and a nested loop join operator to drive data across the section of the query execution plan that executes the CASE expression without performing any join operations. The generated query execution plan is executed in the computer to retrieve data from the relational database. | 08-01-2013 |
20130198165 | GENERATING STATISTICAL VIEWS IN A DATABASE SYSTEM - Techniques are disclosed for generating statistical views in a database system. In one embodiment, a request is received to execute a database workload. One or more constraints pertaining to executing the database workload is retrieved. The database workload is evaluated to generate multiple statistical view candidates. The statistical view candidates are refined based on the one or more constraints. One or more statistical views are then generated based on the refined statistical view candidates. | 08-01-2013 |
20140012835 | GENERATING STATISTICAL VIEWS IN A DATABASE SYSTEM - Techniques are disclosed for generating statistical views in a database system. In one embodiment, a request is received to execute a database workload. One or more constraints pertaining to executing the database workload is retrieved. The database workload is evaluated to generate multiple statistical view candidates. The statistical view candidates are refined based on the one or more constraints. One or more statistical views are then generated based on the refined statistical view candidates. | 01-09-2014 |
John Frederick Hornibrook, Markham CA
Patent application number | Description | Published |
---|---|---|
20090055352 | METHODS OF COST ESTIMATION USING PARTIALLY APPLIED PREDICATES - In accordance with aspects of the present invention, provided are methods for incrementally estimating the cardinality of a derived relation including statistically correlated partially applicable predicates for a range-partitioned table. During the generation of a QEP a cardinality estimate is calculated in which one or more partially applicable predicates is correlated to another partially applicable predicate and/or to one or more fully applicable predicates. The cardinality includes a number of rows expected to be returned by the QEP and is computed in an incremental fashion for each operator of the QEP. | 02-26-2009 |
20090216709 | OPTIMIZED COLLECTION OF JUST-IN-TIME STATISTICS FOR DATABASE QUERY OPTIMIZATION - A system and method are provided for updating database statistics for use in generating query execution plans. A first query for a database is received, for example by a compiler, and the compiler accesses statistics associated with the first query for optimizing a query execution plan for the first query. The statistics may be accessed from a first cache. If the statistics retrieved from the first cache are determined to be stale, the system obtains updated statistics and may store them in a temporary cache. The stale statistics in the first cache are marked as invalid. Existing queries using the first cache may continue to use the first cache, while new queries may be provided with updated statistics. | 08-27-2009 |
20120130989 | SYSTEMS AND COMPUTER PROGRAM PRODUCT FOR COST ESTIMATION USING PARTIALLY APPLIED PREDICATES - In accordance with aspects of the present invention, provided are systems and computer program products for incrementally estimating the cardinality of a derived relation including statistically correlated partially applicable predicates for a range-partitioned table. During the generation of a QEP a cardinality estimate is calculated in which one or more partially applicable predicates is correlated to another partially applicable predicate and/or to one or more fully applicable predicates. The cardinality includes a number of rows expected to be returned by the QEP and is computed in an incremental fashion for each operator of the QEP. | 05-24-2012 |