One of the first tasks when setting up a centralized environmental database management system is to define the data model. This involves deciding what data will be stored in the database and then creating the appropriate tables and fields using database management software. Hydro GeoAnalyst helps you kickstart this process by providing database templates designed specifically for different types of environmental data. Since every project is unique, Hydro GeoAnalyst’s Template Manager gives you complete control over your data model, allowing you to fully customize the template to suit your project needs. This flexibility is essential especially in situations where the database must connect to other third-party applications (GIS software) that have specific data structure requirements.
The upcoming release of Hydro GeoAnalyst 2014.1 will include various enhancements to the Template Manager which will make database design and management much easier and more flexible. Here’s a quick preview of what’s to come.
Unlimited data categories
When it comes to data management, organization is important – especially when working with large and complex data models. Grouping tables into categories lets you quickly locate a table and make necessary changes efficiently. The new Template Manager supports unlimited data categories for grouping and organizing your database tables.
Tables can be organized and grouped into user defined categories
Icons are now displayed within the data model tree view to help you understand, at a glance, what you are looking at. Primary keys are indicated by a key symbol so relationships with other tables are clear and easily understood.
New icons allow you to instantly identify primary key fields
Create tables with ease
The new Template Manager streamlines the table creation process by letting you define everything at once. Specify a table name, its related category and then add the desired fields – all within a single window.
Create a new table and related fields in a single window
Support for non-station tables
Where previously all information needed to be associated to a station, now data can be stored in its own table and not related to a station at all. Examples include: facility information, permit data, employee data and water quality standards.
The new Template Manager will be available in the upcoming release of Hydro GeoAnalyst 2014.1.