Patent ID: 6266669
Filing Date: 2001-07-24
Classification: G06F,Y10S

Abstract:
A method of collecting, storing, and retrieving data in a multi-tier database management system having a master database server (4), an application server (303), at least one workgroup server (315), and a plurality of workgroup user clients (310), said application server (303) and said workgroup server (315) interposed between said master database server (4) and said workgroup user clients (310), said method comprising:(a) creating a transaction in a local database resident on one of said workgroup user clients (310),(b) entering the transaction into a transaction log resident on said workgroup user client (310),(c) creating a transaction file corresponding thereto in an outbox of said workgroup user client (310);(d) copying said transaction file to an inbox on said workgroup server (315) identified to the workgroup user client (310),(e) updating said transaction file into a workgroup database (305) resident on said workgroup server (315), said workgroup database (305) including a transaction log;(f) reading said workgroup database (305) transaction log while skipping those transactions which originate at the master database server (4),(g) creating data files corresponding to the entries therein,(h) copying data files corresponding to transactions originating at the workgroup user client (310) to an inbox on the master database server (4) corresponding to the workgroup server (315), and(i) updating the transactions into a master database (3) on the master database server (4).