Offloaded, incremental database statistics collection and optimization
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Jun 7, 2016
Grant Date -
May 28, 2015
app pub date -
Nov 26, 2013
filing date -
Nov 26, 2013
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A method and associated system for offloading the collection and optimization of database statistics to an external computer system, without using significant resources required by the database system during its normal operation. A processor of a computer system captures and stores information about the database's recent transactions, where the captured information describes how each transaction altered the logical description of the database or revised data stored in the database. The processor uses this captured information to update stored metadata that identifies the database's logical structure, and to further update stored database statistics that describe characteristics of the data stored in the database. These updated statistics are then returned to the production database's optimizer module, which uses them to determine how to efficiently respond to database-access requests.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully