How to make sure I don't write a corrupt page to db when I checkpoint?

Hi all!

I'm looking into designing an in-memory DB. Before I start, there are several things I must have figured out. Among those things is a technique to use to make sure that I don't write a corrupt page to db when I checkpoint. How do I make sure stray pointers in the application using my db (which will load into application process memory) does not damage my page(s) from the time of latest checkpoint and next checkpoint? And if it does, I don't want to flush it to disk, how do I detect a page corruption to avoid this?

1)
Am I simply being paranoid?

2)
Should I, for every update, calculate the checksum of the changed record? Records can be large and this sounds like a pain in the back, performance-wise.

Any other, better ways out there, to achieve what I want?

The checksum does not have to be idiot proof, that is, the checksum does not have to be unique for the bit pattern of the page, unless there is a cheap way of achieving this of course, but I don't think there is...

BRs
/Sune Received on Sun Jul 01 2007 - 03:15:24 CDT