Skip to main content

Advances, Systems and Applications

Table 2 The processing times (ms) of read/write operations (70/30 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

-

31

16

17

-

16

-

11

server /

         

root

CPU

-

55

23

25

-

30

-

16

replica

         

Secondary

Disc

15

21

16

17

18

19

9.3

9.6

replica

         

servers

CPU

7

8

16

18

12

11

4

6.1

Average

Primary

-

25.8

27.3

12.6

-

13.8

-

8.1

operation

replica:

        

processing

Avg

25.8

39.9

13.8

8.1

time(ms)

(Disc+CPU)

        
 

Secondary

15.4

8.7

22.4

10.5

21

9

9.3

4.7

 

servers:

        
 

Avg

24.1

32.9

30

14

 

(Disc+CPU)

       Â