|
|
 |
|
|
|
Dealing with large volumes of data generated on legacy platforms can be a real challenge. Interfacing
modern database driven applications with text or binary-based files can require a forensic approach,
and the use of special tools to examine files on a byte-by-byte basis.
Project overview:
CEH are the lead partner in a European funded project to study certain hydrological problems in a
number of Mediterranean islands. A model, (called DiCaSM) had been developed by CEH over a number
of years, to model the behaviour of fresh water in soil layers of a region. This model used an
Access database to store its data. Another model, developed by the US Geological Service, (called
Modflow) allows the modelling of water in the geological layers deeper below the surface. This model
used and produced data in text and binary files, using a variety of Fortran formats.
The challenge was to link the output data produced by DiCaSM into a Modflow model for the same physical
area.
| Centre for Ecology & Hydrology |
|
|
|
|
|
|
|
|
|
Software development brief
This was a complex project, involving many aspects of development. The basic
technologies used were Visual Basic 6 and ActiveX Data Objects (ADO 2.7), but other
third party controls were also used to generate complex graphical outputs in a number of
formats. Additional graphical components were also designed explicitly for the project,
where third party controls did not provide the required functionality.
|
|
|
|
|
|
There were extensive requirements for file I/O in the project, and special modules
were required to perform data transformations to and from the databases, text and
binary files. Additional files were required to allow data entry from other packages.
|
|
|
|
|
|
Core Skills:
- Microsoft Visual Basic 6
- Microsoft Access and ADO 2.7
- Mathematical Modelling
- Data Transformation
- Graphical Tool Development
|
|
|
|
|
|
|
|
|
|