Identifying a workload type for a given workload of database...

Details Identifying a workload type for a given workload of database... Identifying a workload type for a given workload of database...

G - Physics

06

F

G06F 17/30 (2006.01) G06F 17/60 (2000.01)

Patent

CA 2426439

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 shifts 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 that 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.

Affiliated with

Also associated with

Rating

Identifying a workload type for a given workload of database... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Identifying a workload type for a given workload of database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Identifying a workload type for a given workload of database... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1939522