SQL Tall/Long vs Wide Table Structure

I generally make tables wide enough to permit related values to share a row in a table with a single timestamp column. This is the classic transaction group. If multiple entities share that specific structure, I include a column to indicate which entity to minimize the proliferation of tables. That would be the block transaction group, though I don’t usually use it – I prefer to trigger individual rows as needed. Both of these approaches are extremely friendly to external data analysis, but need to be charted with DB pens.

Any value that is truly independent goes into the regular tag historian (tall tables). This is brain-dead easy to chart.

Note that I decide based on the use of the data, and make my infrastructure conform.

2 Likes