| Before incorporating new mail from a UNIX folder, the PL/SQL procedure first finds out current maximum msg id in the corresponding DB folder and only try to parse/incorporate those MH mails with msg id greater than the maximum msg id in DB (fig. 13) |
| If the the MH folder contains subfolders, new mails in all subfolders will be considered to incorporate, and this is a recursive process. |
| Implemented by both a perl script (for parsing) and PL/SQL procedures |
| A time-intensive process as insertions may be occurred on up to four DB tables which are indexed. But this process can be done in batch ! |
| Incorporating can be done at the same time when other query options are requested by other clients on the web. The DB server will ensure the query concurrency and data consistency --- a reliable information system ! |