Database Options

NEM-Review is an application for analysing historical NEM Market Data. The application itself is "dumb" in that it does not know what the historical market data is. Rather it performs its calculations on a database, which is external to the application. When you first run NEM-Review you can choose which database to connect to (and you can change your settings from the options menu).

Web Database

When using a web database NEM-Review will connect, via the internet, to our online database at www.dataserver2.com.

If you are using a trial of NEM-Review, the web database is the only database you will have available.

It is extremely easy to set up, hence you may want to use the web database whilst you are setting up your network to use a local database. However, it will increase your internet bandwidth costs and may run slower than a local database.

Your application may automatically revert to using the web database if there is ever any problem with your network database (see How NEM-Review automatically chooses which database to use, below).

ProsCons
  • Quick and easy to set up
  • Easy to maintain
  • Requires constant connection to the internet
  • Is subject to the reliability of your internet connection (i.e. you may need to restart NEM-Review if your internet connection temporarily drops out)
  • Increases your internet bandwidth costs (especially if many computers on the network are using it)

Use the web database if:

  • You are using a trial of NEM-Review
  • You are having trouble setting up a local database
  • You only use NEM-Review occasionally

Network Database

When using a network database NEM-Review will connect to an access database, maintained by a NEM-Review updater somewhere on your network.

The NEM-Review updater keeps your access database constantly synchronised with NEM-Data provided through our servers. It means only one computer has to access the internet, it also means that you have a permanent, accessible supply of NEM-Data independent of any other AEMO data supply.

ProsCons
  • Permanent supply of data that can be queried through access
  • 70% of queries will run faster
  • Requires more time to set up
  • Requires IT maintenance

Use the network database if:

  • You have many NEM-Review users on your network
  • You use NEM-Review frequently
  • You would like to access NEM Data directly
  • Your security permissions prevent you from using the web database

Portable Database

If you are using a network database you will also have the option of setting up a portable database. A portable database is an exact copy of your network database that is stored on your local computer. Thus if you are using a laptop and need to travel and won't have connection to either the internet or your network database you will still be able to use NEM-Review.

You can set up your portable database through the options form for NEM-Review.

How NEM-Review Automatically Chooses Which Database to Use

Based on current circumstances NEM-Review will automatically choose which database to use without necessarily alerting the user. Thus NEM-Review may still connect to the web database even if you have previously set up a network database.

NEM-Review prefers the network database to the web database and will connect to it if a connection is available and the database is up to date, otherwise the application will use the following logic:

  • Connect to network database is available and up to date
  • Connect to portable database if available and up to date
  • If web database is available and up to date and network database is available but not up to date, give the user the choice about which database to use
  • If web database is available and up to date and portable database is available but not up to date, give the user the choice about which database to use
  • If the web database is either unavailable or out of date, but the network database is available, connect to the network database
  • If the web database is either unavailable or out of date, but the portable database is available, connect to the portable database
  • If the web database is available connect to it
  • Display a warning to the user, asking them to browse to a network database

The user can set steps 3 and 4 to automatically use a database, rather than ask. This option can be cleared from the options form by using the "Reset preferred database choice" button under the database tab.

The following table shows in more detail how NEM-Review will behave under different circumstances:

Web Database Status

Network Database Status

Portable Database Status

What the user experiences

Up to Date

Up to Date

Up to Date

NR automatically connects to the network database

Up to Date

Up to Date

Out of Date

NR automatically connects to the network database

Up to Date

Up to Date

Unavailable

NR automatically connects to the network database

Up to Date

Out of Date

Up to Date

NR automatically connects to the portable database

Up to Date

Out of Date

Out of Date

NR gives the user a choice between the web database, or their network database

Up to Date

Out of Date

Unavailable

NR gives the user a choice between the web database, or their network database

Up to Date

Unavailable

Up to Date

NR automatically connects to the portable database

Up to Date

Unavailable

Out of Date

NR gives the user a choice between the web database, or their portable database

Up to Date

Unavailable

Unavailable

NR automatically connects to the Web Database. This configuration is the default way NR is installed.

Out of Date

Up to Date

Up to Date

NR automatically connects to the network database

Out of Date

Up to Date

Out of Date

NR automatically connects to the network database

Out of Date

Up to Date

Unavailable

NR automatically connects to the network database

Out of Date

Out of Date

Up to Date

NR automatically connects to the portable database

Out of Date

Out of Date

Out of Date

NR automatically connects to the network database

Out of Date

Out of Date

Unavailable

NR automatically connects to the network database

Out of Date

Unavailable

Up to Date

NR automatically connects to the portable database

Out of Date

Unavailable

Out of Date

NR automatically connects to the portable database

Out of Date

Unavailable

Unavailable

NR automatically connects to the Web Database.

Unavailable

Up to Date

Up to Date

NR automatically connects to the network database

Unavailable

Up to Date

Out of Date

NR automatically connects to the network database

Unavailable

Up to Date

Unavailable

NR automatically connects to the network database

Unavailable

Out of Date

Up to Date

NR automatically connects to the portable database

Unavailable

Out of Date

Out of Date

NR automatically connects to the network database

Unavailable

Out of Date

Unavailable

NR automatically connects to the network database

Unavailable

Unavailable

Up to Date

NR automatically connects to the portable database

Unavailable

Unavailable

Out of Date

NR automatically connects to the portable database

Unavailable

Unavailable

Unavailable

NR displays an error message and asks where the network database is