—Main objective of writing this paper is to adopt a common database in a Comprehensive Information System of a particular domain of interests. This will result in reducing data redundancy, in reducing database maintenance time, in simplifying the development phase of the front-end interface, in minimizing the size of the system, in maximizing the database throughput and in implementing a transaction pool. The transaction pool will reduce the number of times new connection objects are created, will promote connection object reuse, will quicken the process of getting a connection and will control the amount of resources spent on maintaining connections. We also illustrate some examples of a transaction pool to connect transaction databases with a common database. We have also illustrated how to create non-visual transaction objects within the system.
—Relational database, information system, client-server, transaction pool, distributed databases.
Mohammad Ghulam Ali, System Engineer, Academic Post Graduate Studies and Research, Indian Institute of Technology Kharagpur, West Bengal, INDIA, (e-mail: email@example.com, firstname.lastname@example.org), (Phone: 91-3222-282056, 282188, 220176).
Mohammad Ghulam Murtuza, Computer Programmer, Research Service Center, Post Graduate Department of Physics, Tilka Manjhi Bhagalpur University, Bhagalpur, Bihar, INDIA, (e-mail: email@example.com), (Phone : 91-641-2405729)
Cite: Mohammad Ghulam Ali, Member, IACSIT, and Mohammad Ghulam Murtuza, "A Common Database and a Transaction Pool to Reduce Data Redundancy and to Maximize Database Throughput in a Comprehensive Information System of a Particular Domain of Interests," International Journal of Computer Theory and Engineering
vol. 3, no. 5, pp. 617-622, 2011.