Identifying IO access pattern in unique database structures
US10162597B1 · kind B1 · utility
2Cited by
3References
18Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Sep 11, 2012 |
| Grant date | Dec 25, 2018 |
| Priority date | — |
| Expiry date | Feb 9, 2035 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2282
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Certain database structures and operations are recognized in order to generate hints for a tiered storage array. Historical snapshots of a database data dictionary are searched for patterns corresponding to the structures and operations. After a structure or operation is identified, a corresponding set of extents is identified. Logic predicts future activity associated with the extents, and a corresponding hint is provided to the storage array. Statistical information associated with the identified structure or operation may be maintained and updated to facilitate prediction of activity.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.