Skip to main content

Advances, Systems and Applications

Table 3 The processing times (ms) of read/write operations (90/10 R/W ratio) for standard approaches (Classic, Quorum, TBC) and proposed advanced R-TBC/RTA approach for maintaining the consistency of the cloud DBMS

From: Advanced consistency management of highly-distributed transactional database in a hybrid cloud environment using novel R-TBC/RTA approach

   Classic approach Quorum approach TBC approach R-TBC/RTA approach
   Read Write Read Write Read Write Read Write
Primary Disc - 28 17 18 - 12 - 8
server /          
root CPU - 53 25 26 - 25 - 12
replica          
Secondary Disc 17 18 17 19 17 15 8 7
replica          
servers CPU 9 5 18 18 11 8 2 3
Average Primary - 8.1 28.8 4.4 - 3.7 - 2
operation replica:         
processing Avg 8.1 33.2 3.7 2
time(ms) (Disc+CPU)         
  Secondary 23.4 2.3 31.5 3.7 25.2 2.3 9.9 1
  servers:         
  Avg 25.7 35.2 27.5 10.9
  (Disc+CPU)