Browse > Article
http://dx.doi.org/10.3745/KTSDE.2014.3.11.471

Database Transaction Routing Algorithm Using AOP  

Kang, Hyun Sik (고려대학교 소프트웨어공학과)
Lee, Sukhoon (고려대학교 컴퓨터.전파통신공학과)
Baik, Doo-Kwon (고려대학교 융합소프트웨어전문대학원)
Publication Information
KIPS Transactions on Software and Data Engineering / v.3, no.11, 2014 , pp. 471-478 More about this Journal
Abstract
Database replication is utilized to increase credibility, availability and prevent overload of distributed databases. Two models currently exist for replication - Master/Slave and Multi-Master. Since the Multi-Master model has problems of increasing complexity and costs to interface among multiple databases for updates and inserts, the Master/Slave model is more appropriate when frequent data inserts and updates are required. However, Master/Slave model also has a problem of not having exact criteria when systems choose to connect between Master and Slave for transactions. Therefore, this research suggests a routing algorithm based on AOP (Aspect Oriented Programming) in the Master/Slave database model. The algorithm classifies applications as cross-cutting concerns based on AOP, modularizes each concern, and routes transactions among Master and Slave databases. This paper evaluates stability and performance of the suggested algorithm through integration tests based on scenarios.
Keywords
AOP; Transaction; Routing; Transaction Routing; Database;
Citations & Related Records
연도 인용수 순위
  • Reference
1 E. Cecchet, G. Candea, and A. Ailamaki, "Middleware-based Database Replication: The Gaps Between Theory and Practice," In Proceedings of the 2008 ACM SIGMOD international conference on Management of data, pp.739-752, 2008.
2 K. K. Hercule, M. M. Eugine, B. B. Paulin, and L. B. Joel, "Study of the Master/Slave replication in a distributed database," International Journal of Computer Science Issues, Vol.8, No.5, pp.319-326, 2011.
3 G. Kiczales, E. Hilsdale, J. Hugunin, M. Kersten, J. Palm, and W. G. Griswold, "An overview of AspectJ," ECOOP 2001-Object-Oriented Programming. Springer Berlin Heidelberg, pp.327-354, 2001.
4 S. H. Kim, M. S. Kim, and S. Y. Park, "An Identification and Specification Method of Crosscutting Concerns based on Goal-Scenario Modeling for Aspect-Oriented Software Development," Journal of Korea Information Science Society, Vol.35, No.7, pp.424-430, 2008.
5 M. Petrini, "Distributed Databases Management Using Replication Method," The Annals of the University of Petrosani, Economics, Vol.9, No.4, pp.135-140, 2009.
6 D. J. Choi, K. S. Chung, and J. S. Shon, "An Improvement on the Weighted Least-Connection Scheduling Algorithm in Web Cluster Systems," Korea Internet Service Promotion Association, Vol.33, No.1, pp.199-201, 2006.
7 S. Gancarski, H. Naacke, E. Pacitti, and P. Valduriez. "The Leganet system: Freshness-Aware Transaction Routing in a Database Cluster," Information Systems, Vol.32, No.2, pp.320-343, 2005.
8 S. Elnikety, S. Dropsho, and W. Zwaenepoel, "Tashkent+: Memory-aware load balancing and update filtering in replicated databases," ACM SIGOPS Operating Systems Review, Vol.41, No.3, pp.399-412, 2007.   DOI
9 Django, "a high-level Python Web framework that encourages rapid development and clean, pragmatic design," https://www.djangoproject.com