面向工作负载动态资源的自调优

First International Workshop on Knowledge Discovery and Data Mining (WKDD 2008) Pub Date : 2008-01-21 DOI:10.1109/WKDD.2008.112

Fu Duan, Yong-hua Han, Qiuyong Zhao, Keming Xie

{"title":"面向工作负载动态资源的自调优","authors":"Fu Duan, Yong-hua Han, Qiuyong Zhao, Keming Xie","doi":"10.1109/WKDD.2008.112","DOIUrl":null,"url":null,"abstract":"In self-tuning of database performance research area, the optimization of dynamic resources is important. This paper focused on the self-tuning of dynamic resources on the base of feedback mechanism, designed and achieved a simple model combined with Oracle database. This model gave an evaluating principle of system performance, and could adjust system parameters automatically to achieve the goal of system performance. And an evaluation model was designed to evaluate the performance state of the running system. The result after the self-tuning of some parameters was illustrated by simulating various workloads.","PeriodicalId":101656,"journal":{"name":"First International Workshop on Knowledge Discovery and Data Mining (WKDD 2008)","volume":"260 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2008-01-21","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"4","resultStr":"{\"title\":\"Towards Self-Tuning of Dynamic Resources for Workloads\",\"authors\":\"Fu Duan, Yong-hua Han, Qiuyong Zhao, Keming Xie\",\"doi\":\"10.1109/WKDD.2008.112\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"In self-tuning of database performance research area, the optimization of dynamic resources is important. This paper focused on the self-tuning of dynamic resources on the base of feedback mechanism, designed and achieved a simple model combined with Oracle database. This model gave an evaluating principle of system performance, and could adjust system parameters automatically to achieve the goal of system performance. And an evaluation model was designed to evaluate the performance state of the running system. The result after the self-tuning of some parameters was illustrated by simulating various workloads.\",\"PeriodicalId\":101656,\"journal\":{\"name\":\"First International Workshop on Knowledge Discovery and Data Mining (WKDD 2008)\",\"volume\":\"260 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2008-01-21\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"4\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"First International Workshop on Knowledge Discovery and Data Mining (WKDD 2008)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/WKDD.2008.112\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"First International Workshop on Knowledge Discovery and Data Mining (WKDD 2008)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/WKDD.2008.112","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 4

摘要

在数据库性能自调优研究领域中，动态资源的优化是一个重要问题。本文主要研究基于反馈机制的动态资源自调优问题，结合Oracle数据库设计并实现了一个简单的模型。该模型给出了系统性能的评价原则，并能自动调整系统参数以达到系统性能的目标。并设计了一个评价模型，对运行系统的性能状态进行评价。通过对各种工作负载的仿真，说明了部分参数自调优后的结果。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Towards Self-Tuning of Dynamic Resources for Workloads

In self-tuning of database performance research area, the optimization of dynamic resources is important. This paper focused on the self-tuning of dynamic resources on the base of feedback mechanism, designed and achieved a simple model combined with Oracle database. This model gave an evaluating principle of system performance, and could adjust system parameters automatically to achieve the goal of system performance. And an evaluation model was designed to evaluate the performance state of the running system. The result after the self-tuning of some parameters was illustrated by simulating various workloads.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

First International Workshop on Knowledge Discovery and Data Mining (WKDD 2008)

自引率

0.00%

发文量