Functionality of the system

The functions that will be supported by the MetPetDB database can be grouped into several main groups.

Data Upload

Data upload involves the upload of data into the system by one of two main means: bulk upload and single uploads.

Bulk upload involves the loading of data with the help of Excel spreadsheets with a specific format using key words as data tags. Users are expected to upload data in different groups such as samples, images and mineral analyses. Optionally, users can also upload specific information about subsamples. Each upload involves rigorous error checking to find possible misspellings, format errors, values out of bounds, etc. Similarly, the system will check for duplicate values and require clarifications when necessary. The error checking will help user fix or ignore the problems.

Single upload allows users to enter data for each sample, subsample, image or chemical analysis one by one.

Data Search, Browse and Use

The data search and browse functionality will allow users to formulate queries with various complexity and see the results of their searches. The users will be able to save their searches and revisit them. They will be able to specify whether they want to search within the public data, data they own or data specific to a project. Users will also be able to filter out specific comments and add new comments of their own. All changes made to the data in the system, public or private, will be stored using a data versioning system. Users will also be able to view changes to their private data, make changes or revoke changes to revert back to a previous version of their data.

The browse functionality will let users view the data in the system using various browsers, including a subsample map program that displays various images of a subsample and the chemical analyses in their specific spatial context. We will also implement a Google Earth functionality for viewing the available data on the Google Earth application.

MetPetDB Toolset

We will design MetPetDB so that data can be used with a range of analysis tools such as data plotting, mineral recalculations, and thermobarometry calculations. These tools will be available to all users and will greatly facilitate the manipulation of data in the future. We will encourage users to develop their own tools that can be used by other users of the database.

Project Management System

This functionality will allow users to create groups, assign their data objects to specific projects and invite users to their project. User of a project will be able to see and modify private samples in the project space even if they are not owned by that user. The users of the project will be able to view changes to the data in the project space since their last login.

Administrative and User Functions

The user functions involve the user registration and approval functions. The administrative functions involve the auditing of changes, changing of user access rights, especially blocking users from accessing data and removing public data under special circumstances.