Extension tables for history data
- Last UpdatedMar 19, 2025
- 1 minute read
Many of Historian's tables are implemented as extension tables. That is, they are logical tables that are actually populated from data in history blocks.
Note: Extension tables are also called remote tables.
Data access from the history blocks is made possible by SQL Server's OLE DB provider technology. Client applications must connect directly to the Microsoft SQL Server and then specify to use the AVEVA Historian OLE DB provider in the syntax of the query.
The extension tables are:
|
History |
[INSQL].Runtime.dbo.History |
|
Live |
[INSQL].Runtime.dbo.Live |
|
AnalogSummaryHistory |
[INSQL].Runtime.dbo.AnalogSummaryHistory |
|
StateSummaryHistory |
[INSQL].Runtime.dbo.StateSummaryHistory |
|
HistoryBlock |
[INSQL].Runtime.dbo.HistoryBlock |
|
Events |
[INSQL].Runtime.dbo.Events |
For more information on the history extension tables, see History Tables and Views in the Historian Database Reference.
Legacy Process Data Extension Tables
These are legacy (backward compatible) extension tables for process data:
|
AnalogHistory |
[INSQL].Runtime.dbo.AnalogHistory |
|
DiscreteHistory |
[INSQL].Runtime.dbo.DiscreteHistory |
|
StringHistory |
[INSQL].Runtime.dbo.StringHistory |
|
AnalogLive |
[INSQL].Runtime.dbo.AnalogLive |
|
DiscreteLive |
[INSQL].Runtime.dbo.DiscreteLive |
|
StringLive |
[INSQL].Runtime.dbo.StringLive |
The AnalogHistory, DiscreteHistory, StringHistory, and History tables are the only tables which are updateable. The remaining tables are read-only.
For more information about these tables, see Backward Compatibility Entities in the Historian Database Reference.
Legacy Event Data Extension Tables
These are legacy (backward compatible) extension tables for events:
|
v_AlarmEventHistoryInternal2 |
[INSQL].Runtime.dbo.LegacyAlarmEventHistory |
|
v_AlarmHistory |
[INSQL].Runtime.dbo.LegacyAlarmHistory |
|
v_AlarmHistory2 |
[INSQL].Runtime.dbo.LegacyAlarmHistory2 |
|
v_EventHistory |
[INSQL].Runtime.dbo.LegacyEventHistory |
|
v_AlarmEventHistory2 |
Same as v_AlarmEventHistoryInternal2 |