Enhancing Call Level Interfaces with Thread-safe Local Memory Structures

Óscar Mortágua Pereira, Rui L. Aguiar, "Enhancing Call Level Interfaces with Thread-safe Local Memory Structures", IJSEKE - Intl. Journal on Software Engineering and Knowledge Engineering, Dec 2017

Abstract

Database applications are being increasingly under pressure to respond effectively to ever more demanding performance requirements. Software architects can resort to several well-known architectural tactics to minimize the possibility of coming across with any performance bottleneck. The usage of Call Level Interfaces (CLI) is a strategy aimed at reducing the overhead of business components. CLI are low level API that provide a high performance environment to execute standard SQL statements on relational and also on some NoSQL database servers. In spite of these valuable features, CLI are not thread safe when distinct threads need to share datasets retrieved through Select statements from databases. Thus, even in situations where two or more threads could share a dataset, there is no other possibility than providing each thread with its own dataset, this way leading to an increased need of computational resources. To overcome this drawback, in this paper we propose a new natively thread-safe architecture. The implementation herein presented is based on a thread safe updatable local memory structure where data retrieved from databases is kept. A proof of concept based on Java Database Connectivity type 4 (JDBC) for SQL Server 2008 is presented and also a performance assessment.

Information

Magazine: IJSEKE - Intl. Journal on Software Engineering and Knowledge Engineering