Implementing ACID

views:

231

answers:

+2 Q:

Implementing ACID

I am starting research on a project that will need to provide ACID semantics on its database.

Due to the nature of the data it is not suitable for storage in common off-the-shelf systems (relational or key-value).

What are some good resources on how to implement systems which must provide ACID semantics?

My typical Google search returns more information about system which already provide ACID semantics rather than how to go about implementing such systems.

+1 A:

ARIES is a popular algorithm for implementing an ACID database (e.g. SQL Server uses this algorithm).

Justice 2009-01-23 19:13:25

Care to summarize here?

Andrew Rollings 2009-01-23 19:28:14

I will definitely take a look at these resources. This seems like a good starting point. -- Thanks

2009-01-24 03:10:54

+1 A:

Timothy Leary - How to Operate Your Brain

http://www.youtube.com/watch?v=SQq_XmhBTgg

Gordon Bell 2009-01-23 19:17:13

+1: Best answer I've seen in a long while. Kudos.

Cody Brocious 2009-01-23 19:21:25

Not exactly helpful though :) (Unless the ensuing mind expansion allowed you to solve the problem).

Andrew Rollings 2009-01-23 19:27:18

Vision quest coding should probably be reserved for compiler/OS development and reverse-engineering. I can't imagine that working out well for databases.

Cody Brocious 2009-01-23 19:28:55

Wasn't Oracle developed primarily under the influence of mind-altering drugs?

rmeador 2009-01-23 19:40:41

If you know German, I'd recommend

Alfons Kemperer: Datenbanksysteme - Eine Einführung, ISBN 3486576909

"Einführung", which means "introduction", is a gross understatment. The book has several chapters on how you would physically lay out the data, WAL (write ahead logging), serializable vs. non-serializable histories, restart after failures, and much more.

I doubt, though, that you really want to write something like that. Do I need to remind you that in theory you can model any data-structure on top of the relational model?

edgar.holleis 2009-01-23 20:55:37

Interesting. I certainly would like it if I could read German right about now.Sure it is nice that you can model anything on a relational database, but what if you have a very specific dataset in mind, what if it has a very specific read pattern? The flexibility of a relational database is wasted.

2009-01-24 03:09:55

Better to waste the flexibility of a relational database than 6 months of your life...

Eloff 2010-01-14 18:00:18

ansaurus

tags:

views:

answers:

Implementing ACID

related questions