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

1 Status Updates

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

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

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
GOOGLE INC.MOUNTAIN VIEW, CA16044

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Bossman, Patrick Dooling Alexandria, VA 8 139
Fuh, You-Chin San Jose, CA 44 484
Guo, Shuanglin San Jose, CA 8 85
Liu, Chan-Hua San Jose, CA 9 114
Tsuji, Yoichi San Jose, CA 13 124

Cited Art Landscape

Patent Info (Count) # Cites Year
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (6)
6,243,703 Method of accessing and displaying subsystem parameters including graphical plan table data 16 1997
* 6,763,352 Incremental maintenance of summary tables with complex grouping expressions 30 1999
6,195,653 System and method for selectively preparing customized reports of query explain data 60 2000
6,539,371 System and method for filtering query statements according to user-defined filters of query explain data 27 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 27 2000
 
NEC CORPORATION (1)
6,401,087 Information retrieval system, apparatus and method for selecting databases using retrieval terms 16 1999
 
NCR CORPORATION (2)
5,930,786 Method and apparatus for providing shared data to a requesting client 137 1995
6,085,223 Method and apparatus for providing database information to non-requesting clients 142 1995
 
ORACLE INTERNATIONAL CORPORATION (8)
5,899,986 Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer 45 1997
* 6,023,695 Summary table management in a computer system 54 1997
* 6,026,391 Systems and methods for estimating query response times in a computer system 103 1997
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 52 1999
6,401,083 Method and mechanism for associating properties with objects and instances 23 1999
* 6,249,791 Summary table management in a computer system 30 1999
* 6,985,904 Systems and methods for sharing of execution plans for similar database statements 86 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 37 1998
 
LINKEDIN CORPORATION (1)
2006/0149,695 Management of database statistics 29 2004
 
MICROSOFT TECHNOLOGY LICENSING, LLC (7)
5,950,186 Database system index selection using cost evaluation of a workload for multiple candidate index configurations 47 1997
5,913,206 Database system multi-column index selection for a workload 22 1997
5,913,207 Database system index selection using index configuration enumeration for a workload 32 1997
5,926,813 Database system index selection using cost evaluation of a workload for multiple candidate index configurations 31 1997
6,366,901 Automatic database statistics maintenance and plan regeneration 43 1998
6,363,371 Identifying essential statistics for query optimization for databases 58 1999
* 6,529,901 Automating statistics management for query optimizers 107 2000
 
TERADATA US, INC. (7)
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 136 1995
5,754,841 Method and apparatus for parallel execution of user-defined functions in an object-relational database management system 168 1995
5,864,843 Method and apparatus for extending a database management system to operate with diverse object servers 79 1995
5,794,250 Method and apparatus for extending existing database management system for new data types 121 1997
5,873,083 Method and apparatus for extending a relational database management system using a federated coordinator 67 1997
6,353,818 Plan-per-tuple optimizing of database queries with user-defined functions 96 1998
6,990,484 Determining the satisfiability and transitive closure of conditions in a query 8 2002
 
GOOGLE INC. (2)
* 6,847,962 Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tables 29 2000
* 7,080,062 Optimizing database queries using query execution plans derived from automatic summary table determining cost based queries 67 2000
* Cited By Examiner

Patent Citation Ranking

Forward Cite Landscape

Patent Info (Count) # Cites Year
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (15)
7,831,592 System and method for updating database statistics according to query feedback 7 2004
* 2006/0178,982 Method and system for executing data analytics on a varying number of records within a RDBMS using SQL 3 2005
* 7,478,083 Method and system for estimating cardinality in a database system 3 2006
* 2007/0233,634 METHOD AND SYSTEM FOR ESTIMATING CARDINALITY IN A DATABASE SYSTEM 1 2006
* 2008/0016,029 OPTIMIZING A QUERY TO A DATABASE 0 2006
* 7,415,455 Self-healing RDBMS optimizer 2 2006
* 2007/0050,330 Self-Healing RDBMS Optimizer 3 2006
* 2008/0033,912 Query Workload Statistics Collection in a Database Management System 6 2007
7,984,024 Statistics management 1 2008
* 2009/0030,875 STATISTICS MANAGEMENT 3 2008
8,051,058 System for estimating cardinality in a database system 15 2008
* 2009/0012,977 SYSTEM FOR ESTIMATING CARDINALITY IN A DATABASE SYSTEM 1 2008
8,620,899 Generating materialized query table candidates 0 2010
* 2011/0196,857 Generating Materialized Query Table Candidates 3 2010
9,495,396 Increased database performance via migration of data to faster storage 0 2013
 
TWITTER, INC. (2)
* 7,739,293 Method, system, and program for collecting statistics of data stored in a database 1 2004
* 2006/0112,093 Method, system, and program for collecting statistics of data stored in a database 15 2004
 
ORACLE INTERNATIONAL CORPORATION (12)
8,983,934 SQL tuning base 0 2004
* 8,825,629 Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer 0 2004
7,805,411 Auto-tuning SQL statements 9 2004
7,747,606 Automatic SQL tuning advisor 19 2004
7,739,263 Global hints 1 2004
7,664,730 Method and system for implementing a SQL profile 5 2004
7,664,778 SQL tuning sets 2 2004
7,634,456 SQL structure analyzer 4 2004
* 2005/0187,917 Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer 68 2004
* 2005/0125,427 Automatic SQL tuning advisor 37 2004
* 2005/0097,091 SQL tuning base 22 2004
* 8,078,652 Virtual columns 0 2007
 
MICROSOFT TECHNOLOGY LICENSING, LLC (2)
* 7,606,792 System and method for efficient evaluation of a query that invokes a table valued function 10 2004
* 2005/0209,988 System and method for efficient evaluation of a query that invokes a table valued function 7 2004
 
LINKEDIN CORPORATION (1)
7,814,072 Management of database statistics 1 2004
 
TERADATA US, INC. (2)
* 7,958,159 Performing actions based on monitoring execution of a query 4 2005
* 2009/0083,215 SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR AUTOMATED SELECTION OF SAMPLING USAGE IN A DATABASE SYSTEM 8 2007
* Cited By Examiner

Maintenance Fees

Fee Large entity fee small entity fee micro entity fee due date
11.5 Year Payment $7400.00 $3700.00 $1850.00 May 27, 2019
Fee Large entity fee small entity fee micro entity fee
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