[DB-SIG] a simple question on rdbms and berkeley db

Chris Cogdon chris at cogdon.org
Mon May 5 14:29:18 EDT 2003

On Monday, May 5, 2003, at 13:14 US/Pacific, Marcos Sánchez Provencio 

> /Berkeley DB is not a relational system. Relational database systems 
> are semantically rich and offer high-level database access. Compared 
> to such systems, Berkeley DB is a high-performance, transactional 
> library for record storage. It's possible to build a relational system 
> on top of Berkeley DB. In fact, the popular MySQL relational system 
> uses Berkeley DB for transaction-protected table management, and takes 
> care of all the SQL parsing and execution. It uses Berkeley DB for the 
> storage level, and provides the semantics and access tools./

To avoid future confusion...

Berkeley DB is just ONE of the storage types MySQL can use. Others 
include ISAM, MyISAM and InnoDB, which are probably increasing in order 
of 'power'.  Ie, to enable certain MySQL features, you need to be using 
an appropriate backend storage type.

MyISAM is mostly what people use nowadays.

    ("`-/")_.-'"``-._        Chris Cogdon <chris at cogdon.org>
     . . `; -._    )-;-,_`)
    (v_,)'  _  )`-.\  ``-'
   _.- _..-_/ / ((.'
((,.-'   ((,/   fL

More information about the DB-SIG mailing list