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

[Michael Nemtsev]

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

[Michael Nemtsev]

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