FPRVF_sys (cdf)

version

1.0

framework class

fprvf

input data format

—

data processing

internal analytics database

data output

internal analytics database

deploy format

microservice

scientific team

—

conception team

[UA.ER]

1. Input Data

Configuration files.

2. Output Data

Manage the generation of all SQL tables and documentation outputs.

FPRVF_DinSDL

The DinSDL table for the [FPRVF] Product-UseCase

Field

Type

Observations

dt

datetime

[1]

dtint

bigint

[1]

locationID

varchar(100)

[2]

d001

varchar(100)

[3]

—

[3]

dxxx

varchar(100)

[3]

v001

float

[4]

—

[4]

vxxx

float

[4]

tags

varchar(300)

[5]

Table Observations:

  • [1]: Datetime string with the format “yyyy/mm/dd HH:MM:SS.f” and its corresponding UTC integer

  • [2]: The location identification of the UseCase

  • [3]: The set of categorical variables (e.g. scenario variables, aggregation variables); by default are NULL

  • [4]: The set of all numeric variables (e.g. sensor variables, process variables, KPIs, calculated variables); by default are NULL

  • [5]: A string with space separated tags or the empty string

General Observations:

  • Data is injected via FPRVF_bDinG-BTT01 (cdf).

  • The number of dxxx variables is defined in prjVG key “config/d_size” and the number of vxxx variables is defined in prjVG key “config/v_size”.

3. sbroETL information

— sys: Base system framework (inFiles: sbroETL-sys.yml, class: FOSM/project) – mandatory

  1. [exec sys_install/M01] (Re)create default system tables

  2. […] (Re)create datain table “DinINST” [institutional format]

  3. […] (Re)reate dataout table “DoutINST” [institutional format]

  4. […] (Re)create datain table “DinSDL” [CDF/sys format]

  5. […] (Re)create dataout table “DoutSDL” [CDF/sys format]

  6. […] Create tables of other frameworks (if needed)

  7. [exec sys_config/M01] Set system configurations

  8. [exec sys_docs/M02] Generate Product-UseCase documentation

  9. [up] Load SDL specific services, sbroETL variants “{*}F|{b,k}D{in,out}G” services and sbroBRT services

  10. [down] Unload all services create by up

  11. [exec sys_main/M01] Execution of Product-UseCase maintenance tasks and management of services

  12. [run] exec sys_docs

4. Components

Identification

sys_install

Description

(Re)create default system tables

Implementation team

[UA.ER]

Plugins

Do not use plugins

Identification

sys_config

Description

Set system configurations

Implementation team

[UA.ER]

Plugins

Do not use plugins

Identification

sys_docs

Description

Generate Product-UseCase documentation

Implementation team

[UA.ER]

Plugins

Do not use plugins

Identification

sys_main

Description

Execution of Product-UseCase maintenance tasks and management of services

Implementation team

[UA.ER]

Plugins

Do not use plugins