Data Access Layer (DAL) - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

All commands to access any of the data in the database are centralized within a database layer referenced as the Data Access Layer (DAL). Within this layer, most of the SQL is dynamically generated depending on the request being made. Depending on role access, query, and create configurations, the SQL is generated and preprocessed to determine the most efficient way of extracting the data from the database.

For example, if multiple domains belonging to the same domain group are accessed, the SQL accesses all the domains for data simultaneously. Multiple queries are only made when the data exists in more than one domain in the domain group.

The SQL generated makes considerable use of bind variables within the query, which results in better database performance for second or subsequent queries of similarly structured SQL. The DAL automatically stores data that extends beyond 4000 characters or where the information is file content. The DAL has been written to support both Oracle and SQL Server databases.