Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Database Theory > implementing a ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 24 Topic 2493 of 2676
Post > Topic >>

implementing a database log

by Christoph Rupp <cruppstahl@[EMAIL PROTECTED] > Apr 21, 2008 at 12:44 PM

Hi,

i'm the author of a simple open-source database engine. i'm currently
adding recovery/logging, and i have some practical questions about the
implementation.

I have 3 options.

1. a physical log based on modified pages - whenever a page is
modified, a before/after image is stored in the log.
pro: easy to implement and to test
con: logfile will become huge!

2. a physical log based on modified bytes - whenever a database key or
record is modified, only the modified bytes in the file are logged.
pro: logfile is slim, very fine-grained control
con: tedious to implement, error prone, difficult to test

3. a logical logging - information about the high-level operation is
stored in the logfile. honestly, i don't know how i could implement
this, since one high-level operation is often splitted into several
physical operations, and if one of them fails i am not sure about the
consequences...

currently, i'm going with 2), but as i wrote above, it's hard to
implement and i'm not happy with the way i'm going.

what would you recommend?

thanks for your opinions,
chris
 




 24 Posts in Topic:
implementing a database log
Christoph Rupp <crupps  2008-04-21 12:44:52 
Re: implementing a database log
"Brian Selzer"   2008-04-21 17:00:03 
Re: implementing a database log
Christoph Rupp <crupps  2008-04-21 14:58:54 
Re: implementing a database log
"Brian Selzer"   2008-04-21 18:58:01 
Re: implementing a database log
paul c <toledobysea@[E  2008-04-21 23:56:25 
Re: implementing a database log
David BL <davidbl@[EMA  2008-04-21 23:53:42 
Re: implementing a database log
"Brian Selzer"   2008-04-22 11:39:17 
Re: implementing a database log
David BL <davidbl@[EMA  2008-04-22 00:04:25 
Re: implementing a database log
Christoph Rupp <crupps  2008-04-22 00:59:41 
Re: implementing a database log
Christoph Rupp <crupps  2008-04-22 01:12:09 
Re: implementing a database log
paul c <toledobysea@[E  2008-04-22 15:45:24 
Re: implementing a database log
Christoph Rupp <crupps  2008-04-22 08:57:12 
Re: implementing a database log
David BL <davidbl@[EMA  2008-04-22 22:54:26 
Re: implementing a database log
"Brian Selzer"   2008-04-24 10:11:11 
Re: implementing a database log
Christoph Rupp <crupps  2008-04-25 02:13:43 
Re: implementing a database log
"Brian Selzer"   2008-04-25 16:50:23 
Re: implementing a database log
David BL <davidbl@[EMA  2008-04-27 19:50:41 
Re: implementing a database log
"Brian Selzer"   2008-04-28 00:25:18 
Re: implementing a database log
David BL <davidbl@[EMA  2008-04-27 23:07:26 
Re: implementing a database log
"Brian Selzer"   2008-04-28 09:25:50 
Re: implementing a database log
David BL <davidbl@[EMA  2008-04-28 19:49:41 
Re: implementing a database log
Eric <eric@[EMAIL PROT  2008-04-29 10:08:41 
Re: implementing a database log
"Brian Selzer"   2008-04-29 12:31:39 
Re: implementing a database log
David BL <davidbl@[EMA  2008-04-29 03:15:20 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 6:04:20 CST 2008.