About the runtime and holding databases

A relational database management system (RDBMS) such as Microsoft SQL Server can contain many databases. A database is a collection of objects such as:

• Tables

• Stored procedures

• Views

• User-defined data types

• Users and groups

AVEVA Historian includes two preconfigured databases: the Runtime and Holding databases.

The Historian embeds a full-featured Microsoft SQL Server. The Historian supports all system tables associated with SQL Server. For more information on the Microsoft SQL Server tables, see your Microsoft documentation.

Note: When installed on a case-sensitive Microsoft SQL Server, the Runtime and Holding databases are case-sensitive. Be sure that you use the correct case when performing queries.