Monday, 8 November 2021

A Common Database and Transaction Pool to Reduce Data Redundancy and to Maximize Database Throughput in an Integrated Software System of a Particular Domain | Chapter 02 | Recent Advances in Mathematical Research and Computer Science Vol. 2

 The major goal of this work is to adopt and establish a single database from multiple databases in an Integrated Software System for a certain area. As a consequence, data redundancy will be reduced, database maintenance time will be reduced, the development phase of the front-end interface will be simplified, the system's size will be reduced, database throughput will be maximised, and a transaction pool will be implemented. The transaction pool is a database processing optimization tool. The database transactions can be pooled by the system. Transaction pooling increases database throughput while limiting the number of database connections open at any given moment. The transaction pool will also limit the number of times new connection objects are produced, promote connection object reuse, speed up the connection process, and control the amount of resources used on connection maintenance. We also show how to use a transaction pool to link transaction databases to a central database. We've also shown how to use the technology to construct non-visual transaction objects. In practise, we've used this method in our single integrated software system.


Author(S) Details

Mohammad Ghulam Ali
Principal Software Engineer, VGSoM of Indian Institute of Technology Kharagpur, West Bengal, India.

Mohammad Ghulam Murtuza
Computer Programmer, Research Service Center, Post Graduate Department of Physics, Tilka Manjhi Bhagalpur University, Bhagalpur, Bihar, India.

View Book:- https://stm.bookpi.org/RAMRCS-V2/article/view/4449


No comments:

Post a Comment