Setting up the Database - Intergraph Smart Electrical - 10 - Installation & Upgrade - Hexagon PPM

Intergraph Smart Electrical Installation and Upgrade

Language
English (United States)
Product
Intergraph Smart Electrical
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
Smart Electrical Version
10
Smart Instrumentation Version
(none)
Smart P&ID Version
10
Smart Engineering Manager Version
11

Installing any database involves significant decisions regarding the size of the database, the maximum number of users, the frequency of automatic backups, and other important issues.  Therefore, the following sections provide only suggestions for tuning your database configuration to work with Hexagon PPM software. The ultimate database creation and configuration depends on the policies and standards at your company.

Smart Electrical includes a number of deferrable database constraints, which are rules used to ensure database integrity by checking values at the time the information is written to the database.  If all of the information does not fall within these embedded constraints, the information is not written to the database, and the software rolls back the transaction.

These deferrable database constraints are applied only when you use an Oracle database; SQL Server does not support them.