Overview

Global-Roam provides a number of hosted MMS databases.

In the interests of database performance and storage efficiency, some of the datatypes in the official MMS schema have been altered by us, in particular, many numeric types in AEMO's schema are instead using smaller datatypes in our database, but care has been taken to ensure compatibility.

This site aims to document the differences between the "official" MMS schema and our "GR-MMS" schema.

Description of the model - AEMO Electricity Data Model v5.6.0

From: AEMO Electricity Data Model Report

The MMS Data Model is the definition of the interface to participants of data published by AEMO from the NEM system. A database conforming to the MMS Data Model can contain a local copy of all current participant-specific data recorded in the main NEM production database. The target databases have been called such names as the Participant Database, the Participant InfoServer and the Replica Database.

The MMS Data Model includes database tables, indexes and primary keys. The model is currently exposed as a physical model, so is different in presentation for each RDBMS. However, the same logical model underlies all the physical models published by AEMO.

The MMS Data Model is the target model for products transferring data from AEMO to each participant. Current product supplied by AEMO for data transfer is Participant Data Replication (PDR), with some support for the superseded Parser.

Compatibility of the transfer products with the MMS Data Model is the responsibility of those products and their configuration. AEMO's intention is to supply the data transfer products pre-configured to deliver data consistent with the MMS Data Model, noting differences where they occur (e.g. for historical reasons).