Skip to main content

Advances, Systems and Applications

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

-

36

18

19

-

19

-

13

server /

         

root

CPU

-

62

25

27

-

33

-

19

replica

         

Secondary

Disc

14

28

18

19

17

22

7.2

13

replica

         

servers

CPU

6

13

19

20

11

14

2

10

Average

Primary

-

49

21.5

23

-

26

-

16

operation

replica:

        

processing

Avg

49

44.5

26

16

time(ms)

(Disc+CPU)

        
 

Secondary

10

20.5

31.5

3.7

14

18

4.6

11.5

 

servers:

        
 

Avg

30.5

35.2

32

16.1

 

(Disc+CPU)

       Â