@article{(Open Science Index):https://publications.waset.org/pdf/9998636,
	  title     = {Ensuring Consistency under the Snapshot Isolation},
	  author    = {Carlos Roberto Valˆencio and  F´abio Renato de Almeida and  Thatiane Kawabata and  Leandro Alves Neves and  Julio Cesar Momente and  Mario Luiz Tronco and  Angelo Cesar Colombini},
	  country	= {},
	  institution	= {},
	  abstract     = {By running transactions under the SNAPSHOT isolation
we can achieve a good level of concurrency, specially in databases
with high-intensive read workloads. However, SNAPSHOT is not
immune to all the problems that arise from competing transactions
and therefore no serialization warranty exists. We propose in this
paper a technique to obtain data consistency with SNAPSHOT by using
some special triggers that we named DAEMON TRIGGERS. Besides
keeping the benefits of the SNAPSHOT isolation, the technique is
specially useful for those database systems that do not have an
isolation level that ensures serializability, like Firebird and Oracle. We
describe all the anomalies that might arise when using the SNAPSHOT
isolation and show how to preclude them with DAEMON TRIGGERS.
Based on the methodology presented here, it is also proposed the
creation of a new isolation level: DAEMON SNAPSHOT.
},
	    journal   = {International Journal of Computer and Information Engineering},
	  volume    = {8},
	  number    = {7},
	  year      = {2014},
	  pages     = {1096 - 1102},
	  ee        = {https://publications.waset.org/pdf/9998636},
	  url   	= {https://publications.waset.org/vol/91},
	  bibsource = {https://publications.waset.org/},
	  issn  	= {eISSN: 1307-6892},
	  publisher = {World Academy of Science, Engineering and Technology},
	  index 	= {Open Science Index 91, 2014},
	}