CFP last date
20 December 2024
Call for Paper
January Edition
IJCA solicits high quality original research papers for the upcoming January edition of the journal. The last date of research paper submission is 20 December 2024

Submit your paper
Know more
The week's pick
Responsive image
Improved Shuffled Frog Leaping Algorithm with Self-Adaptive Shuffling for Fuzzy Logic PD+G Controller Optimization in Robotic Manipulators

Duc Hoang Nguyen
Random Articles
Reseach Article

Transaction Overhead Reduction by Server Localization in Bank Database Management Systems

by K. Sriraghav, R. Vijayaraghavan, S. Shriram, Shomona Gracia Jacob
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 158 - Number 3
Year of Publication: 2017
Authors: K. Sriraghav, R. Vijayaraghavan, S. Shriram, Shomona Gracia Jacob
10.5120/ijca2017912766

K. Sriraghav, R. Vijayaraghavan, S. Shriram, Shomona Gracia Jacob . Transaction Overhead Reduction by Server Localization in Bank Database Management Systems. International Journal of Computer Applications. 158, 3 ( Jan 2017), 11-16. DOI=10.5120/ijca2017912766

@article{ 10.5120/ijca2017912766,
author = { K. Sriraghav, R. Vijayaraghavan, S. Shriram, Shomona Gracia Jacob },
title = { Transaction Overhead Reduction by Server Localization in Bank Database Management Systems },
journal = { International Journal of Computer Applications },
issue_date = { Jan 2017 },
volume = { 158 },
number = { 3 },
month = { Jan },
year = { 2017 },
issn = { 0975-8887 },
pages = { 11-16 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume158/number3/26887-2017912766/ },
doi = { 10.5120/ijca2017912766 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T00:03:50.565856+05:30
%A K. Sriraghav
%A R. Vijayaraghavan
%A S. Shriram
%A Shomona Gracia Jacob
%T Transaction Overhead Reduction by Server Localization in Bank Database Management Systems
%J International Journal of Computer Applications
%@ 0975-8887
%V 158
%N 3
%P 11-16
%D 2017
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Server localization refers to introduction of local servers that are connected to a main centralized server. The banking system currently prevailing in the country maintains two databases: one for transaction management while the other is maintained for backup. The transactional data from various branches across the country is maintained by a centralized server. In this scenario, given one centralized server, the access overhead becomes too high since all the branches access the main server only. As a part of day-end closing, the database in the main server is duplicated. The proposed system introduces an algorithm named Transaction Overhead Reduction by Localization of Servers (TORLS) – where servers are locally placed - region wise and they contain local databases pertaining to that region. Hence, for intra-regional transactions, it is sufficient that the local servers alone are accessed. For inter-regional transactions, the two region-based local servers are accessed via the main server. The measure of decrease in the overhead is calculated as the number of intra-regional transactions. The duplication server is optional since the integration of local server databases will constitute the main database. The main database is updated at the end of each day thus alleviating the need for duplication.

References
  1. Srivastava, A., Shankar, U. and Tiwari, S.K., 2012. Transaction Management in Homogenous Distributed Real-Time Replicated Database Systems. International Journal of Advanced Research in Computer Science and Software Engineering, 2(6), pp.190-196.
  2. Corbett, J.C., Dean, J., Epstein, M., Fikes, A., Frost, C., Furman, J.J., Ghemawat, S., Gubarev, A., Heiser, C., Hochschild, P. and Hsieh, W., 2013. Spanner: Google’s globally distributed database. ACM Transactions on Computer Systems (TOCS), 31(3), p.8.
  3. Elmasri, R., 2008. Fundamentals of database systems. Pearson Education India.
  4. Selinger, P. G., Astrahan, M. M., Chamberlin, D. D., Lorie, R. A., & Price, T. G. (1979, May). Access path selection in a relational database management system. In Proceedings of the 1979 ACM SIGMOD international conference on Management of data (pp. 23-34). ACM.
  5. Astrahan, M. M., Blasgen, M. W., Chamberlin, D. D., Eswaran, K. P., Gray, J. N., Griffiths, P. P., ... & Putzolu, G. R. (1976). System R: relational approach to database management. ACM Transactions on Database Systems (TODS), 1(2), 97-137.
  6. Haag, S., Cummings, M., & Dawkins, J. (1998). Management information systems. Multimedia systems, 279, 280-297.
  7. A book - Laudon, K. C., & Laudon, J. P. (2000). Management information systems (Vol. 6). Upper Saddle River, NJ: Prentice Hall.
  8. Moorman, C., & Miner, A. S. (1998). Organizational improvisation and organizational memory. Academy of management review, 23(4), 698-723.
  9. Abiteboul, S., Hull, R., & Vianu, V. (1995). Foundations of databases (Vol. 8). Reading: Addison-Wesley.
  10. Lenzerini, M. (2002, June). Data integration: A theoretical perspective. In Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems (pp. 233-246). ACM.
  11. Özsu, M. T., & Valduriez, P. (2011). Principles of distributed database systems. Springer Science & Business Media.
  12. Sheth, A. P., & Larson, J. A. (1990). Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Computing Surveys (CSUR), 22(3), 183-236.
  13. Graefe, G. (1993). Query evaluation techniques for large databases. ACM Computing Surveys (CSUR), 25(2), 73-169.
  14. Shanmugasundaram, J., Tufte, K., Zhang, C., He, G., DeWitt, D. J., & Naughton, J. F. (1999, September). Relational databases for querying XML documents: Limitations and opportunities. In Proceedings of the 25th International Conference on Very Large Data Bases (pp. 302-314). Morgan Kaufmann Publishers Inc.
  15. Kossmann, D. (2000). The state of the art in distributed query processing. ACM Computing Surveys (CSUR), 32(4), 422-469
  16. Carey, M. J., Ceri, S., Bernstein, P., Dayal, U., Faloutsos, C., Freytag, J. C., & Valduriez, P. (2006). Data-Centric Systems and Applications.
  17. Wolfson, O., Jajodia, S., & Huang, Y. (1997). An adaptive data replication algorithm. ACM Transactions on Database Systems (TODS), 22(2), 255-314.
  18. Weikum, G., & Schek, H. J. (1992). Concepts and applications of multilevel transactions and open nested transactions.
  19. Valduriez, P. (1993). Parallel database systems: open problems and new issues. Distributed and parallel Databases, 1(2), 137-165.
  20. Clement, T. Y., & Meng, W. (1998). Principles of database query processing for advanced applications.
  21. Taniar, D., Leung, C. H., Rahayu, W., & Goel, S. (2008). High performance parallel database processing and grid databases (Vol. 67). John Wiley & Sons.
Index Terms

Computer Science
Information Sciences

Keywords

Server localization access overhead inter-regional transactions intra-regional transactions replication

Powered by PhDFocusTM