EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Adaptive Query Optimization and Workload-Aware Resource Allocation in CockroachDB Distributed Cloud Databases

Ramesh Venkatachalapathy

International Journal of Industrial Engineering · 31.10.2026 · 10 (2) · 40-50

DOI: 10.65000/hsx5df86 ↗

Kurz gefasst

Fachartikel in der Zeitschrift International Journal of Industrial Engineering, online erschienen am 31.10.2026. Verfasst von Ramesh Venkatachalapathy. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

CockroachDB distributed cloud database solutions improve query processing and resource utilization by adaptive query optimization and workload-aware resource allocation. This technique uses workload detection, rule-based query plan selection, index evaluation, and threshold-based CPU, memory, and concurrency constraints. Contrary to traditional static configurations, this approach combines query optimization with resource management and relies on feedback during execution for adjustment of the following workload decisions regardless of artificial intelligence or machine learning techniques. The innovation consists in the integration of workload-aware query optimization with resource management in one distributed SQL optimization framework. The experimental validation is based on the Transaction Processing Performance Council Benchmark C (TPC-C) transactional workload that simulates wholesale transactions with nine relational tables, such as WAREHOUSE, CUSTOMER, ORDERS, and STOCK. Provided benchmark tables show illustrative results: total query latency varies from 32 to 90 ms across five workload classes, transaction throughput grows from 900 to 3,390 transactions per second. Meanwhile, CPU utilization goes from 22% to 60%, in contrast to 28% to 81% in default configuration. These preliminary numbers indicate potential performance gains, but controlled CockroachDB experiments should be run to prove the suggested optimization approach.

Zitieren

APA

Venkatachalapathy, R. (2026). Adaptive Query Optimization and Workload-Aware Resource Allocation in CockroachDB Distributed Cloud Databases. International Journal of Industrial Engineering, 10(2), 40-50. https://doi.org/10.65000/hsx5df86

Vancouver

Venkatachalapathy R. Adaptive Query Optimization and Workload-Aware Resource Allocation in CockroachDB Distributed Cloud Databases. International Journal of Industrial Engineering. 2026;10(2):40-50. doi:10.65000/hsx5df86

BibTeX
@article{Venkatachalapathy2026,
  author = {Venkatachalapathy, Ramesh},
  title = {Adaptive Query Optimization and Workload-Aware Resource Allocation in CockroachDB Distributed Cloud Databases},
  journal = {International Journal of Industrial Engineering},
  year = {2026},
  volume = {10},
  number = {2},
  pages = {40--50},
  doi = {10.65000/hsx5df86}
}
Kostenlos starten →