How your datasets are designed and managed are the foundation of an effective GIS solution. Peak Geospatial assists our clients with all steps of database design and development. We work with our clients to develop solutions that manage their internal processes while adhering to industry standards.
Database Design
Database design and developing the data model includes laying out a schema based on thematic layers, which are usually based on business needs and the required applications.
Conceptual Model
- Generate the design using a series of diagrams to represent the key design concepts
- Document the specifications of geodatabase elements, metadata, and map layers in each of the data model templates.
Physical Design Tasks
- Choose the right underlying DBMS structure (SQL, PostgreSQL, Oracle)
- Generate the physical schema
- Testing and validation
- Documentation
Database Administration
Database management and administration is really akin to data management and covers a variety of tasks, all of which Peak Geospatial is here to assist you with. These items can be set-up to run independently or as scheduled scripts that alleviate resourcing pressures.
- Workflows for managing, editing and versioning transactions that mitigate database bloating and improve performance
- Routine reconciliation and sync operations that keep the contents of the database up to date
- Managing security and permissions
PGS is also available to provide custom database administration training that relates specifically to your organizations single or multi-tier configuration.