Database Freedom for the Victorian Jury Management Solution and Court Services Victoria: AWS RDS Postgres Migration

Komal Gandhi Posted 23 December 2020

Modis has been assisting the Victorian Court Services by managing and maintaining the Jury Management Service.

This solution assists scheduled jurors to court rooms efficiently, keeping members updated as schedules change, and ensuring that the legal system can fulfil its obligation to justice.

The Scenario

The architecture of the Java application that drives this service revolves around a central database, and for many years, this has been an Oracle Standard Edition 1 based database. Running within the ASW Cloud, this database was a fully managed relational database, which optimised the operational administrative overhead.

As Oracle SE 1 was nearing end-of-life, Modis reviewed the upgrade path to Oracle SE2.However, the usage of this database was simple and common: table storage and relational queries, but the combined cost for this simple usage was relatively high.

Working with Court Services, Modis reviewed the choices in front of them:

  • Simple upgrade process to Oracle SE2
  • Database optimisation to another platform to reduce cost

The Solution

Modis proposed a migration from Amazon Web Services Relational Database Service (RDS) Oracle to AWS RDS Postgres. This project required technical architecture of fine grained data structures, data queries, and coding implementation to support a replacement database.

Modis performed a Migration assessment, implement database schema & software (code) conversion, cut over with data conversion and data migration. In addition, further data validation during migration was performed to ensure integrity.

Modis has extensive experience in helping customers migrate from expensive commercial databases to a managed open-source service in the AWS Cloud. The Land Registry of Western Australia was authoritative in an Oracle solution until June 2015, but since July 2015, this has also been secured in an AWS RDS Postgres solution.

The Outcome

The cost for a like-for-like compute and storage saw the per hour cost for the database component drop from US$1.033/hour, to US$0.60/hour before reservations or discounts, a saving of over 41%. This service has a corresponding non-production environment(s), and additional savings were replicated and the Return On Investment (ROI) was calculated to be three months.

Modis continues to work with its customers to help them optimise and modernise their technology solutions.

Find out how Modis can provide you with innovative AWS cloud based solutions and servicesModis has been an AWS Advanced Tier Partner since 2014. Modis' AWS Cloud Consulting services encompasses fundamentals of cyber security, fault tolerant digital system architecture, modernisation, traditional virtual machine or through to modern Serverless approaches, commercial off-the-shelf software operation to bespoke software development, delivered with high throughput, repeatable DevOps approaches to operations. With over half a decade of running critical authoritative government data sets that affects the lives of millions of citizens and the economies of the state, Modis has one of the most mature, experienced and recognised consulting service providers in the world. More importantly, we like to work very closely with our customers, not providing something to purchase, but taking a deep understanding of their business, and providing the recommendations and implementations to ensure a modern, efficient, reliable and secure environment for digital business systems.Contact us
Modis Australia | Animated map showing global locations
We operate around the world. Would you like to find out more about your local office?Find out about Modis