US Patent No: 7,984,024

Number of patents in Portfolio can not be more than 2000

Statistics management

ALSO PUBLISHED AS: 20090030875

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

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... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
INTERNATIONAL BUSINESS MACHINES CORPORATIONARMONK, NY46670

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Bossman, Patrick Dooling Alexandria, VA 14 90
Fuh, You-Chin San Jose, CA 64 394
Liu, Chan-Hua San Jose, CA 11 95

Cited Art Landscape

Patent Info (Count) # Cites Year
 
Other [Check patent profile for assignment information] (1)
2004/0181,521 Query optimization technique for obtaining improved cardinality estimates using statistics on pre-defined queries 31 2004
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (11)
5,734,884 Database execution cost and system performance estimator 34 1996
6,243,703 Method of accessing and displaying subsystem parameters including graphical plan table data 15 1997
6,105,020 System and method for identifying and constructing star joins for execution by bitmap ANDing 37 1999
6,763,352 Incremental maintenance of summary tables with complex grouping expressions 29 1999
6,195,653 System and method for selectively preparing customized reports of query explain data 57 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 25 2000
2003/0115,183 Estimation and use of access plan statistics 27 2001
7,412,439 Method for statistics management 4 2004
2008/0033,912 Query Workload Statistics Collection in a Database Management System 3 2007
 
NCR CORPORATION (2)
5,930,786 Method and apparatus for providing shared data to a requesting client 134 1995
6,085,223 Method and apparatus for providing database information to non-requesting clients 110 1995
 
D.A.N. JOINT VENTURE III, L.P. (1)
6,434,745 Customized web browsing and marketing software with local events statistics database 67 1999
 
LINKEDIN CORPORATION (2)
7,139,749 Method, system, and program for performance tuning a database query 33 2003
7,814,072 Management of database statistics 1 2004
 
TERADATA US, INC. (9)
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 132 1995
5,754,841 Method and apparatus for parallel execution of user-defined functions in an object-relational database management system 158 1995
5,864,843 Method and apparatus for extending a database management system to operate with diverse object servers 75 1995
5,794,250 Method and apparatus for extending existing database management system for new data types 119 1997
5,873,083 Method and apparatus for extending a relational database management system using a federated coordinator 66 1997
6,353,818 Plan-per-tuple optimizing of database queries with user-defined functions 80 1998
2003/0093,408 Index selection in a database system 66 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 9 2002
 
INTELLECTUAL VENTURES I LLC (1)
6,370,523 System and methods for determining a desired listing using an intersection of coverage areas and a search region 33 1998
 
ALCATEL CANADA INC. (1)
2003/0115,508 System and method for collecting statistics for a communication network 17 2002
 
ORACLE INTERNATIONAL CORPORATION (11)
5,899,986 Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer 43 1997
6,023,695 Summary table management in a computer system 48 1997
6,026,391 Systems and methods for estimating query response times in a computer system 90 1997
6,029,163 Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer 67 1998
6,351,742 Method and mechanism for database statement optimization 31 1999
6,370,522 Method and mechanism for extending native optimization in a database system 48 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 29 1999
6,985,904 Systems and methods for sharing of execution plans for similar database statements 65 2002
2004/0243,555 Methods and systems for optimizing queries through dynamic and autonomous database schema analysis 37 2003
2005/0138,015 High load SQL driven statistics collection 21 2004
 
NEC CORPORATION (1)
6,401,087 Information retrieval system, apparatus and method for selecting databases using retrieval terms 15 1999
 
MICROSOFT TECHNOLOGY LICENSING, LLC (8)
5,950,186 Database system index selection using cost evaluation of a workload for multiple candidate index configurations 40 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 28 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 38 1998
6,363,371 Identifying essential statistics for query optimization for databases 53 1999
6,529,901 Automating statistics management for query optimizers 98 2000
6,744,449 Graphical query analyzer 19 2002
 
GOOGLE INC. (3)
6,847,962 Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tables 28 2000
7,080,062 Optimizing database queries using query execution plans derived from automatic summary table determining cost based queries 42 2000
7,302,422 Query workload statistics collection in a database management system 19 2004
 
INFOCYCLONE LTD. (1)
2003/0158,842 Adaptive acceleration of retrieval queries 40 2003
* Cited By Examiner

Patent Citation Ranking

Forward Cite Landscape

  • No Forward Cites to Display

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