Data access

Current values
Historical data
ESL RPC procedure call
Limitations
Description of columns containing status information

Current values

Basic current values are sorted out by a value type into the following five tables.

1. AnalogPoints - real values and relative time values.

COLUMN NAME	VALUE TYPE	SIZE
NAME	CHAR	64
DESCRIPT	CHAR	50
VALUE	DOUBLE	8
STATUS	INTEGER	4
WEAK	INTEGER	4
DEFAULT	INTEGER	4
LIMITS	INTEGER	4
FLAGS	INTEGER	4

2. IntegerPoints - integer values.

COLUMN NAME	VALUE TYPE	SIZE
NAME	CHAR	64
DESCRIPT	CHAR	50
VALUE	INTEGER	4
STATUS	INTEGER	4
WEAK	INTEGER	4
DEFAULT	INTEGER	4
LIMITS	INTEGER	4
FLAGS	INTEGER	4

3. EnumPoints - enumerated types including Boolean type.

COLUMN NAME	VALUE TYPE	SIZE
NAME	CHAR	64
DESCRIPT	CHAR	50
VALUE	INTEGER	4
STATUS	INTEGER	4
WEAK	INTEGER	4
DEFAULT	INTEGER	4
LIMITS	INTEGER	4
FLAGS	INTEGER	4

4. TimePoints - absolute time values.

COLUMN NAME	VALUE TYPE	SIZE
NAME	CHAR	64
DESCRIPT	CHAR	50
VALUE	TIMESTAMP
STATUS	INTEGER	4
WEAK	INTEGER	4
DEFAULT	INTEGER	4
LIMITS	INTEGER	4
FLAGS	INTEGER	4

5. TextPoints

COLUMN NAME	VALUE TYPE	SIZE
NAME	CHAR	64
DESCRIPT	CHAR	50
VALUE	CHAR	254
STATUS	INTEGER	4
WEAK	INTEGER	4
DEFAULT	INTEGER	4
LIMITS	INTEGER	4
FLAGS	INTEGER	4

Variables of the types Value array and Structured variable are in separated tables. Table name is derived from a name of the variable so that the dot character "." is substituted by the underscore character "_" in the name.

Each object of the Value array type creates a table of the following format:

COLUMN NAME	VALUE TYPE	SIZE
TIME	TIMESTAMP
VALUE	DOUBLE	8
STATUS	INTEGER	4
ROW_ID	INTEGER	4
WEAK	INTEGER	4
DEFAULT	INTEGER	4
LIMITS	INTEGER	4
FLAGS	INTEGER	4

Each object of Structured variable type creates a table of the format corresponding to a form of the structure variable. In addition, ROW_ID column, determining an order number - structured variable row, is added to this table.

Historical data

The variables of Historical value type create separated tables. Table name is derived from the name of the historical variable so that the dot character "." is substituted by the underscore character "_" in the name.

Each variable of Historical value type creates a table of the following format:

COLUMN NAME	VALUE TYPE	SIZE
TIME	TIMESTAMP
VALUE	DOUBLE	8
STATUS	INTEGER	4
STEP	INTEGER	4
WEAK	INTEGER	4
DEFAULT	INTEGER	4
LIMITS	INTEGER	4
FLAGS	INTEGER	4
ARCH_FLAGS	INTEGER	4

There is implemented the table ArchivValues which enables to get values of several archive objects with the same time. By a selection from this table, it is possible to enter several names of archive objects within one command.

For example:

SELECT TIME,VALUE01,STATUS01,VALUE02,STATUS02 FROM ArchivValues WHERE TIME >{ts '2000-04-11 10:00:00'} and TIME <{ts '2000-04-11 12:00:00'} and NAME01="H.AAA1" and NAME02="H.AAA2" and STEP=60

The structure of the table ArchivValues:

COLUMN NAME	VALUE TYPE	SIZE
TIME	TIMESTAMP
STEP	INTEGER	4
NAME01	CHAR	64
VALUE01	DOUBLE	8
STATUS01	INTEGER	4
WEAK01	INTEGER	4
DEFAULT01	INTEGER	4
LIMITS01	INTEGER	4
FLAGS01	INTEGER	4
ARCH_FLAGS01	INTEGER	4
NAME02	CHAR	64
VALUE02	DOUBLE	8
STATUS02	INTEGER	4
WEAK02	INTEGER	4
DEFAULT02	INTEGER	4
LIMITS02	INTEGER	4
FLAGS02	INTEGER	4
ARCH_FLAGS02	INTEGER	4
...
NAMEn	CHAR	64
VALUEn	DOUBLE	8
STATUSn	INTEGER	4
WEAKn	INTEGER	4
DEFAULTn	INTEGER	4
LIMITSn	INTEGER	4
FLAGSn

Data Access

Data access

Historical data