469,621 Members | 1,678 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

Transaction Isolation Levels

cj
Hi.

I need a better understanding of transaction isolation levels. I can't seem
to visualize a scenario for each level. The serializable level is the only
one I really understand. I do not seem to grasp what a RepeatableRead is or
what a phantom row is. I think I need a more non-technical definition.
Does anyone know of any resource that would provide this? I have many books
and MSDN libraries but still am unclear.

Thanks,
cj
Apr 15 '06 #1
2 1847
Hello cj,

Try look there http://www.service-architecture.com/...isolation.html

c> I need a better understanding of transaction isolation levels. I
c> can't seem to visualize a scenario for each level. The serializable
c> level is the only one I really understand. I do not seem to grasp
c> what a RepeatableRead is or what a phantom row is. I think I need a
c> more non-technical definition. Does anyone know of any resource that
c> would provide this? I have many books and MSDN libraries but still
c> am unclear.
c>
c> Thanks,
c> cj
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
Apr 15 '06 #2
Hello cj,

And try here http://en.wikipedia.org/wiki/ACID

c> I need a better understanding of transaction isolation levels. I
c> can't seem to visualize a scenario for each level. The serializable
c> level is the only one I really understand. I do not seem to grasp
c> what a RepeatableRead is or what a phantom row is. I think I need a
c> more non-technical definition. Does anyone know of any resource that
c> would provide this? I have many books and MSDN libraries but still
c> am unclear.
c>
c> Thanks,
c> cj
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
Apr 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Florian G. Pflug | last post: by
3 posts views Thread by joshsackett | last post: by
2 posts views Thread by Christian Stooker | last post: by
1 post views Thread by Mark | last post: by
5 posts views Thread by dhek | last post: by
3 posts views Thread by ms | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.