Performance analysis of a database
US9589019B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 6, 2013 |
| Grant date | Mar 7, 2017 |
| Priority date | — |
| Expiry date | Nov 15, 2034 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2201/80
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system are provided for performance analysis of a database. The method includes receiving a proposed data model, generating a hypothetical query workload using a plurality of sample query templates representing different query constructs for the proposed data model, generating hypothetical optimizer statistics using predefined generating rules that include a projected cardinality for the proposed data model and creating a sample empty database and database schema using the proposed data model. The method also includes applying the hypothetical optimizer statistics to the sample empty database, based on generating the hypothetical optimizer statistics, applying each query construct of the hypothetical query workload to the database schema and estimating a cost of the hypothetical query workload for the proposed data model.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.