CAJ | 학술논문

为了优化自主数据库系统多个负载的多个性能目标，解决多个性能目标之间的相互约束关系，提出负载重要性的概念。通过重要性区分负载，使各负载的性能特性达到各自的性能要求，用效用函数来封装负载的多性能目标和重要性，从而实现性能目标和重要性到资源分配的映射，并提出了优化多性能目标效用函数选择的基本准则。通过效用函数构造目标函数并进行优化来实现统一管理数据库系统的多个性能目标，通过设计的查询调度器验证了该方法的有效性。
위료우화자주수거고계통다개부재적다개성능목표，해결다개성능목표지간적상호약속관계，제출부재중요성적개념。통과중요성구분부재，사각부재적성능특성체도각자적성능요구，용효용함수래봉장부재적다성능목표화중요성，종이실현성능목표화중요성도자원분배적영사，병제출료우화다성능목표효용함수선택적기본준칙。통과효용함수구조목표함수병진행우화래실현통일관리수거고계통적다개성능목표，통과설계적사순조도기험증료해방법적유효성。
For optimising the multiple performance objectives of multiple workloads in autonomous database system and solving the mutual restraint relationship between the multiple performance objectives,we proposed the concept of workload importance in order to make the performance characteristic of every workload reach the performance requirement of each by using importance to distinguish the workloads.The utility function was employed in encapsulating the multiple performance objectives and importance of the workloads,so as to achieve the mapping from the performance objectives and importance to resource allocation.In addition,we proposed the basic criteria of utility function selection which is used to optimise the multiple performance objectives.The unified management of multiple performance objectives in database system was achieved by using utility function to construct the objective function and then to optimise it further.Finally the effective-ness of the method was verified by the designed query scheduler.