How do i denormalize the normalized log and recipe data to get them in a regular table?

217 views
Skip to first unread message

Anders Jorsal

unread,
Nov 14, 2012, 3:46:41 PM11/14/12
to plcsq...@googlegroups.com
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 20 columns parameters. This should then give a hint on how to get data out of the database.

SQL View generator.xls

Anders Jorsal

unread,
Jan 8, 2016, 6:13:18 PM1/8/16
to PLCSQL Link technical forum
Attached is a new version, which will handle up to 100 columns in the view.
SQL View generator 100.xls

f...@plcsql.com

unread,
Oct 16, 2018, 5:58:13 AM10/16/18
to PLCSQL Link technical forum
Attached a Version to handle a View Generator in MySQL Workbench
SQL View generator 100 MySQL.xls
Reply all
Reply to author
Forward
0 new messages