The Integrated Waterbird Database

Brief: To generate a standard database from two large databases resulting from coordinated monitoring of waterbirds in the UK. The client required a set of management utilities to enable the maintenance of core aspects of the resulting database.
Solution: We provided major data cleaning and dimension modeling services to create a database in MS-SQL of over 10 million records in the NBN data format (with extensions). We provided a custom application that enables the comprehensive management and viewing of the data in one interface. Data import and validation utilities are also provided to enable import of new data to the database.

Tags: Database Development, Delphi, SQL Server