Analysis system, computer system, and analysis method for analyzing behavior of database management system
US9710515B2 · kind B2 · utility
Assignees
Inventors
Key dates
| Filing date | May 31, 2012 |
| Grant date | Jul 18, 2017 |
| Priority date | — |
| Expiry date | Mar 21, 2033 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/25
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
This analysis system analyzes the behavior of a DBMS in a computer system having a computer which executes tasks in parallel and reads data from a database (DB) when executing a query. This analysis system acquires the number of selected rows corresponding to a key value of an index key used in the query, and calculates a model-based predicted degree of processing parallelism of the processing corresponding to the query. The system acquires, from the storage device, event information on an input-output event with respect to the storage medium when the processing corresponding to the query is executed actually, calculates a measured degree of processing parallelism when the processing corresponding to the query is executed actually, based on the event information, and displays information based on the model-based predicted degree of processing parallelism and the measured degree of processing parallelism.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.