Rockwell Automation RSBizWare Administration Guide - Manual (Page 262)

Appendix B Database tips
The following table lists the frequently used RSBizWare tables and
indexes, as well as the RSBizWare components that use them.
Frequently used RSBizWare tables and indexes
Table Index Component
RSDataPointSample RSDataPointSample_IDX1
FactoryTalk Historian Classic
RSSQL_CMPCOMPRESS RSSQL_CMPCompress_IDX1
OEEEvent OEEEvent_IDX1
OEEEvent_IDX2
OEEEvent_IDX3
OEEEvent_IDX4
OEEEvent_IDX5
OEEEvent_IDX6
OEEEvent_IDX7
OEEEvent_IDX8
FactoryTalk Metrics
OEEStateData OEEState_Data_IDX1
OEEWorkcell OEEWorkcell_IDX1
OEEWorkcell_IDX2
OEEWorkcell_IDX3
OEEWorkcell_IDX4
OEEWorkcell_IDX5
The FactoryTalk Historian Classic and FactoryTalk Metrics
applications require a single database for permanent storage.
Although they share the same database, each application uses unique
tables to support its core functions. The RSBizWare database can be
either a Microsoft SQL Server database or an Oracle database. If you
plan to use Oracle, read this chapter to learn about recommended
Oracle database settings and to learn how to tune your Oracle
database for use with the time-series analysis capabilities of the
FactoryTalk Historian Classic application.
Using Oracle with RSBizWare
262 Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014