Education, Science, Technology, Innovation and Life
Open Access
Sign In

Distributed Database Integrated Transaction Processing Technology Research

Download as PDF

DOI: 10.23977/jwsa.2017.11003 | Downloads: 38 | Views: 6081

Author(s)

Jia-song SUN 1, Zhi-yong Liu 2, Qiao SUN 2, Xu-bin Pei 3, Shao-wei Zhang 2, Lan-mei FU 2

Affiliation(s)

1 E. E. Department, Tsinghua University, Beijing, China
2 Beijing GuoDianTong Network Technology Co., Ltd., Beijing, China
3 State Grid Zhejiang Electric Power Company, Hangzhou, China

Corresponding Author

Jia-song SUN

ABSTRACT

In this paper, we propose one comprehensive distributed database transaction method for InfiniBand transaction integrity in the distributed heterogeneous environment caused by data and application expansion. The method first integrates the functions of the standard online transaction engine and then uses the optimistic concurrency control technique to deal with the online memory allocation problem. On the one hand, it reduces the delay time of the online transaction and on the other hand, allocates the computing cost of the transaction to the server and the client. In the existing enterprise network environment using YCSB as a benchmark test shows that the different keys under the method of response speed are the fastest. The result shows that this kind of hybrid processing scheme can make full use of the advantages of remote direct memory access and fast network, which can further improve the consistency and reliability of the distributed database system.

KEYWORDS

Distributed Database, Integrated Transaction Processing, Comprehensive Distributed Database Management, Optimistic concurrency control.

CITE THIS PAPER

Zhi-yong, L. , Qiao, S. , Shao-wei, Z. , Xu-bin, P. , Lan-mei, F. , Jia-song, S. (2017) Distributed Database Integrated Transaction Processing Technology Research. Journal of Web Systems and Applications (2017) 1: 15-19.

REFERENCES

[1] Research on the Synchronization Technology of Distributed Database System[D]. Master's thesis, Changchun University of Science and Technology, Apr. 2008.
[2] Database transaction on https://en.wikipedia.org/wiki/Database_transaction
[3] Lu X, Su F, Liu H, et al. A unified OLAP/OLTP big data processing framework in telecom industry[C]. Communications and Information Technologies (ISCIT), 2016 16th International Symposium on. IEEE, 2016: 290-295. 
[4] NAGASURENDRAN P. A Novel Perspective of Data Warehousing and Data Mining in Education[J]. Global Journal for Research Analysis, 2017, 5(9).
[5] Sur S, Koop M J, Chai L, et al. Performance analysis and evaluation of Mellanox ConnectX InfiniBand architecture with multi-core platforms[C].15th Annual IEEE Symposium on High-Performance Interconnects (HOTI 2007). IEEE, 2007: 125-134.
[6] Shanley T, Winkles J. InfiniBand Network Architecture[M]. Addison-Wesley Professional, 2003.
[7] InfiniBand Trade Association. InfiniBand Architecture Specification: Release 1.0[M]. InfiniBand Trade Association, 2000.
[8] Liu J, Wu J, Panda D K. High performance RDMA-based MPI implementation over InfiniBand[J]. International Journal of Parallel Programming, 2004, 32(3): 167-198.
[9] Islam N S, Rahman M W, Jose J, et al. High performance RDMA-based design of HDFS over InfiniBand[C]. Proceedings of the International Conference on High Performance Computing, Networking, Storage and Analysis. IEEE Computer Society Press, 2012: 35.
[10] Plattner H. A common database approach for OLTP and OLAP using an in-memory column database[C].  Proceedings of the 2009 ACM SIGMOD International Conference on Management of data. ACM, 2009: 1-2.
[11] Vieira M, Madeira H. A dependability benchmark for OLTP application environments[C]. Proceedings of the 29th international conference on Very large data bases. Volume 29. VLDB Endowment, 2003: 742-753.

Downloads: 837
Visits: 46913

Sponsors, Associates, and Links


All published work is licensed under a Creative Commons Attribution 4.0 International License.

Copyright © 2016 - 2031 Clausius Scientific Press Inc. All Rights Reserved.