Author(s)

Jia-song SUN ¹, Zhi-yong Liu ², Qiao SUN ², Xu-bin Pei ³, Shao-wei Zhang ², Lan-mei FU ²

Affiliation(s)

¹ E. E. Department, Tsinghua University, Beijing, China
² Beijing GuoDianTong Network Technology Co., Ltd., Beijing, China
³ 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.

Sponsors, Associates, and Links

---

• Power Systems Computation
  
  
• Internet of Things (IoT) and Engineering Applications
  
  
• Computing, Performance and Communication Systems
  
  
• Journal of Artificial Intelligence Practice
  
  
• Advances in Computer, Signals and Systems
  
  
• Journal of Network Computing and Applications
  
  
• Journal of Electrotechnology, Electrical Engineering and Management
  
  
• Journal of Wireless Sensors and Sensor Networks
  
  
• Journal of Image Processing Theory and Applications
  
  
• Mobile Computing and Networking
  
  
• Vehicle Power and Propulsion
  
  
• Frontiers in Computer Vision and Pattern Recognition
  
  
• Knowledge Discovery and Data Mining Letters
  
  
• Big Data Analysis and Cloud Computing
  
  
• Electrical Insulation and Dielectrics
  
  
• Crypto and Information Security
  
  
• Journal of Neural Information Processing
  
  
• Collaborative and Social Computing
  
  
• International Journal of Network and Communication Technology
  
  
• File and Storage Technologies
  
  
• Frontiers in Genetic and Evolutionary Computation
  
  
• Optical Network Design and Modeling
  
  
• Journal of Virtual Reality and Artificial Intelligence
  
  
• Natural Language Processing and Speech Recognition
  
  
• Journal of High-Voltage
  
  
• Programming Languages and Operating Systems
  
  
• Visual Communications and Image Processing
  
  
• Journal of Systems Analysis and Integration
  
  
• Knowledge Representation and Automated Reasoning
  
  
• Review of Information Display Techniques
  
  
• Data and Knowledge Engineering
  
  
• Journal of Database Systems
  
  
• Journal of Cluster and Grid Computing
  
  
• Cloud and Service-Oriented Computing
  
  
• Journal of Networking, Architecture and Storage
  
  
• Journal of Software Engineering and Metrics
  
  
• Visualization Techniques
  
  
• Journal of Parallel and Distributed Processing
  
  
• Journal of Modeling, Analysis and Simulation
  
  
• Journal of Privacy, Trust and Security
  
  
• Journal of Cognitive Informatics and Cognitive Computing
  
  
• Lecture Notes on Wireless Networks and Communications
  
  
• International Journal of Computer and Communications Security
  
  
• Journal of Multimedia Techniques
  
  
• Automation and Machine Learning
  
  
• Computational Linguistics Letters
  
  
• Journal of Computer Architecture and Design
  
  
• Journal of Ubiquitous and Future Networks