The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 27, 2019
Filed:
Apr. 03, 2014
International Business Machines Corporation, Armonk, NY (US);
Lisa Seacat DeLuca, Baltimore, MD (US);
Dana L. Price, Cary, NC (US);
Joan C. Ruta, Piscataway, NJ (US);
Shelbee D. Smith-Eigenbrode, Thornton, CO (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method and system for sizing databases. Multiple patterns of historical capacity usage by multiple databases are identified. The multiple patterns are statistically significant for multiple characteristics pertaining to utilization of multiple historic databases. The capacity usage is memory usage or central processing unit (CPU) usage. A weighted value of capacity usage is computed for each pattern as an average value of historical capacity usage for each pattern weighted by a function of a fraction of the multiple databases used for each pattern. A total value of capacity usage is computed as a sum of the weighted values of capacity usage. The computed total value of capacity usage is stored. A current database is sized, utilizing the computed total value of capacity usage. The database sizing may be based on query complexity in dependence on rates of occurrence of queries to the historic databases and to the current database.