Database Transaction Routing Algorithm Using AOP

KIPS Transactions on Software and Data Engineering, Vol. 3, No. 11, pp. 471-478, Nov. 2014
10.3745/KTSDE.2014.3.11.471, Full Text:


Database replication is utilized to increase credibility, availability and prevent overload of distributed databases. Two modelscurrently exist for replication - Master/Slave and Multi-Master. Since the Multi-Master model has problems of increasing complexityand costs to interface among multiple databases for updates and inserts, the Master/Slave model is more appropriate when frequentdata inserts and updates are required. However, Master/Slave model also has a problem of not having exact criteria when systemschoose 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 concernsbased on AOP, modularizes each concern, and routes transactions among Master and Slave databases. This paper evaluates stabilityand performance of the suggested algorithm through integration tests based on scenarios.

Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.

Cite this article
[IEEE Style]
K. H. Sik, S. H. Lee and D. K. Baik, "Database Transaction Routing Algorithm Using AOP," KIPS Transactions on Software and Data Engineering, vol. 3, no. 11, pp. 471-478, 2014. DOI: 10.3745/KTSDE.2014.3.11.471.

[ACM Style]
Kang Hyun Sik, Suk Hoon Lee, and Doo Kwon Baik. 2014. Database Transaction Routing Algorithm Using AOP. KIPS Transactions on Software and Data Engineering, 3, 11, (2014), 471-478. DOI: 10.3745/KTSDE.2014.3.11.471.