How do i denormalize the normalized log and recipe data to get them in a regular table?
Our default database structure included in the standard package is based on a normalized architecture.
This makes the database very flexible with almost no database engineering or programming effort when the demands are changing.
The downside of this is that it is not very easy to overlook at a glance.
In order to look up data, you can Create a view. Where you define which parameters to monitor.
We have made an Excel document “SQL View generator.xlsm”, to create a SQL View with columns for each parameter you want to monitor.
This enables you to design the query for building a view, with up to 100 columns parameters. This should then give a hint on how to get data out of the database.