Creating an In-Memory Database

A project has been created, the data source has been identified, now the user can add from your Toolbox to the Work Space and begin defining the import for the New TARGIT InMemory Database.

The user can select from any of the following icons in the Toolbox to begin the process:

Toolbox item description

Here is a rundown of the Toolbox:

Bulk Import – Similar to Import, the user is provided means to specify all tables, as well as columns to be imported from the user defined Data Source. This allows tremendous flexibility of the import, whereas Import will import only the table defined to import. The imports run serialized, so if you have a very large database, then you will probably want this to run in Parallel. See: BULK IMPORT

ClusteredIndex – Allows the user, when the data becomes extremely big, then you can generate a clustered index. See: CLUSTEREDINDEX

Condition – Allows the user to define a condition, like an IF Statement, if condition one is true, then execute what is in the Condition block, else execute condition two. See: CONDITION

Drop – Allows a user to drop temporary tables that may have been created via a Script. See: DROP

Enum – Allows the user to create an enumeration, which is a new table, used for translating one value to another as needed. See: ENUM

Exit – Allows the user to exit and update the views and exits out of a condition with an exit code, defined by the user or by default. See: EXIT

Group – Allows the user to group toolbox items which can simplify/clean their workspace. See: GROUP

Import – The most basic import tool, which the user will have to define the Data Source, Query, Query Type, Code Generation and Name. See: IMPORT

Parallel – When the user is attempting to Bulk Import a large database, this will allow a user to import the Bulk Import all at once, rather than serialized. Simply place your Parallel Tool item on the workspace, then drag the Bulk Import into the Parallel box. See: PARALLEL

Save – Allows the user to complete the import and save to local storage, in the publish deployment folder the In-Memory Database Store File. See: SAVE

Script – Allows the user to define a specific script to perform queries that suits their needs. See: SCRIPT

Slurp – Allows the user to define a data source to consume the entire contents of the database, which is unlike Bulk Import and Import, this may be useful, if new tables are added to the database. See: SLURP

Union – Allows the user to concatenate two tables if they are identical. See: UNION