Montage of Transport Archive images. Follow this link to skip navigation.
Link to the canal archive Link to the rail archive Link to the aviation archive

Transport Archive: About the Project

Link to home page
Link to canals section
Link to railways section
Link to aviation section
Link to learning zone
Link to about this site
Link to send feedback
Navigation ends

What kind of databases were created to collect the data?

Over the whole project, two different database applications are used. The first is a database system built in FileMaker Pro and used by the curators in assembling information about the images and objects.

The system uses a barcode tag and reader to link each object to its description in the database and to name the digitised images, so reducing the chance of incorrect linkages.

Data from the intermediate database system is transferred to the second database system, written in MySQL running under Macintosh OS X. The interaction between the browser and the MySQL database is handled by PHP.

The decision to use a database-backed website was taken on the grounds of efficiency, consistency and ease of maintenance: for example, whilst there will be several thousand records, the number of html files will be numbered in the tens.

When new records are added after the end of the project the use of a simple content-management system will ensure consistency of output.

Next FAQ: What kind of code was used to create the pages?
View the complete list of FAQs