US Patent No: 7,302,422
Number of patents in Portfolio can not be more than 2000
Query workload statistics collection in a database management system
Stats
-
Nov 27, 2007
Issued date -
Apr 14, 2004
filing date -
10/824,856
serial no -
In Force
status
Importance
Loading Importance Indicators...
Abstract
In various embodiments, a method, apparatus, and article of manufacture collect statistics in a database management system. A workload comprising a plurality of database queries is received. Query statistics for the database queries are identified. The query statistics for the database queries are consolidated to provide consolidated statistics. One or more statistics collection requests are generated based on the consolidated statistics.
Loading the Abstract Image...
First Claim
Related Publications
Loading Related Publications...
International Classification(s)
- [Classification Symbol]
- [Patents Count]
Cited Art
| Patent Info | (Count) | # Cites | Year |
|---|---|---|---|
|
|
|||
| 5,899,986 Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer | 40 | 1997 | |
| 6,023,695 Summary table management in a computer system | 35 | 1997 | |
| 6,026,391 Systems and methods for estimating query response times in a computer system | 76 | 1997 | |
| 6,351,742 Method and mechanism for database statement optimization | 29 | 1999 | |
| 6,370,522 Method and mechanism for extending native optimization in a database system | 42 | 1999 | |
| 6,401,083 Method and mechanism for associating properties with objects and instances | 22 | 1999 | |
| 6,249,791 Summary table management in a computer system | 21 | 1999 | |
| 6,985,904 Systems and methods for sharing of execution plans for similar database statements | 47 | 2002 | |
|
|
|||
| 6,243,703 Method of accessing and displaying subsystem parameters including graphical plan table data | 13 | 1997 | |
| 6,763,352 Incremental maintenance of summary tables with complex grouping expressions | 23 | 1999 | |
| 6,195,653 System and method for selectively preparing customized reports of query explain data | 50 | 2000 | |
| 6,539,371 System and method for filtering query statements according to user-defined filters of query explain data | 23 | 2000 | |
| 6,493,700 System and method for specifying custom qualifiers for explain tables | 11 | 2000 | |
| 6,397,207 System and method for selectively preparing customized reports of query explain data | 22 | 2000 | |
| 2006/0149,695 Management of database statistics | 11 | 2004 | |
|
|
|||
| 5,950,186 Database system index selection using cost evaluation of a workload for multiple candidate index configurations | 39 | 1997 | |
| 5,913,206 Database system multi-column index selection for a workload | 21 | 1997 | |
| 5,913,207 Database system index selection using index configuration enumeration for a workload | 25 | 1997 | |
| 5,926,813 Database system index selection using cost evaluation of a workload for multiple candidate index configurations | 25 | 1997 | |
| 6,366,901 Automatic database statistics maintenance and plan regeneration | 33 | 1998 | |
| 6,363,371 Identifying essential statistics for query optimization for databases | 45 | 1999 | |
| 6,529,901 Automating statistics management for query optimizers | 83 | 2000 | |
|
|
|||
| 5,689,698 Method and apparatus for managing shared data using a data surrogate and obtaining cost parameters from a data dictionary by evaluating a parse tree object | 99 | 1995 | |
| 5,754,841 Method and apparatus for parallel execution of user-defined functions in an object-relational database management system | 113 | 1995 | |
| 5,864,843 Method and apparatus for extending a database management system to operate with diverse object servers | 69 | 1995 | |
| 5,794,250 Method and apparatus for extending existing database management system for new data types | 95 | 1997 | |
| 5,873,083 Method and apparatus for extending a relational database management system using a federated coordinator | 64 | 1997 | |
| 6,353,818 Plan-per-tuple optimizing of database queries with user-defined functions | 67 | 1998 | |
| 6,990,484 Determining the satisfiability and transitive closure of conditions in a query | 8 | 2002 | |
|
|
|||
| 6,847,962 Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tables | 25 | 2000 | |
| 7,080,062 Optimizing database queries using query execution plans derived from automatic summary table determining cost based queries | 25 | 2000 | |
|
|
|||
| 5,930,786 Method and apparatus for providing shared data to a requesting client | 94 | 1995 | |
| 6,085,223 Method and apparatus for providing database information to non-requesting clients | 61 | 1995 | |
|
|
|||
| 6,401,087 Information retrieval system, apparatus and method for selecting databases using retrieval terms | 11 | 1999 | |
|
|
|||
| 6,370,523 System and methods for determining a desired listing using an intersection of coverage areas and a search region | 20 | 1998 | |
Patent Citation Ranking
Maintenance Fees
| Fee | Large entity fee | small entity fee | micro entity fee | due date |
|---|---|---|---|---|
| 7.5 Year Payment | $3600.00 | $1800.00 | $900.00 | May 27, 2015 |
| 11.5 Year Payment | $7400.00 | $3700.00 | $1850.00 | May 27, 2019 |
| Fee | Large entity fee | small entity fee | micro entity fee |
|---|---|---|---|
| Surcharge - 7.5 year - Late payment within 6 months | $160.00 | $80.00 | $40.00 |
| Surcharge - 11.5 year - Late payment within 6 months | $160.00 | $80.00 | $40.00 |
| Surcharge after expiration - Late payment is unavoidable | $700.00 | $350.00 | $175.00 |
| Surcharge after expiration - Late payment is unintentional | $1,640.00 | $820.00 | $410.00 |