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. 03, 2010
Filed:
May. 03, 2005
Theodore Jeremy Wasserman, Palo Alto, CA (US);
Haider Rizvi, Richmond Hill, CA;
Thomas Patrick Martin, Kingston, CA;
David Benson Skillicorn, Kingston, CA;
Theodore Jeremy Wasserman, Palo Alto, CA (US);
Haider Rizvi, Richmond Hill, CA;
Thomas Patrick Martin, Kingston, CA;
David Benson Skillicorn, Kingston, CA;
International Business Machines Corporation, Armonk, NY (US);
Abstract
A workload characterization system characterizes an exemplary business intelligence workload for use in sizing a hardware configuration required by a new database system running a similar business intelligence workload. The workload characterization system uses performance-oriented measurements to characterize an exemplary workload in terms of resource usage and performance metrics. The workload characterization system applies unsupervised data mining techniques to group individual business intelligence queries into general classes of queries based on system resource usage, providing insight into the resource demands of queries typical of a business intelligence workload. The general classes of queries are used to define an anticipated workload for a planned database system and to help identify the hardware required for the planned database system.