GMTDS Algorithm for Dynamic Management of Transaction under Different Workload Condition: A Novel Approach | Chapter 8 | Research Updates in Mathematics and Computer Science Vol. 1

 This paper highlights a Novel GMTDS Algorithm for Dynamic Management of Transaction under Different Workload Condition. In today’s scenario large enterprise world spread across different locations, continents or having a diverse presence over the globe, where data is enormous and handling such large data over distributed computing becomes critical in real-time database system. Transaction processing ensures that related data is added to or deleted from the database simultaneously, thus preserving data integrity in your application. In transaction processing, data is not written to the database until a commit command is issued. Ensuring that the sequence of updates in the stable warehouses at various locations is safely confirmed or canceled as a single full item of work is a critical task for the distributed environment's transaction management system. Working with Real-Time Database System (RTDBS) and that to on a distributed computing system is a tough task. When we work with distributed environment over larger database, we need to take care of the transaction time period as well as number of transactions that are actually executed (committed) and number of transactions fail. The application on dynamic RTDBS becomes more complex when certain deadlines need to be completed. In this paper, we had carried out the test of CRUD (Create, Read, Update, and Delete) operation on transactional Real-time databases in real time dynamic distributed environment by using the existing EDF, GEDF algorithm and we had compared these algorithms with our proposed GMTDS (Generic Multi-dimensional Transaction Management under Dynamic Settings) algorithm in standalone and distributed environment with a dynamic self adaptive approach for management of transactions.

 

To validate the efficacy of the GMTDS algorithm, comprehensive simulations were conducted under various workload scenarios. Comparative analysis against existing transaction management algorithms showcase the advantages and improvements offered by GMTDS in terms of response times, throughput, and adaptability.

Author(s) Details:

Mohammad Sharfoddin Khatib,
Computer Science and Engineering Department, Anjuman, College of Engineering and Technology, Sadar, Nagpur-440001, India.

Mohammad Atique,
P.G Department of Computer Science and Engineering, Director, UGC –MMTC (Formerly HRDC) S. G. B. Amravati University, Amravati, India.

Sayyed Qudsiya Naaz,
Computer Science and Engineering Department, Anjuman, College of Engineering and Technology, Sadar, Nagpur-440001, India.

Please see the link here: https://stm.bookpi.org/RUMCS-V1/article/view/13675

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