MOSTLY AI analyzed the database’s schema and configured the database’s relationships on the basis of the subject table classification you provided in Step 5. During this analysis, MOSTLY AI distinguished between two types of relationships:
Relationships that are critical for privacy security and synthetic data accuracy.
MOSTLY AI classifies these as Context foreign key relationships.
Relationships that are necessary for maintaining referential integrity.
MOSTLY AI classifies these as Smart Select foreign key relationships.
Column details tab, you can review how MOSTLY AI classified the database’s relationships and optionally configure how the Smart Select relationships will be rendered.
By default, the entries in the parent and child tables of a Smart Select relationship will be randomly linked. That is to say, the foreign key column will be populated with randomly drawn ID’s from the primary key.
You can change this behavior by designating one or more columns of the parent table in a relationship as Smart Select columns. MOSTLY AI can then use these attributes to find appropriate matches with the entries in the child table of a relationship. This will result in a more accurate rendering of these relationships in the resulting synthetic database.
These are two ways to designate Smart Select columns:
Smart Select columnssection in a subject table’s
Here you can configure a subject table’s multiple referring tables at once.
Read more in the respective section on this page.
Using the column parameters of a Smart Select foreign key column.
Here you can configure parent-child table relationships where the parent is not a subject table.
Read more in the respective section section on this page.
To decide which method best suits your database, please review how MOSTLY AI preconfigured the relationships. Whenever you find a linked table with a Smart Select foreign key pointing to another linked table, then you can only configure this relationship using the
Column parameters of that Smart Select foreign key column. Read on to learn how to review these relationships.
Column details tab is divided into two panes. The left pane lists the tables you selected in Step 5. The right pane shows the details about the role a given table has in the dataset and its relation to the other tables. Here, you can also configure its training parameters and access column level job settings, such as the generation method, encoding type, and encoding options.
- Left pane
Here you can select the table that you want to configure. Each subject table in this list has a
Subjectindicator next to its name.
- Right pane - top section
This section shows the table name, its role in the database, to which root table it belongs, and its number of foreign keys.
- Right pane - middle section
Here you find the column list for the selected table. You can learn which
Generation methodMOSTLY AI assigned to each column, exclude columns from the resulting synthetic database by toggling the
Includeswitch to the left, or configure the generation method by clicking the
- Right pane - bottom section
In this section, you can configure the training parameters for the selected table. If you selected a subject table, then you can also select the Smart Select columns that guide MOSTLY AI in finding appropriate matches between the entries in this table and its referring tables.
To determine which linked tables have Smart Select foreign keys that point to other linked tables, click through all linked tables in the
Table list and check whether you can find such a foreign key in the column list. A column with these characteristics would have
Smart Select foreign key → [name of another linked table] as its
Subject tables have a
Smart Select columns section in their
Column details view. It simplifies the configuration process by allowing you to configure all relationships between the selected subject table and its referring tables at once.
By following the steps below, you designate one or more columns of the selected subject table as Smart Select columns and immediately apply this configuration to the Smart Select foreign keys of the referring tables. This will save you a lot of effort in configuring each relationship individually.
Select a subject table from the table list in the left pane.
Scroll down until you see the
Smart Select columnssection and click on
A modal appears where you can choose which columns of the selected subject table are to be used as Smart Select columns. Each column you add will improve the accuracy with which MOSTLY AI can match the entries in this table and its referring tables.
Next, you can rank the selected Smart Select columns by order of importance by dragging them up or down. This will further improve the accuracy with which the relationship is rendered.
Once you have completed the configuration, click
Apply to referring tables. It will then be applied to the Smart Select foreign keys of the referring tables.
If you configured some Smart Select foreign keys using the
Column parametersof the referring tables, you might want to click
Apply to unmodified referring tablesinstead. The configuration that you created will then only be applied to the remaining Smart Select foreign keys.
If you want to verify whether your Smart Select configuration is applied to the referring tables, select one of them from the
Table listand follow the steps in the section below.
You can also configure the Smart Select columns directly in the
Column parameters of a Smart Select foreign key column. This will allow you to configure relationships that don’t have a subject table as a parent.
Select a linked table from the table list in the left pane.
To access the
Column parametersof a Smart Select foreign key column, locate the column in the list of columns and click on the
Generation methodindicates whether a column is a Smart Select foreign key and to which parent tables it’s linked.
A modal appears where you can choose the Smart Select columns. If you click on
+ Add new column, you will see that these are the columns of the parent table. Each column you add will improve the accuracy with which MOSTLY AI can match the entries in this table and its parent table.
OKto confirm your Smart Select configuration.