Dynamic Cache Allocation for Multi-Tenant Database Clusters Using Fuzzy Control Systems

International Journal of Computer Science and Technology | Vol. 8, No. 12, December 2006 | pp. 97–104

DOI: 10.46882/2006/IJCST/081328

Research Article

Title: Dynamic Cache Allocation for Multi-Tenant Database Clusters Using Fuzzy Control Systems

Names of Authors: Emily Watson¹, Clara Mendonça²

Authors’ Affiliations: ¹Department of Computer Science, Stanford University, California, USA; ²Departamento de Informática, Universidade de São Paulo, São Paulo, Brazil

Abstract:
Resource allocation within shared multi-tenant database systems is complex due to the erratic and shifting nature of transactional workloads. This study presents an automated cache management infrastructure driven by a two-stage fuzzy control system. The model continually measures tenant hit-miss ratios and execution queue lengths to dynamically alter RAM buffer boundaries across active database containers. The control framework was evaluated using a mixed TPC-C transactional workload simulation setup. The experimental results show that the fuzzy allocation engine drops average query response latencies by 34.2% during intense traffic spikes compared to static allocation models. High-priority tenant performance SLA drop-offs were entirely avoided, while overall cache utilization efficiency increased by μ = 18.5% ± 0.6% across the hardware infrastructure without causing storage layer execution penalties.

Keywords: Multi-Tenant Systems, Cache Management, Fuzzy Control, Database Optimization, Resource Allocation

Manuscript Timeline: Received September 04, 2006; Revised October 20, 2006; Accepted November 11, 2006; Published December 28, 2006

Citation: Watson, E., & Mendonça, C. (2006). Dynamic Cache Allocation for Multi-Tenant Database Clusters Using Fuzzy Control Systems. International Journal of Computer Science and Technology, 8(13), 97–104.

Subscribe to read the full article: https://www.internationalscholarsjournals.org/subscribe-to-read