Database support

The Data Centre provides database administrator support for Oracle enterprise level databases at various sites within Oceans and Atmosphere. This covers backup and restores, applying security and other support patches, database migration to new versions and assisting users with schemas, access rights and support for APEX application development.

Data Centre applications uses Oracle spatial infrastruture to provide mapping services and the capacity for complex spatial joins. An example of the latter is the ARMADA application where data from web services by external providers is aggregated and queried against complex regions as part of a NESP Marine Biodiversity Hub project looking at existing data coverages.

The Data Centre staff are familar with a range of database technologies (Postgres, MySQL and Access), and can assist in data migration, schema designs and resolving general database issues. We encourage staff to contact us at an early stage, particularly if you are interested in integrating data into our systems for further reuse.