A method of and system for collecting, storing, and retrieving data in a
data base management system. The database management system includes a
master database server (4), at least one workgroup server (315), and a
plurality of workgroup user clients (310). The workgroup server (315) is
interposed between the master database server (4) and said workgroup user
clients (310). The method creating a transaction in a local database
resident on one of the workgroup user clients (310), entering the
transaction into a transaction log resident on the workgroup user client
(310), and creating a transaction file corresponding to the transaction
in an outbox of said workgroup user client (310). Next, the transaction
file is copied to an inbox identified to the workgroup user client (310)
and updating the transaction file into a workgroup database (305)
resident on the workgroup server (315). The workgroup database (305)
includes a transaction log.