My point was how you solve serialisable with adequate performance in principle independent of platform, I am well aware of the drawbacks in current methods.

My other point is that concurrency...

Hi Rick,

The MVCC thing is fairly incidental to the book which is great because it is such a clear exposition of the math behind the relational model.

@rick-1071254

The problem with MVCC is that you only see the data as it was at the beginning of the transaction. If performing updates, other data which are relevant...

• This reply was modified 3 weeks, 1 day ago by  will 58232.

@paul-2 White

Excellent post Paul. Snapshot isolation is useful for a consistent (but not up to date) result without locking. RSCI is logically equivalent to MVCC which has the...

With NOLOCK the data returned can be inconsistent with itself!

This is not acceptable.

The correct solution to this problem is snapshot isolation - no locking and a consistent result as of...

When do we get PostgresQUEL?

although upon hindsight it's obvious that a Roomba will encounter dog poop (my wife suggested dog vomit too) or cat poop, I'd never thought of it.

This may be an example...

The technology behind robot vacuum cleaners and lawnmowers owes much to the work of MIT professor (and founder of the company Robust.AI) Rodney Brooks.

Brooks' blog offers a very well informed...

Sometimes as technical people we forget all the other pressures our managers are under - personell issues, purchasing, licensing, vendor management, dealing with departmental managers and higher management. It is...

• This reply was modified 3 years, 3 months ago by  will 58232.

It is only a matter of time until every byte of every disk in the whole world is completely full of pictures of cute cats.

A vehicle is subject to inspection by the relevant safety authorities before it goes on the market. As the "autopilot" is a new thing I expect that the necessary legislation...

The way to make computer systems accountable is by designing them using logic rather than "AI" or ML.

Consider the steps taken my law makers in drawing up legislation. Although legal...

I think the concerns over SOA with regard to changing structure are things like changing tables. However, I tend to agree with Will that we can make these changes without...

Regardless of whether it's a web application, mobile app, or internal BI reporting system - don't let the front-end application interface with the database directly. Don't even let them have...

There is a great deal of misunderstanding about relational DBMSs and you will find a lot of this misunderstanding out there on the internet.

For example, people talk about a  "relational...