Implementation of an agent architecture for automated index tuning

Rogério Luís De Carvalho Costa; Sérgio Lifschitz; Maíra Ferreira De Noronha; Marcos Antonio Vaz Salles

doi:10.1109/ICDE.2005.228

Implementation of an agent architecture for automated index tuning

Rogério Luís De Carvalho Costa^*, Sérgio Lifschitz, Maíra Ferreira De Noronha, Marcos Antonio Vaz Salles

^*Corresponding author af dette arbejde

Software, Data, People & Society

Publikation: Bidrag til bog/antologi/rapport › Konferencebidrag i proceedings › Forskning › peer review

3 Citationer (Scopus)

Abstract

It has been Important to extend database management systems to support new requirements of applications and administration. We focus in this paper on the automatic tuning feature, particularly manipulation of indexes. The architectural approach considered here is based on software agents. We briefly present the heuristics involved in the decision upon creation, dropping and the exact moment to proceed with either action. Then we discuss our agent-based database architecture, with its layers and coupling within an actual DBMS. Finally, we explain the way our hypothetical indexes are integrated in PostgreSQL and how they can be used in practice for automated index tuning.

Originalsprog	Engelsk
Titel	Proceedings - International Conference on Data Engineering Workshops : Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005
Publikationsdato	2005
Artikelnummer	1647832
ISBN (Trykt)	0769526578, 9780769526577
DOI	https://doi.org/10.1109/ICDE.2005.228
Status	Udgivet - 2005
Begivenhed	21st International Conference on Data Engineering Workshops 2005 - Tokyo, Japan Varighed: 3 apr. 2005 → 4 apr. 2005

Konference

Konference	21st International Conference on Data Engineering Workshops 2005
Land/Område	Japan
By	Tokyo
Periode	03/04/2005 → 04/04/2005
Sponsor	The IEEE Computer Society, The Database Society of Japan, DBSJ, Information Processing Society of Japan, IPSJ, The Inst. of Elec., Info. and Com. Engineers, IEICE

Navn	Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005
Vol/bind	2005

Adgang til dokumentet

10.1109/ICDE.2005.228

Andre filer og links

Link to publication in Scopus

Citationsformater

Implementation of an agent architecture for automated index tuning. / De Carvalho Costa, Rogério Luís; Lifschitz, Sérgio; De Noronha, Maíra Ferreira et al.
Proceedings - International Conference on Data Engineering Workshops: Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005. 2005. 1647832 (Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005, Bind 2005).

Publikation: Bidrag til bog/antologi/rapport › Konferencebidrag i proceedings › Forskning › peer review

De Carvalho Costa, RL, Lifschitz, S, De Noronha, MF & Salles, MAV 2005, Implementation of an agent architecture for automated index tuning. i Proceedings - International Conference on Data Engineering Workshops: Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005., 1647832, Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005, bind 2005, 21st International Conference on Data Engineering Workshops 2005, Tokyo, Japan, 03/04/2005. https://doi.org/10.1109/ICDE.2005.228

De Carvalho Costa RL, Lifschitz S, De Noronha MF, Salles MAV. Implementation of an agent architecture for automated index tuning. I Proceedings - International Conference on Data Engineering Workshops: Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005. 2005. 1647832. (Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005, Bind 2005). doi: 10.1109/ICDE.2005.228

De Carvalho Costa, Rogério Luís ; Lifschitz, Sérgio ; De Noronha, Maíra Ferreira et al. / Implementation of an agent architecture for automated index tuning. Proceedings - International Conference on Data Engineering Workshops: Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005. 2005. (Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005, Bind 2005).

@inproceedings{a8d82966b95046feb36c34e195c357ba,

title = "Implementation of an agent architecture for automated index tuning",

abstract = "It has been Important to extend database management systems to support new requirements of applications and administration. We focus in this paper on the automatic tuning feature, particularly manipulation of indexes. The architectural approach considered here is based on software agents. We briefly present the heuristics involved in the decision upon creation, dropping and the exact moment to proceed with either action. Then we discuss our agent-based database architecture, with its layers and coupling within an actual DBMS. Finally, we explain the way our hypothetical indexes are integrated in PostgreSQL and how they can be used in practice for automated index tuning.",

author = "{De Carvalho Costa}, {Rog{\'e}rio Lu{\'i}s} and S{\'e}rgio Lifschitz and {De Noronha}, {Ma{\'i}ra Ferreira} and Salles, {Marcos Antonio Vaz}",

year = "2005",

doi = "10.1109/ICDE.2005.228",

language = "English",

isbn = "0769526578",

series = "Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005",

booktitle = "Proceedings - International Conference on Data Engineering Workshops",

note = "21st International Conference on Data Engineering Workshops 2005 ; Conference date: 03-04-2005 Through 04-04-2005",

}

TY - GEN

T1 - Implementation of an agent architecture for automated index tuning

AU - De Carvalho Costa, Rogério Luís

AU - Lifschitz, Sérgio

AU - De Noronha, Maíra Ferreira

AU - Salles, Marcos Antonio Vaz

PY - 2005

Y1 - 2005

N2 - It has been Important to extend database management systems to support new requirements of applications and administration. We focus in this paper on the automatic tuning feature, particularly manipulation of indexes. The architectural approach considered here is based on software agents. We briefly present the heuristics involved in the decision upon creation, dropping and the exact moment to proceed with either action. Then we discuss our agent-based database architecture, with its layers and coupling within an actual DBMS. Finally, we explain the way our hypothetical indexes are integrated in PostgreSQL and how they can be used in practice for automated index tuning.

AB - It has been Important to extend database management systems to support new requirements of applications and administration. We focus in this paper on the automatic tuning feature, particularly manipulation of indexes. The architectural approach considered here is based on software agents. We briefly present the heuristics involved in the decision upon creation, dropping and the exact moment to proceed with either action. Then we discuss our agent-based database architecture, with its layers and coupling within an actual DBMS. Finally, we explain the way our hypothetical indexes are integrated in PostgreSQL and how they can be used in practice for automated index tuning.

UR - http://www.scopus.com/inward/record.url?scp=33947099446&partnerID=8YFLogxK

U2 - 10.1109/ICDE.2005.228

DO - 10.1109/ICDE.2005.228

M3 - Article in proceedings

AN - SCOPUS:33947099446

SN - 0769526578

SN - 9780769526577

T3 - Proceedings - International Workshop on Self-Managing Database Systems, SMDB 2005

BT - Proceedings - International Conference on Data Engineering Workshops

T2 - 21st International Conference on Data Engineering Workshops 2005

Y2 - 3 April 2005 through 4 April 2005

ER -