News for hackers. Stuff that matters.
Re:A Critique of ANSI SQL Isolation Levels (1995) [pdf] by DenisM on Friday June 19, 2020 @02:24PM (#23577403)
Also, to your point, I believe it is possible to strengthen Snapshot Isolation to the point where it is strictly stronger than Repeatable Read. There was a paper at VLDB circa 2007, I belie it was done by a researcher from Oracle. Can't recall any details, other than the guy was pretty young and well-spoken.
Re:A Critique of ANSI SQL Isolation Levels (1995) [pdf] by petergeoghegan on Friday June 19, 2020 @02:36PM (#23577521)
I believe that you're thinking of Michael J. Cahill:

https://courses.cs.washington.edu/courses/cse444/08au/544M/R...

This became the basis of PostgreSQL's serializable snapshot isolation feature:

https://drkp.net/papers/ssi-vldb12.pdf

Re:A Critique of ANSI SQL Isolation Levels (1995) [pdf] by DenisM on Friday June 19, 2020 @02:59PM (#23577766)
Quite possible. In the years since my brain has completely unloaded transaction processing to make room for supply chain management, so I can no longer relate to the subject to see if it's the same research. :(

I recall I approached him in the break and congratulated him on the fantastic presentation. And it was fantastic - like a murder mystery story, it kept you on the edge of the seat, answering questions it has created earlier and culminating into the answer. An older guy, probably his science advisor, protested that it's not only the presentation that was good, and the research itself was not too shabby. To that I retorted that for all we know there was a lot of good research in the room but we will never find out because delivery was lacking. Research must beget research, it's what makes science from hobby. I think we reached an agreement. I often think back to that moment - what we build should lend itself to further building, or it becomes a dead end. Neither science nor technology are made from dead-ends, the proverbial shoulders of giants must stack up for the civilization to advance.

Re:A Critique of ANSI SQL Isolation Levels (1995) [pdf] by petergeoghegan on Friday June 19, 2020 @03:11PM (#23577875)
Here is the thesis itself:

https://ses.library.usyd.edu.au/bitstream/handle/2123/5353/m...

I do remember thinking that it was unusually well argued and presented. It's much more accessible to the practitioner than a lot of the other research in this area. In my experience this is a positive signal about the quality of the research.

Re:A Critique of ANSI SQL Isolation Levels (1995) [pdf] by DenisM on Friday June 19, 2020 @04:45PM (#23578704)
That's gotta be him. I just read the abstract, it's mountain-creek-clear.
Re:A Critique of ANSI SQL Isolation Levels (1995) [pdf] by mjb on Friday June 19, 2020 @02:53PM (#23577706)
One funny thing about that VLDB'12 paper is Kevin Grittner's affiliation. Not often you see a state supreme court publishing cutting-edge database research. I'd love to hear the story around that.
Re:A Critique of ANSI SQL Isolation Levels (1995) [pdf] by petergeoghegan on Friday June 19, 2020 @02:56PM (#23577743)
I used to work with Kevin, back when I was with VMware. I can confirm that it's an interesting story!