The default table type for MySQL is MyISAM.

It has table level locking, which means during an UPDATE, nobody can access any other record of the same table.

BDB

uses Page level locking,

and during an UPDATE, nobody can access any other record residing in the same database page of that table, until the locking transaction issues a COMMIT.

InnoDB

However, uses Row level locking.

Row level locking ensures that during an UPDATE, nobody can access that particular row, until the locking transaction issues a COMMIT.

Automatically generating database applications

I followed the below link..

This is atleast a starting point to the noob..

http://livedocs.adobe.com/flex/3/html/help.html?content=data_3.html