Database Interfaces

All database interfaces require a properties file that defines the JDBC driver and the database location. (See the section “Interfacing With A Database” in Chapter 4 of Part D of the SIMPROCESS User’s Manual for more information on properties files.)

Database Input Source

A Database Input Source is an interface for creating a connection to a database for the purpose of reading in data. The defined input source is then available in the SIMPROCESS distribution list. Every time the input source is activated (for example by an Activity requesting a delay time) the next value is returned. Enter the SQL that retrieves the data and the Column to use.

The file InputSource.bundle is included in the Demos directory. This is a model bundle of a model that includes a Database Input Source. Also, the model DatabaseDemo.spm in the Demos directory has a Database Input Source example.

Database Results Export

The Database export provides an interface for creating Insert, Update, and Delete SQL for execution before, during, and after a simulation. The interface connects to the database specified in the properties file and populates the interface with the database tables and columns. The Values specified for export represent performance measures or other simulation information. They are replaced at the time of execution with the actual values of the items listed under Values.

The model DatabaseDemo.spm in the Demos directory includes examples.

Database Distribution Fitting

Input data for the distribution fitting feature of SIMPROCESS can be read in from a database.

Database Entity Generation

The Database schedule of the Generate Activity provides an interface for Entity generation and for setting Entity instance Attributes. The Database schedule can control the Entity Type for generation, the quantity, and the interval. There is a separate tab for setting Attribute values.


Database System Methods

The Database System Methods give you full database interface capability. Using Expressions you can retrieve information from an SQL database, and you can modify an SQL database by inserting into tables, deleting from tables, and updating tables. Knowledge of SQL is required since all queries to the database are SQL queries. There are six database-related System Methods, which can be used in Expressions:

  • OpenDatabase
  • CloseDatabase
  • ReadFromDatabase
  • WriteToDatabase
  • GetNext
  • GetResult

See the section “Interfacing With A Database” in Chapter 4 of Part D of the SIMPROCESS User’s Manual for more information on using these System Methods.

The models DatabaseDemoExp.spm and ConfigureWithDatabase.spm in the ExpressionDemos directory demonstrate these System Methods.