Performance tuning in modern database systems requires a lot of expertise, is very time consuming and often misdirected. Tuning attempts often lack a methodology that has a holistic view of the database. The absence of historical diagnostic information to investigate performance issues at first occurrence exacerbates the whole tuning process often requiring that problems be reproduced before th...

In this paper, we propose a learning approach to adaptive performance tuning of database applications. The objective is to validate the opportunity to devise a tuning strategy that does not need prior knowledge of a cost model. Instead, the cost model is learned through reinforcement learning. We instantiate our approach to the use case of index tuning. We model the execution of queries and upd...

Schon seit mehreren Jahrzehnten wird bei meisten Unternehmen Performance Tuning von Rechnersystemen betrieben. Dieses Thema wurde wie von der Seite der Unternehmen als auch von der Wissenschaft mittlerweile in zahlreichen unterschiedlichen Aspekten erforscht und ausgearbeitet. Es existieren inzwischen viele wissenschaftliche Artikel und Bücher zu dem Thema, wie z.B. von Dennis Shasha und Philip...

Controlling Quality of Service (QoS) offered by application servers involves selecting appropriate configuration and parameter tuning that would match the application level load. This is a challenging problem, since application servers have many parameters at different levels that often influence the QoS in complex ways. This paper presents an empirical approach to keep the QoS offered close to...

A typical database workload consists of a mix of multiple query instances of di erent query types that run concurrently and interact with each other. That query interactions can have a signi cant impact on database system performance. Hence, developing performance tuning algorithms for database systems requires taking these interactions into account. In this paper we propose three new approache...

In recent years, soft computing methods have generated a large research interest. The synthesis of the fuzzy logic and the evolutionary algorithms is one of these methods. A particular evolutionary algorithm (EA) is differential evolution (DE). As for any EA, DE algorithm also requires parameters tuning to achieve desirable performance. In this paper tuning the perturbation factor vector of DE ...

In order to improve the optimal performance of a machining process, a booster to improve the serve control system performance with high stability for EDM is needed. According to precise movement of machining process using electrical discharge (EMD), adaptive control is proposed as a major option for accuracy and performance improvement. This article is done to design adaptive controller based o...

in this paper, a low voltage and low power (lv/lp) operational transconductance amplifier (ota) using fgmos (floating-gate mos) transistor is proposed. the relative tuning range of 50 is achieved in this ota while only consumes 40 µw with 1.0 v supply voltage in tsmc 0.18 µm cmos technology. the simulation results of the proposed ota show an open loop gain of 30.2 db and a unity gain frequency ...

In recent years, soft computing methods have generated a large research interest. The synthesis of the fuzzy logic and the evolutionary algorithms is one of these methods. A particular evolutionary algorithm (EA) is differential evolution (DE). As for any EA, DE algorithm also requires parameters tuning to achieve desirable performance. In this paper tuning the perturbation factor vector of DE ...

Multivariable liquid level control is essential in process industries to ensure quality of the product and safety of the equipment. However, the significant problems of the control system include excessive time consumption and percentage overshoot, which result from ineffective performance of the tuning methods of the PID controllers used for the system. In this paper, fuzzy logic was used to t...