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.
- Elnaffar, S., Martin, P. Characterizing Computer Systems' Workloads. Submitted to ACM Computing Surveys Journal.Google Scholar
- Elnaffar, S. A Methodology for Auto-recognizing DBMS Workloads. To appear in Proceedings of CASCON '02, (November 2002). Google ScholarDigital Library
- IBM, DB2 Intelligent Miner for Data, http://www-4.ibm.com/software/data/iminer/fordata/about.html, IBM (1999).Google Scholar
- IBM, DB2 Universal Database Version 7 Administration Guide: Performance, IBM Corporation (2000).Google Scholar
- IBM, Autonomic Computing: IBM's Perspective on the State of Information Technology, at http://www.research.ibm.com/autonomic/manifesto/, (June 2002).Google Scholar
- Oracle9iDatabase Performance Guide and Reference, Release 1(9.0.1), Part# A87503-02, Oracle Corp. (2001).Google Scholar
- Shafer, J.C., Agrawal, R., Mehta, M. SPRINT: A Scalable Parallel Classifier for Data Mining. Proc. of the 22th Int'l Conference on Very Large Databases, Mumbai (Bombay), India (September 1996). Google ScholarDigital Library
- TPC Benchmark W (Web Commerce) Standard Specification Revision 1.7, Transaction Processing Performance Council (October 2001).Google Scholar
Recommendations
Query-based Workload Forecasting for Self-Driving Database Management Systems
SIGMOD '18: Proceedings of the 2018 International Conference on Management of DataThe first step towards an autonomous database management system (DBMS) is the ability to model the target application's workload. This is necessary to allow the system to anticipate future workload needs and select the proper optimizations in a timely ...
Automatic Database Management System Tuning Through Large-scale Machine Learning
SIGMOD '17: Proceedings of the 2017 ACM International Conference on Management of DataDatabase management system (DBMS) configuration tuning is an essential aspect of any data-intensive application effort. But this is historically a difficult task because DBMSs have hundreds of configuration "knobs" that control everything in the system, ...
MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems
SIGMOD '21: Proceedings of the 2021 International Conference on Management of DataDatabase management systems (DBMSs) are notoriously difficult to deploy and administer. The goal of a self-driving DBMS is to remove these impediments by managing itself automatically. However, a critical problem in achieving full autonomy is how to ...
Comments