Local Database

The Local Database provides a light weight, self contained SQL database engine. This SQL database engine is used by the application logic in your triggers for a variety of tasks, for example:

Temporary storing of data
Reference table look ups
Longer term collection of data

There is no restriction on the types of tasks your triggers support using the Local Database feature.

When you select the Local Database icon from the Workbench left hand pane, the Local Database window appears in the right hand pane with individual tabs for different Local Database functions. The Local Database files are stored on disk or in memory, depending on the selected Storage Option when creating the Local Database Table.

deviceWISE local database is an SQL-based relational database management system (RDBMS) implemented as an embeddable library. It stores databases as discrete files, rather than relying on client-server model. Though it incorporates the features in other major RDBMS, it is limited in the performance while using large data record operations. It is recommended to use local database for small to medium size data record operations with low to medium performance. If you want large data record operations with high performance, optimizations or fine tuning you should avoid using the local database. For information about the SQL database engine, see SQLite.org.

The local database feature is not available on the Enterprise Gateway for Siemens ERPC product.

To better understand the types of database and how they behave when creating a local database table, access the SQL Data type explanation

Local Database support in the Transaction Server

The actions that use the Local Database are documented in the Trigger action reference, Local Database actions section.

In addition to the Local Database actions supported on Asset Gateways and Enterprise Gateways, the Transaction Server component of the Enterprise Gateway products support the Local Database feature with the Transaction action, transport maps and transports. For more information on the Transaction Server component's support, see Referencing a local database transport.

The Transaction Server's support of Local Database tables is restricted to disk based tables. Local Database tables created in memory are not supported by transport maps and the Transaction action.