Mathematics and Computing for Scientific Innovation Vol. 1

A distributed database is a collection of multiple, logically interrelated databases distributed over a computer network. A Distributed Database Management System (DDBMS) plays a significant role in big data analysis using a cloud software stack in SaaS cloud computing models. Many issues associated with managing a centralised database include data isolation, redundancy, inconsistency, and atomicity of updates, among others; however, distributed database implementation over high-performance compute nodes maximises information value across networks. In addition, the analysis of big data generated or consumed over the mobile Internet, the Internet of Things (IoT), and cloud computing necessitates low-latency reads and faster updates across clusters. Conventionally, services in distributed systems demand optimised transactions. This paper examines transaction generation over a distributed storage pool using the suggested reference architectures of fragmentation with hybrid semi-join operations. To offer mobility transparency as an additional element of the integrity transparency offered by a DDBMS, the distributed storage pool is simulated using a configured WLAN with multiple concurrent file transfers involving mobile nodes and large file sizes. The major functionality of the storage pool is enhanced by storage virtualisation, whereby a global schema query optimiser manages transactions to characterise latency-driven throughput. Through the joint optimisation of network and storage virtualisation, an integrated virtualised storage system leverages embedded replication technology to deliver robustness and fault-tolerance characteristics. The Heterogeneous Local Schema (LS) Multi-Database design framework enabled measurements of low-latency reads and updates. An appreciable improvement in service delivery, attributed to the distributed storage pool (DSP), was facilitated by hybridised RAID construction and copy mechanisms. Low-latency read and update transactions, improved response time, and accelerated transmissions indicated improved services. Evaluation of the simulated DDBMS model and DSP architecture showed that all complexity (overheads) associated with conventional shared systems was eliminated. Finally, the provisioned mobile Transmission Control Protocol (M-TCP) gave the best overall performance for concurrent transactions across heterogeneous multi-database sites in the integrated network.