Abstract

 
 
 The use of software agents as Database Management System components lead to database systems that may be configured and extended to support new requirements. We focus here with the self-tuning feature, which demands a somewhat intelligent behavior that agents could add to traditional DBMS modules. We propose in this paper an agent-based database architecture to deal with automatic index creation. Implementation issues are also discussed, for a built-in agents and DBMS integration architecture.
 
 
Highlights
The software agents’ research area aims at building systems that deal with heterogeneous, distributed and dynamic environments [33]
In this paper we propose the use of software agents to deal with self-tuning and Database Management Systems (DBMSs) operational requirements
We present an architecture where most DBMSs self-tuning approaches fit and show how it can be implemented by the use of software agents
Summary
The software agents’ research area aims at building systems that deal with heterogeneous, distributed and dynamic environments [33]. In this paper we propose the use of software agents to deal with self-tuning and DBMSs operational requirements. It should be noted that some of the existing approaches for index self-tuning, mostly in commercial DBMSs, are based only on index suggestion for specific workloads, leaving to the database administrator the decision on choosing the right representative workload and of the index creating. In our work we propose an index self-tuning complete process with automatic creation of indexes in a agent-based database architecture. This paper extends the work presented in [8], showing revised heuristics for an index selection agent’s decision process and discussing an object-oriented design for the implementation of this agent in a real DBMS. We discuss some existing works related with semi-automatic index tuning and propose a self-tuning engine on an agent-based database architecture.
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
