ABOUT DDA

Direct Database Access is designed for full application access to our Oracle database on cloud servers (DBaaS hosting by Amazon).

It provides a high-performance, high-availability, high-reliability and easy to use data access solution.

Our database is running on a cloud computing platform hosted by Amazon Web Services. It runs on high-performance machines to provide quick query response time compared to most in-house databases. Data is highly available and reliable with data being backed up at regular intervals. All management of data is handled by IES to provide you with easy access to the data you need.

The database deployed in Amazon Relational Database Service is Oracle 11g Standard edition one. You can browse the data using any third party query tools, for example, MS Excel, Toad, SQL developer, Squirrel, etc. IES also provides a free query tool that allows you to access our cloud database easily.

SCHEMAS

IES provides electricity market data & gas data in eastern and southern Australia published by the Australian Energy Market Operator (AEMO), electricity market data in Western Australian published by Independent Market Operator (IMO) and electricity market data in Singapore published by National Electricity Market of Singapore (NEMS).




It includes the following schemas:

  • MMS contains all the National Electricity Market (NEM) data.
  • VICGAS includes wholesale gas market data in Victoria.
  • STTM contains real time data from the Short Term Trading Market (STTM) system.
  • GSH contains public data files from the Gas Supply Hub (GSH) reporting server.
  • IMOWA includes Wholesale Electricity Market (WEM) data within the South West Interconnected System (SWIS) in Western Australia
  • GASBB covers all major gas production fields, major demand centres and natural gas transmission pipeline systems, including the interconnected systems of South Australia, Victoria, Tasmania, NSW, the ACT and Queensland.
Download brochure