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)

       Â