Optimizing Intensive Database Tasks Through Caching Proxy Mechanisms

Ionut,-Alex Moise, Alexandra Băicoianu

2024

Abstract

Web caching is essential for the World Wide Web, saving processing power, bandwidth, and reducing latency. Many proxy caching solutions focus on buffering data from the main server, neglecting cacheable information meant for server writes. Existing systems addressing this issue are often intrusive, requiring modifications to the main application for integration. We identify opportunities for enhancement in conventional caching proxies. This paper explores, designs, and implements a potential prototype for such an application. Our focus is on harnessing a faster bulk-data-write approach compared to single-data-write within the context of relational databases. If a (upload) request matches a specified cacheable URL, then the data will be extracted and buffered on the local disk for later bulk-write. In contrast with already existing caching proxies, Squid for example, in a similar uploading scenario, the request would simply get redirected, leaving out potentially gains such us minimized processing power, lower server load and bandwidth. After prototyping and testing the suggested application against Squid, concerning data uploads with 1, 100, 1.000,..., 100.000 requests, we consistently observed query execution improvements ranging from 5 to 9 times. This enhancement was achieved through buffering and bulk-writing the data, the extent of which depended on the specific test conditions.

Paper Citation

in Harvard Style

Moise I. and Băicoianu A. (2024). Optimizing Intensive Database Tasks Through Caching Proxy Mechanisms. In Proceedings of the 19th International Conference on Software Technologies - Volume 1: ICSOFT; ISBN 978-989-758-706-1, SciTePress, pages 367-374. DOI: 10.5220/0012754600003753

in Bibtex Style

@conference{icsoft24,
author={Ionut,-Alex Moise and Alexandra Băicoianu},
title={Optimizing Intensive Database Tasks Through Caching Proxy Mechanisms},
booktitle={Proceedings of the 19th International Conference on Software Technologies - Volume 1: ICSOFT},
year={2024},
pages={367-374},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0012754600003753},
isbn={978-989-758-706-1},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 19th International Conference on Software Technologies - Volume 1: ICSOFT
TI - Optimizing Intensive Database Tasks Through Caching Proxy Mechanisms
SN - 978-989-758-706-1
AU - Moise I.
AU - Băicoianu A.
PY - 2024
SP - 367
EP - 374
DO - 10.5220/0012754600003753
PB - SciTePress