The week's pick
Reseach Article
Transaction Overhead Reduction by Server Localization in Bank Database Management Systems
| 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
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
- 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.
- 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.
- Elmasri, R., 2008. Fundamentals of database systems. Pearson Education India.
- 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.
- 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.
- Haag, S., Cummings, M., & Dawkins, J. (1998). Management information systems. Multimedia systems, 279, 280-297.
- A book - Laudon, K. C., & Laudon, J. P. (2000). Management information systems (Vol. 6). Upper Saddle River, NJ: Prentice Hall.
- Moorman, C., & Miner, A. S. (1998). Organizational improvisation and organizational memory. Academy of management review, 23(4), 698-723.
- Abiteboul, S., Hull, R., & Vianu, V. (1995). Foundations of databases (Vol. 8). Reading: Addison-Wesley.
- 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.
- Özsu, M. T., & Valduriez, P. (2011). Principles of distributed database systems. Springer Science & Business Media.
- 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.
- Graefe, G. (1993). Query evaluation techniques for large databases. ACM Computing Surveys (CSUR), 25(2), 73-169.
- 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.
- Kossmann, D. (2000). The state of the art in distributed query processing. ACM Computing Surveys (CSUR), 32(4), 422-469
- Carey, M. J., Ceri, S., Bernstein, P., Dayal, U., Faloutsos, C., Freytag, J. C., & Valduriez, P. (2006). Data-Centric Systems and Applications.
- Wolfson, O., Jajodia, S., & Huang, Y. (1997). An adaptive data replication algorithm. ACM Transactions on Database Systems (TODS), 22(2), 255-314.
- Weikum, G., & Schek, H. J. (1992). Concepts and applications of multilevel transactions and open nested transactions.
- Valduriez, P. (1993). Parallel database systems: open problems and new issues. Distributed and parallel Databases, 1(2), 137-165.
- Clement, T. Y., & Meng, W. (1998). Principles of database query processing for advanced applications.
- 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
Keywords