Enhance and modify the C-Base contractors database with new requirements, fix bugs, and improve system performance
Enhance and modify the C-Base contractors database with new requirements, fix bugs, and improve system performance.
IBM is a hardware and software manufacturer for mainframe, mid-range and personal computer systems.
The existing system is LAN-based which causes a very slow performance for all system functionality.
Essentially a data entry system with reporting, both IBM GSA and Telstra data is stored in several attached databases.
Because of the system performance issue, I decided that the MS Access replication method of retrieving data would be the best course of action. This means that a central system resides on the network (the Design Master) and copies of the system (Replicas) are distributed onto local PC workstations. The Master and Replicas are synchronised via functionality built into the system, with only the Master able to be modified (and then re-distributed). This is a practical approach as MS Access’ performance, being a file-server, is improved when accessing data on the local PC.
The system has been overhauled to date with over 300 modifications to screens, tables, and reports, with a major re-design in the use of the user interface.
New functionality includes data archiving and a new interface for inquiry and ‘generic’ reporting.
An issue of non-standard PC configuration was being addressed by IBM at the time when I departed for Singapore, as this was causing problems with the replication synchronisation of local and central databases. This is an issue solely with IBM and was being handled by my support replacement.