Versions Compared

Old Version 3

changes.mady.by.user GOAVEC, Marie

Saved on

compared with

New Version Current

changes.mady.by.user GOAVEC, Marie

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

This section aims to present the Data Architecture implemented for data flow in Lab Booster. 

ELN Schemas


File NameData Model File
Agro

Google Drive Live Link
urlhttps://drive.google.com/file/d/1Y20P0pHKkbzQzEJxS3tiMDENbHVUs6VI/view?usp=sharing

Battery

Google Drive Live Link
urlhttps://drive.google.com/file/d/1sD6OqKnBzSR_SrGvzlhEl7s5F5vUGQqD/view?usp=sharing

Coatings

Google Drive Live Link
urlhttps://drive.google.com/file/d/1dqYHC_ZfLq-dzQ50xSQ-F7UNf7mEz6oj/view?usp=sharing

Seed Care

Google Drive Live Link
urlhttps://drive.google.com/drive/folders/1lBuQd9dwn4l-z7eb8GYX85xUQtHtcF9h

Actizone

Google Drive Live Link
urlhttps://drive.google.com/file/d/12OD8DRfO3ANu3VPu8acd5y24uOKWTkTW/view?usp=sharing

HPC Flocculation

Google Drive Live Link
urlhttps://drive.google.com/file/d/1TaigyyQuNOC3J2zdNaQVvSZ8ujJw4o00/view?usp=sharing




ELN Spreadsheets design standards

Design is really important for user experience.

The user feedback about the first version of the ELN templates where more about the design than the content. They didn't really enjoy the "black and yellow" spreadsheets.

So for Coatings' Paint Formulation SS V2, we worked on defining design standards using Solvay's color palette as a base.

These standards are going to evolve according to the future needs.

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1Doe9eJpOuzEz8GjtJbw4Jx_2CxAx_3fgHD1M58O8rJo/edit?pli=1#gid=1519965338

Here are documentations about developed spreadsheet in PROD:

Agro

BatteryConductivity
BatteryMechanosynthesis

Google Drive Live Link
urlhttps://docs.google.com/document/d/1DU5HtiTkiyNU8k-lOV_jzm3DrgUmk4CTU2n7YXyWMP4/edit?usp=drivesdk

CoatingsEP

Google Drive Live Link
urlhttps://docs.google.com/document/d/1xqR_Ppz6_iwOzSkXhd4JcHePjBjChIMSkLKwDTo4YJQ/edit?usp=drivesdk

Seed CareFormulation

Google Drive Live Link
urlhttps://drive.google.com/drive/folders/1ZiSoTbYb8zSh1oW5yKdxx5z6FRm_gN3Q

Seed CareResults & Requests

Google Drive Live Link
urlhttps://drive.google.com/drive/folders/1ZiSoTbYb8zSh1oW5yKdxx5z6FRm_gN3Q

Entities and Relationships

ENTITIES

EntityDefinitionExample(s)ExperimentA defined set of lab activities performed on samples of specific products/components

Emulsion Polymerization experiment

Solvent screening experiment

FormulationThe ingredients (generic) and their proportion (target) composing a formula

Formulation ABC = 

1,2- Dibromoethane - 89%

+ Rhodacal 60 - 5%

+ Rhodasurf L-20 - 6%

Formulation BatchA use of a formula prepared in the lab with the real ingredients (chemical inventory) and their proportion (actual)

Formulation ABC Batch xxxx =

1,2- Dibromoethane Batch xxxx Sigma Aldrich - 89.1%

+ Rhodacal 60 Batch xxxx - 5.2%

+ Rhodasurf L-20 Batch xxxx- 5.7%

IngredientA product, component, material, sample of formulation batch recorded in chemical inventoryRhodasurf L-20 Batch SP4D26X01 100% active received 08/06/23Sample

A piece of the product/component on which the test is perfomed

The sample can be taken from:

  • A raw material: a product/component received from a supplier 
  • A formulation batch: a combination of raw materials and/or synthesized products/components
  • A synthesized product/component: a product/component resulting from the combination and transformation of raw materials and/or other synthesized products/component

Raw material: methanol from Sigma Aldrich

Formulation sample: combination of solvent, active ingredient and other additives

Synthesized product: latex 

Activity GroupA group of lab activities performed on the same sampleSyrup experiment includes photographing, measuring pH, measuring conductivity, measuring viscosity of one sampleLab Activity

Observation/analysis of the behavior of a sample of a component/product when a procedure is carried out in a set of conditions :

  • Sample preparation
  • Sample analysis
  • Sample performance in application

It has an SOP (Standard Operating Procedure)

Formulation

Conductivity

Paint application

ProcessConditionA variable/setting defined by the operator for a lab activity and affecting its outcome

Temperature/pressure at which experiment is carried out

Solute concentration

ResultThe outcome of a lab activity performed on a sample in specified conditions
It can be a numerical value, a set of numerical values (i.e. curve) or a non numerical value (i.e. observations)pH = 8.4
 Shear stress vs. Shear rate
Pass/FailResult SerieA set of results, obtained for a lab activity performed the same conditions, and measured with a time interval between themSample agingMeasureA property of the sample 
In the context of a lab activity it can be a condition and/or a resultTemperature 





Lab Booster Data model


Include Page
LB Data Model
LB Data Model

RELATIONSHIPS

One Experiment can have;

  • One or more Samples;
  • One or more Formulations;

A Formulation can have:

  • One or more Ingredients;
  • One or more Formulation Batches;

A Formulation Batch can have:

  • One or more Ingredients;

A Lab Activity can:

  • Have one or more Processes;
  • One or more Samples;
  • Be associated to only one Experiment;

A Sample can:

  • only be part of a Formulation Batch;
  • have one or more processes associated;
  • be part of one or more processes;

A Process can:

  • Have/use multiples Samples;
  • Be a part of a group of processes used within a Sample;

A Formulation Batch can be associated to one or more Samples;

A Test Group can:

  • Only be part of one Sample
  • Have one or more Tests

A Test can:

  • Only be part of one Test Group
  • Have one or more Conditions
  • Have one or more Result Series

A Condition can:

  • Only be part of one Test;
  • Have one or more Measures;

A Result Serie can:

  • Only be part of one Test;
  • Have one or more Results;

A Result can:

  • Only be part of one Result Serie;
  • Have one or more Measures

A Measure can be used both as a Condition as well as a Result;

ENTITY-RELATIONSHIP DIAGRAM

Legend

Entity

Primary key

Foreign key

Attribute 

Relationships

  • The ring represents "zero"
  • The dash represents "one"
  • The crow's foot represents "many"

Diagram

Image Removed


BigQuery


New Data Model of ALB Data Mart (Exposition layer): https://app.genmymodel.com/api/projects/_k07o4IBOEe29ie0vpi-P5A/diagrams/_k07o4oBOEe29ie0vpi-P5A/svg

Data Mapping to Data Mart:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1wbux4wRuV9by_qMHbTkZxZb_nJYQiNxFVoOQxUi-B2c/edit#gid=958619263


The following BigQuery datasets are all staging as per the data convention explained previously.

For more ETL (extraction, transformation, loading) details, please refers to: App Lab Booster (ALB) - Data 

Batteries

Materials

Coatings

Data mapping


File NameData Mapping File
Agro
Coatings

Version 2:
Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1dOfcK8cIr3ewYhfVyl8ptZw2tmpYTDEsLZzvcO9PtLc/edit?usp=sharing

Version 1:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1eCjNDwHDe-6CWJ5wEC08VUFCb5SQeYKX3Gf_jI8AZA0/edit#gid=114623646

Battery

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1VWSmasqwUzEb4V7FZ4rjE2XKv3ZuUvLfa83kOTch4BM/edit#gid=1060222631

Materials

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1tjV8I42BkyFW48-SIUIQZQdDpnaYbtYq/edit?usp=sharing&ouid=117421811921505411556&rtpof=true&sd=true

Seed Care

Google Drive Live Link
urlhttps://drive.google.com/drive/folders/1tqRwNMNaIU9YyIqMOO6FmQja9MpQ200Z