Create tables
The Create Tables feature, allows empty tables to be created in data sources such as databases, which have the correct structure to hold evidence from a Bayesian network or Dynamic Bayesian network.
The tables created can be used to hold different evidence scenarios, which can be loaded into Data explorer, or used for Parameter learning or Data sampling.
Opening
With a Bayesian network or Dynamic Bayesian network open:
- Click the Create tables button on the main window ribbon toolbar tab entitled Data. This will first launch the Data connection manager window.
- Select an existing Data Connection, or create a new one and select it. Then click OK. This will launch the Execute Sql Setup window.
- Change and accept the values in the Execute Sql Setup window. This will launch the Execute Sql window.
- Change the sql if required, and click Execute.
Execute Sql Setup
This window allows the table name(s) to be specified and data types to be changed. Bayes Server will obtain suggested data types from the Data Connection chosen from Data connection manager.
If State names is selected, data types that can hold text will be used for discrete variables. If State indexes is selected, data types that can hold index values will be used for discrete variables.
Is Nullable checkboxes should only be checked when the data source supports the NULL and NOT NULL Sql keywords.
NOTE
If a network contains temporal variables, a temporal table is required to hold time series/sequence data. See the Data topic for more information.
Execute Sql
The Execute Sql window allows the auto generated Sql statement(s) to be modified, before execution.
When the Execute in a transaction checkbox is selected, a transaction is used when executing the Sql statements. This is useful when multiple statements are generated for networks containing both non temporal and temporal variables, allowing all statements to be rolled back if one fails.