IDENTIFYING A WORKLOAD TYPE FOR A GIVEN WORKLOAD OF DATABASEREQUESTS

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. Database administrators must therefore recognize the significant shift s of workload type that demand reconfiguring the DBMS in order 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 reconfiguring its resources accordingly. The classifier may be constructed based on the most significant workload characteristics th at differentiate OLTP from DSS; then, the classifier is used for identifying changes in workload types contained in a workload. One aspect, there is provided, for an information retrieval system, a method of identifying a workload type for a given workload, including selecting a sample of the given workload, and predicting identification of the workload type based on a comparison between the selected sample and a set of rules.