ifference between revisions of "EMO:Connecting to a Database Server"

From EMO Wiki
Jump to navigation Jump to search
Line 13: Line 13:
 
! Entity !! Type !! Trait !! Mandatory !! Defined by
 
! Entity !! Type !! Trait !! Mandatory !! Defined by
 
|-
 
|-
!:Node
+
!Node
 
|
 
|
 
:Demand (Load)
 
:Demand (Load)
Line 23: Line 23:
 
:Date, TP, Node, Load
 
:Date, TP, Node, Load
 
|-
 
|-
!:
+
!
 
|
 
|
 
:Price
 
:Price
Line 33: Line 33:
 
:Date, TP, Node, Load
 
:Date, TP, Node, Load
 
|-
 
|-
!:Unit
+
!Unit
 +
|
 +
:Unit Node<br/>(Links Units to Nodes)
 +
|
 +
:''Unit.Node''
 +
|
 +
:Yes
 +
|
 +
:Unit, Node
 +
|-
 +
!
 +
|
 +
:Generator Unit<br/>(Links Units to Generators)
 +
|
 +
:''Unit.Generator''
 +
|
 +
:Yes
 +
|
 +
:Unit, Generator<br/>(Generators are always three alpha codes e.g. HLY = Huntly
 +
|-

Revision as of 09:00, 17 December 2012

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