GeoTP: Latency-aware Geo-Distributed Transaction Processing in Database Middlewares (Extended Version)

সংরক্ষণ করুন:
গ্রন্থ-পঞ্জীর বিবরন
প্রকাশিত:arXiv.org (Dec 5, 2024), p. n/a
প্রধান লেখক: Zhuang, Qiyu
অন্যান্য লেখক: Shi, Xinyue, Liu, Shuang, Lu, Wei, Zhao, Zhanhao, Chen, Yuxing, Li, Tong, Pan, Anqun, Du, Xiaoyong
প্রকাশিত:
Cornell University Library, arXiv.org
বিষয়গুলি:
অনলাইন ব্যবহার করুন:Citation/Abstract
Full text outside of ProQuest
ট্যাগগুলো: ট্যাগ যুক্ত করুন
কোনো ট্যাগ নেই, প্রথমজন হিসাবে ট্যাগ করুন!

MARC

LEADER 00000nab a2200000uu 4500
001 3138985300
003 UK-CbPIL
022 |a 2331-8422 
035 |a 3138985300 
045 0 |b d20241205 
100 1 |a Zhuang, Qiyu 
245 1 |a GeoTP: Latency-aware Geo-Distributed Transaction Processing in Database Middlewares (Extended Version) 
260 |b Cornell University Library, arXiv.org  |c Dec 5, 2024 
513 |a Working Paper 
520 3 |a The widespread adoption of database middleware for supporting distributed transaction processing is prevalent in numerous applications, with heterogeneous data sources deployed across national and international boundaries. However, transaction processing performance significantly drops due to the high network latency between the middleware and data sources and the long lock contention span, where transactions may be blocked while waiting for the locks held by concurrent transactions. In this paper, we propose GeoTP, a latency-aware geo-distributed transaction processing approach in database middlewares. GeoTP incorporates three key techniques to enhance geo-distributed transaction performance. First, we propose a decentralized prepare mechanism, which diminishes the requirement of network round trips for distributed transactions. Second, we design a latency-aware scheduler to minimize the lock contention span by strategically postponing the lock acquisition time point. Third, heuristic optimizations are proposed for the scheduler to reduce the lock contention span further. We implemented GeoTP on Apache Shardingsphere, a state-of-the-art middleware, and extended it into Apache ScalarDB. Experimental results on YCSB and TPC-C demonstrate that GeoTP achieves up to 17.7x performance improvement over Shardingsphere. 
653 |a Transaction processing 
653 |a Middleware 
653 |a Databases 
653 |a Data sources 
653 |a Network latency 
700 1 |a Shi, Xinyue 
700 1 |a Liu, Shuang 
700 1 |a Lu, Wei 
700 1 |a Zhao, Zhanhao 
700 1 |a Chen, Yuxing 
700 1 |a Li, Tong 
700 1 |a Pan, Anqun 
700 1 |a Du, Xiaoyong 
773 0 |t arXiv.org  |g (Dec 5, 2024), p. n/a 
786 0 |d ProQuest  |t Engineering Database 
856 4 1 |3 Citation/Abstract  |u https://www.proquest.com/docview/3138985300/abstract/embedded/6A8EOT78XXH2IG52?source=fedsrch 
856 4 0 |3 Full text outside of ProQuest  |u http://arxiv.org/abs/2412.01213