No abstract

No abstract

The type of the workload on a database management system (DBMS) is a key consideration in tuning the system. 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). In this paper, we present an approach to automatically identifying a DBMS workload as either OLTP or DSS. We build a classification model based on the most significant workload characteristics that differentiate OLTP from DSS, and then use the model to identify any change in the workload type. We construct a workload classifier from the Browsing and Ordering profiles of the TPC-W benchmark. Experiments with an industry-supplied workload show that our classifier accurately identifies the mix of OLTP and DSS work within an application workload.

No abstract

• Virtualized-allowing a collection of distributed information resources to be shared and managed as if they were a single information store, although they may in fact remain fully distributed. • Autonomic-ensuring that the interconnected information systems can be managed effectively and efficiently through self-management just like the human autonomic nervous system. • Open-utilizing open interfaces and agreed-upon standards to enable highly interoperable systems and processes.