Food Vulnerability Model (FVM) Project

Client: Ministry of Agriculture

Period: March 1999 – March 2000

Role: Analysis and Programming

This project implemented a new version of the Food Vulnerability Model (FVM) used by the Emergencies division of MAFF. It stores agricultural, food and dairy information collected from various external data sources. Using ArcView 3.1 GIS (Geographical Information System) and GQL 4.2 users are able to interrogate the database to assess the impact of emergencies (such as nuclear war) on national food stocks. It was written using CA-OPENINGRES ABF/4GL, SQL, C and Report Writer under CA-OPENINGRES V2.0 on a Sun SPARC server running SOLARIS 2.6.

Ambica:

• Was engaged to write and test programs written in Embedded SQL and C that loaded information from data files into the database.
• Implemented enhancements to the ABF application used to maintain the database.
• Was responsible as well for ensuring that the various software components of FVM were properly developed and integrated.
• Installed software on the live server and PCs, including the CA-INGRES ODBC driver Version 2.8.
• Following user acceptance testing:
  • Fixed problems found with the software.
  • Updated documentation.
  • Carried out millennium testing.
  • Wrote a disaster recovery strategy and plan.
• Time was also spent co-ordinating project activities with the users and the third party supplier of the GIS.

Home Previous Next