Method and apparatus for identifying database I/O activity
US10360192B1 · kind B1 · utility
7Cited by
1References
10Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 29, 2012 |
| Grant date | Jul 23, 2019 |
| Priority date | — |
| Expiry date | Jan 7, 2033 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2009/45583
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A SQL database tool maps database objects to storage addresses. The SQL database translates SQL requests to I/O requests on specific extents of OS files. A data structure maps the OS file extents to database objects. Using this mapping, I/O requests on files can be correlated to their relevant database objects, providing analysis of I/O activity and I/O wait time for database objects. Based on the computed database object activity level, the database objects may be allocated to different storage tiers according to their I/O needs.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.