A Model Web-enable for OLTP with Replication Realtime Distributed Database

Main Article Content

klaokanlaya silachan
Pitiphol Pholpabu
Mongkol Rodjun

Abstract




This research investigates the problem of distributed and update distributed database to be updated across all the site. Generally, a transaction database system distributes replication data with DBMS settings. The DBMS distributes the data to sites according to the distribution time settings. As a result, the data needs to be updated across all the sites. The larger the data set is, the bigger time consumption will take. Furthermore, the system becomes inconsistent and the data state maintenance becomes complicated. In this paper, a new model is presented to provide real-time distributed and update distributed replication to be updated across somesite and all sites by web code generation. The transaction database system can distribute data without DBMS. The study is conducted based on web- enable development for online shopping of the online transaction processing (OLTP), at the same time, distributed to other sites instantly. It results in keeping the information current and consistent when it is updated. The performance evaluation is based on the distributed and update efficiency which compared distribution response time of transaction connection access type on Linked server, remote access and direct access. The result shows that the module with linked server performs better than the other two.




Downloads

Download data is not yet available.

Article Details

How to Cite
silachan, klaokanlaya, Pholpabu, P., & Rodjun, M. (2020). A Model Web-enable for OLTP with Replication Realtime Distributed Database. SNRU Journal of Science and Technology, 12(3), 222-230. Retrieved from https://ph01.tci-thaijo.org/index.php/snru_journal/article/view/234583
Section
Research Article

References

[1] U.H.Waqar. Transaction processing in real-time database systems ,Ph.D. Computer Science,
Iowa State University, Iowa, 1993.
[2] C. UlusoY. Processing Real-Time Transactions in a Replicated Database System.
Distributed and Parallel Databases.2 (1994) 405-436.
[3] J. Singh,Y.S. Singh, A. Gaikwad and Mehrotra. Dynamic management of transactions in
distributed real-time processing system. International Journal of Database Management
Systems(IJDMS). 2 (2) (2010) 161-170.
[4] S. Gupta, K. Saroha, Bhawna. Fundamental Research of Distributed Database. International
Journal of Computer Science and Management Studies. 11 (2011) 161-170.
[5] A. A.Che Fauzi, A. Noraziah, W.M. Binti Wan Mohd, A. Amer, T.Herawan. Managing
Fragmented Database Replication for Mygrants Using Binary Vote Assignment on Cloud
Quorum. Applied Mechanics and Materials. 490-491. (2014) 1342-1346.
[6] F. A.Abdalhalim. A Survey on Transactions Management in Distributed Real Time
Database Systems. International Journal of Advanced Computer Technology (IJACT).
4 (6) (2015) 100-104.
[7] Md. S. Rana, M. K. Sohel, and Md. S. Arman. Distributed Database Problems, Approaches and
Solutions -A Study. International Journal of Machine Learning and Computing.8 (5) (2018)
472 - 476.
[8] R. Salem,S. Saleh ,and H. Abdul-Kader. Intelligent Replication for Distributed Active Real
Time Databases Systems. The International Arab Journal of Information Technology, 15
(2018) 505-513.
[9] K. K.Ezechiel, S. Kant, R. Agarwal. A Systematic Review on Distributed Databases Systems and
Their Techniques. Journal of Theoretical and Applied Information Technology. 96 (2019) 236-
266.
[10] S. R. Choudhary, C.K. Jha. A Study on Transaction Processing for Real Time Database System
in Distributed Environment. International Journal of Computer Science and Information
Technologies. 4 (5) (2013) 721-724.