US Patent No: 7,984,024
Number of patents in Portfolio can not be more than 2000
Statistics management
Stats
-
Jul 19, 2011
Issued date -
Jun 17, 2008
filing date -
12/140,994
serial no -
In Force
status
Importance
Loading Importance Indicators...
Abstract
Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain 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,734,884 Database execution cost and system performance estimator | 30 | 1996 | |
| 6,243,703 Method of accessing and displaying subsystem parameters including graphical plan table data | 13 | 1997 | |
| 6,105,020 System and method for identifying and constructing star joins for execution by bitmap ANDing | 31 | 1999 | |
| 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 | |
| 2003/0115,183 Estimation and use of access plan statistics | 23 | 2001 | |
| 7,139,749 Method, system, and program for performance tuning a database query | 24 | 2003 | |
| 7,412,439 Method for statistics management | 4 | 2004 | |
| 7,814,072 Management of database statistics | 1 | 2004 | |
| 2008/0033,912 Query Workload Statistics Collection in a Database Management System | 2 | 2007 | |
|
|
|||
| 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,029,163 Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer | 56 | 1998 | |
| 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 | |
| 2004/0243,555 Methods and systems for optimizing queries through dynamic and autonomous database schema analysis | 23 | 2003 | |
| 2005/0138,015 High load SQL driven statistics collection | 13 | 2004 | |
|
|
|||
| 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 | |
| 2003/0093,408 Index selection in a database system | 52 | 2001 | |
| 6,990,484 Determining the satisfiability and transitive closure of conditions in a query | 8 | 2002 | |
| 2004/0059,743 Sampling statistics in a database system | 8 | 2002 | |
|
|
|||
| 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 | |
| 6,744,449 Graphical query analyzer | 16 | 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 | |
| 7,302,422 Query workload statistics collection in a database management system | 16 | 2004 | |
|
|
|||
| 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 | |
|
|
|||
| 2003/0115,508 System and method for collecting statistics for a communication network | 15 | 2002 | |
|
|
|||
| 6,434,745 Customized web browsing and marketing software with local events statistics database | 48 | 1999 | |
|
|
|||
| 2003/0158,842 Adaptive acceleration of retrieval queries | 28 | 2003 | |
|
|
|||
| 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 | |
|
|
|||
| 2004/0181,521 Query optimization technique for obtaining improved cardinality estimates using statistics on pre-defined queries | 20 | 2004 | |
Patent Citation Ranking
Maintenance Fees
| Fee | Large entity fee | small entity fee | micro entity fee | due date |
|---|---|---|---|---|
| 3.5 Year Payment | $1600.00 | $800.00 | $400.00 | Jan 19, 2015 |
| 7.5 Year Payment | $3600.00 | $1800.00 | $900.00 | Jan 19, 2019 |
| 11.5 Year Payment | $7400.00 | $3700.00 | $1850.00 | Jan 19, 2023 |
| Fee | Large entity fee | small entity fee | micro entity fee |
|---|---|---|---|
| Surcharge - 3.5 year - Late payment within 6 months | $160.00 | $80.00 | $40.00 |
| 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 |