{"title":"基于C5.0算法的DBMS工作负载自动识别","authors":"Zhixian Niu, L. Zong, Q. Yan, Zhenxing Zhao","doi":"10.1109/WKDD.2009.185","DOIUrl":null,"url":null,"abstract":"The type of the workload is one of the key factors on database management system (DBMS) tuning. Different types of workload (OLTP, Online Transaction Processing and OLAP, Online Analytical Processing) mean different resource allocation strategies. In this paper, we present an approach to automatically identify a DBMS workload as either OLTP or OLAP. We use C5.0 algorithm to construct a set of classifiers based on the characteristics that differentiate OLTP and OLAP and then use the classifier to identify the workload type. The experiments show that the classifiers can be able to accurately identify the OLTP and OLAP workloads.","PeriodicalId":143250,"journal":{"name":"2009 Second International Workshop on Knowledge Discovery and Data Mining","volume":"23 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2009-01-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"8","resultStr":"{\"title\":\"Auto-recognizing DBMS Workload Based on C5.0 Algorithm\",\"authors\":\"Zhixian Niu, L. Zong, Q. Yan, Zhenxing Zhao\",\"doi\":\"10.1109/WKDD.2009.185\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The type of the workload is one of the key factors on database management system (DBMS) tuning. Different types of workload (OLTP, Online Transaction Processing and OLAP, Online Analytical Processing) mean different resource allocation strategies. In this paper, we present an approach to automatically identify a DBMS workload as either OLTP or OLAP. We use C5.0 algorithm to construct a set of classifiers based on the characteristics that differentiate OLTP and OLAP and then use the classifier to identify the workload type. The experiments show that the classifiers can be able to accurately identify the OLTP and OLAP workloads.\",\"PeriodicalId\":143250,\"journal\":{\"name\":\"2009 Second International Workshop on Knowledge Discovery and Data Mining\",\"volume\":\"23 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2009-01-23\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"8\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2009 Second International Workshop on Knowledge Discovery and Data Mining\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/WKDD.2009.185\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2009 Second International Workshop on Knowledge Discovery and Data Mining","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/WKDD.2009.185","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Auto-recognizing DBMS Workload Based on C5.0 Algorithm
The type of the workload is one of the key factors on database management system (DBMS) tuning. Different types of workload (OLTP, Online Transaction Processing and OLAP, Online Analytical Processing) mean different resource allocation strategies. In this paper, we present an approach to automatically identify a DBMS workload as either OLTP or OLAP. We use C5.0 algorithm to construct a set of classifiers based on the characteristics that differentiate OLTP and OLAP and then use the classifier to identify the workload type. The experiments show that the classifiers can be able to accurately identify the OLTP and OLAP workloads.
求助内容：
应助结果提醒方式：
京公网安备 11010802042870号
