Current Volume 9
Abstract
Modern database systems operate under increasingly dynamic workloads that render static configuration and manual tuning obsolete. Closed-loop database tuning, where the system automatically observes the performance metrics, diagnoses the bottlenecks and applies corrective actions, has emerged as a promising paradigm for self-managing databases. But the tuning problem is inherently multi-objective and multi-component: knob configuration, index selection, query rewriting and materialized view maintenance each need specialized optimization strategies which can conflict with each other. In this paper, we propose a cooperative multi-agent negotiation framework in which autonomous agents are responsible for a specific tuning dimension and engage in structured negotiation protocols to reach collectively optimal decisions. We formalize the negotiation as a constrained multi-objective optimization problem, design a coalition formation mechanism based on cooperative game theory, and evaluate the framework on the TPC-H and TPC-DS benchmarks against state-of-the-art single-agent and heuristic baselines. Experimental results show that the proposed framework improves the aggregate throughput by 18-34% and the tail latency by 22-41% over existing approaches while being stable against the workload phase transitions. The paper presents a principled theoretical basis for multi-agent database tuning, and a practical architecture that can be deployed in production environments.
Keywords
Multi-Agent Systems, Database Tuning, Index Optimization, Closed Loop Control, Cooperative Game Theory, Self Managing Databases, Query Optimization
Citations
IRE Journals:
Shahid Moosa "Cooperative Multi-Agent Negotiation for Closed-Loop Database Tuning and Index Optimization" Iconic Research And Engineering Journals Volume 9 Issue 12 2026 Page 2120-2127 https://doi.org/10.64388/IREV9I12-1719075
IEEE:
Shahid Moosa
"Cooperative Multi-Agent Negotiation for Closed-Loop Database Tuning and Index Optimization" Iconic Research And Engineering Journals, 9(12) https://doi.org/10.64388/IREV9I12-1719075
About IRE Journals
IRE Journals is an open access online journals established with an aim to publish high quality of research work in various diciplines. We have more than 6 years in publications. Over 2500+ papers already published.
Important Links
For Authors
Volume 9:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 8:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 7:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 6:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 5:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 4:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 3:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12