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:
Mar. 03, 2009
Filed:
Apr. 29, 2003
Said Elnaffar, Kingston, CA;
Randall W. Horman, Toronto, CA;
Sam S. Lightstone, Toronto, CA;
Pat Martin, Kingston, CA;
Bernhard K. Schiefer, Pickering, CA;
Robin D. Van Boeschoten, Kitchener, CA;
Said Elnaffar, Kingston, CA;
Randall W. Horman, Toronto, CA;
Sam S. Lightstone, Toronto, CA;
Pat Martin, Kingston, CA;
Bernhard K. Schiefer, Pickering, CA;
Robin D. Van Boeschoten, Kitchener, CA;
International Business Machines Corporation, Armonk, NY (US);
Abstract
Workload type to be managed by a database management system (DBMS) is a key consideration in tuning the DBMS. Allocations for resources, such as main memory, can be very different depending on whether the workload type is Online Transaction Processing (OLTP) or Decision Support System (DSS). The DBMS also experiences changes in workload type during the normal processing cycle of the DBMS. It would be preferable for the database administrators to recognize the significant shifts of workload type that demand reconfiguring the DBMS to maintain acceptable levels of performance. Disclosed is a workload type classifier module, used by a DBMS, for recognizing workload types so that the DBMS may then manage or adjust its performance and reconfigure its resources accordingly. The classifier may be constructed based on the most significant workload characteristics that differentiate OLTP from DSS. The classifier is then used for identifying changes in workload types contained in a workload.