FPRVF_bDinG-BTT01 (cdf)

version

0.9

framework class

fprvf

input data format

batch / csv file

data injection technique

cron file watch

data processing

internal analytics database

data output

internal analytics database

deploy format

microservice

scientific team

–

conception team

[BTT.DA] [BTT.PR] [UA.ER]

1. Input Data

Source	Field	Type	Data Level	Observations
Sensor Data	dt	datetime	A	[1]
Sensor Data	locationID	varchar(150)	A
Sensor Data	param_name	varchar(255)	A	[2]
Sensor Data	result_value	float	A	[3]
Sensor Data	unit	varchar(16)	A	[4]
Sensor Data	lower_tolerance	float	A	[5]
Sensor Data	upper_tolerance	float	A	[6]
Sensor Data	result_state	float	A	[7]
Sensor Data	workcycle_counter	float	A	[8]

Table Observations:

• [1]: Timestamp obtained when the measure is taken.

• [2]: Name of the Sensor

• [3]: Value Measured by the sensor

• [4]: Unit of the value that was measured

• [5]: Lower limit for the value measured

• [6]: Upper limit for the value measured

• [7]: Evaluation of the process of execution

• [8]: Indicates the number of reworks or if a part was processed multiple times

2. Output Data

Inject into [FPRVF_DinSDL].

3. sbroETL information

— bDinG-{inst}{NN}: Batch datain gateway framework (inFiles: sbroFMK-bDinG-{inst}{NN}.yml, class: GATEWAYS/project)

1. [cron bDinG-{inst}{NN}_main] Chooses the correct csv input file and inject into DinINST

2. […] Filter current data in DinINST and mark it

3. […] For marked data, validate data, reject problematic data and trigger alerts

4. […] For marked data, transform data into DinSDL (calculating the needed variables)

5. […] For marked data, remove rows

6. […] Call any needed execution via “./run-sbro.sh”

7. [run] exec scheduler start

4. Components

---

Identification

bDinG-BTT01_INJ01

Description

Watch a directory for a new csv file and inject it to the internal analytics database in a normalized format.

Implementation team

[UA.ER]

Plugins

Do not use plugins.

---