ACID encountering the CAP theorem: Two bank case studies

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

3 Scopus citations

Abstract

In the era of big data, we may adopt the distributed architecture for a transaction processing system due to some reasons, including distributed branches, heavy demand and operational expenditure, etc. In terms of the CAP Theorem, a transaction processing system associated with ACID properties is infeasible to work well in the distributed architecture. It is indispensable to address how to make a trade-off between availability and partition tolerance for a bank as it favors the consistency in the distributed system. In this research, we conduct two case studies to address the question using two transaction logs collected from a bank in China. We mainly analyze the table dependency and the table concurrency, and find that (1) it is arduous to partition the data in the database system associated with ACID properties, (2) in-memory architecture for updating transactions may be an alternative for building a transaction processing system.

Original languageEnglish
Title of host publicationProceedings - 2015 12th Web Information System and Application Conference, WISA 2015
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages235-240
Number of pages6
ISBN (Electronic)9781467393720
DOIs
StatePublished - 1 Feb 2016
Event12th Web Information System and Application Conference, WISA 2015 - Jinan, Shangdong, China
Duration: 12 Sep 201513 Sep 2015

Publication series

NameProceedings - 2015 12th Web Information System and Application Conference, WISA 2015

Conference

Conference12th Web Information System and Application Conference, WISA 2015
Country/TerritoryChina
CityJinan, Shangdong
Period12/09/1513/09/15

Keywords

  • ACID
  • CAP
  • Distributed Database
  • In-memory Database

Fingerprint

Dive into the research topics of 'ACID encountering the CAP theorem: Two bank case studies'. Together they form a unique fingerprint.

Cite this