Title
Performance evaluation of snapshot isolation in distributed database system under failure-prone environment
Abstract
Database systems are widely used in many fields. As the scale of database systems increases, more firms decide to deploy the database system in a distributed environment for the sake of data integrity fault tolerance. For guaranteeing the consistency of data, database management systems adopt isolation policies. This paper discusses probabilistic models for snapshot isolation of database management system. Snapshot isolation is an effective method to enhance the consistency of database system, although it degrades the system performance where the system has large network latency such as distributed database system. Also, under the failure-prone environment, a restart scheme is considered as one countermeasure. This paper proposes probabilistic models for the dynamics of snapshot isolation of database system and exhibits the optimization of system performance with respect to updating interval of snapshot isolation within the failure-prone environment from the analytical point of view. Numerical experiments are conducted to validate the effectiveness of analytical results by using real traffic data.
Year
DOI
Venue
2014
10.1007/s11227-014-1162-5
The Journal of Supercomputing
Keywords
Field
DocType
Database system,Snapshot isolation,Prefix-consistent snapshot isolation,Communication failure,Probabilistic analysis,Optimization
Snapshot isolation,Database tuning,Computer science,Database design,Database testing,Data integrity,Database theory,Distributed database,Database transaction,Distributed computing
Journal
Volume
Issue
ISSN
70
3
0920-8542
Citations 
PageRank 
References 
0
0.34
11
Authors
3
Name
Order
Citations
PageRank
Chao Luo15817.22
Hiroyuki Okamura214524.45
Tadashi Dohi3970109.25