Database design & management
From the data model to daily operation. We design the structure first, enforce the rules at the point of entry, and run the system afterwards if you would rather not staff it internally.
- Relational and spatial data models
- Enterprise geodatabases in PostgreSQL/PostGIS and SQL Server
- Migration and consolidation of legacy and historical datasets
- Validation rules, integrity constraints and QA/QC reporting
- Scheduled loading, backup and administration
- Exploration and geological databases, including DataShed