Connecting to a Database Server

From EMO Wiki
Jump to navigation Jump to search

WARNING: Connecting to a local or networked database server is complex and can be time-consuming. If no people in your company have previous experience of configuring EMarketOffer it is strongly recommended that you consult your company's technical support and also the Energy Link helpdesk for advice on the best approach.

Terminology

EMarketOffer's data design consists of 'things' included in the model, and their characteristics'. In this manual the 'things' are called Entities and their characteristics are called Traits. Traits may be static or dynamic.

For example the Circuit Entity can have the static Traits of Start Node and End Node, and the dynamic Traits of Powerflow and Loss by Trading Period.

Input Data Types

EMarketOffer can load the folowing types of Input data directly from external databases.

Entity Type Trait Mandatory Defined by
Node
Demand (Load)
Node.Load
No
Date, TP, Node, Load
Price
Node.Price
No
Date, TP, Node, Load
Unit
Unit Node
(Links Units to Nodes)
Unit.Node
Yes
Unit, Node
Generator Unit
(Links Units to Generators)
Unit.Generator
Yes
Unit, Generator
(Generators are always three alpha codes e.g. HLY = Huntly
Unit Generation
Unit.Generation
No
Date, TP, Unit, Generation
Unit Offer Quantity
Unit.OfferQn
(where n = band)
No
Date, TP, Unit, OfferQn
Unit Offer Price
Unit.OfferPn
(Where n = band)
No
Date, TP, Unit, OfferPn
Circuit
Circuit
Circuit.Name
Yes
Date, TP, Name
Node From
Circuit.NodeFrom
Yes
Date, TP, Circuit, NodeFrom
Node To
Circuit.NodeTo
Yes
Date, TP, Circuit, NodeTo
Reactance
Circuit.Reactance
Yes
Date, TP, Circuit, Reactance
Resistance
Circuit.Resistance
Yes
Date, TP, Circuit, Resistance
Fixed Losses
Circuit.FixedLosses
Yes
Date, TP, Circuit, FixedLosses
Capacity
Circuit.Capacity
Conditional
Date, TP, Circuit, Capacity
Winter Capacity
Circuit.WinterCapacity
Conditional
Date, TP, Circuit, WinterCapacity
Summer Capacity
Circuit.SummerCapacity
Conditional
Date, TP, Circuit, SummerCapacity
Equation
Formula
Equation.Formula
Yes
Date, TP, Equation, Formula
Limit
Equation.Limit
Yes
Date, TP, Equation, Limit
Type
Equation.EquationType
No
Date, TP, Equation, EquationType
Season
Equation.Season
No
Date, TP, Equation, Season
Active
Equation.Active
No
Date, TP, Equation, Active

Note:

  1. Mandatory Traits are the minimum required for EMarketOffer to operate
  2. Either a single Circuit capacity OR two seasonal Circuit Capacities are mandatorily required

Input Data Structure

Retrieved from "http://emo.energylink.co.nz/index.php?title=EMO:Connecting_to_a_Database_Server&oldid=2824"