| Database Design |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | BDB
Tables |
||||||||||||||
| – | Transactional |
||||||||||||||
| – | Automatic
recovery |
||||||||||||||
| – | Tables
grow as needed |
||||||||||||||
| – | Page-level
locking (8KB page) |
||||||||||||||
| • | Single
READ-COMMITTED isolation level |
||||||||||||||
| – | Uses
Berkeley DB under the hood |
||||||||||||||
| – | Few
users actually use BDB |
||||||||||||||
| – | Works
well for small - medium transaction rate |
||||||||||||||
| – | Locking
on the last page can be a problem |
||||||||||||||
| Copyright
2002, Jeremy Zawodny (Jeremy@Zawodny.com) |