General Information
    • ISSN: 1793-8201 (Print), 2972-4511 (Online)
    • Abbreviated Title: Int. J. Comput. Theory Eng.
    • Frequency: Quarterly
    • DOI: 10.7763/IJCTE
    • Editor-in-Chief: Prof. Mehmet Sahinoglu
    • Associate Editor-in-Chief: Assoc. Prof. Alberto Arteta, Assoc. Prof. Engin Maşazade
    • Managing Editor: Ms. Cecilia Xie
    • Abstracting/Indexing: Scopus (Since 2022), INSPEC (IET), CNKI,  Google Scholar, EBSCO, etc.
    • Average Days from Submission to Acceptance: 192 days
    • APC: 800 USD
    • E-mail: editor@ijcte.org
    • Journal Metrics:
    • SCImago Journal & Country Rank
Article Metrics in Dimensions

IJCTE 2011 Vol.3(5): 617-622 ISSN: 1793-8201
DOI: 10.7763/IJCTE.2011.V3.380

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

Mohammad Ghulam Ali and Mohammad Ghulam Murtuza

Abstract—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.

Index Terms—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: ali@hijli.iitkgp.ernet.in, ali_iit@yahoo.com), (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: mgm_rsc@yahoo.co.uk), (Phone : 91-641-2405729)

[PDF]

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.


Copyright © 2008-2024. International Association of Computer Science and Information Technology. All rights reserved.