Custom Data Models

Overview

The RhinoDHE allows you to harmonize data to a custom data model rather than a predefined standard such as OMOP. This is useful when your project has a only requires a specific subset or structure of data and performing a full mapping to a standard data model would be unnecessary.

For example, you may want to prepare a dataset for a machine learning model that expects a specific set of fields, create a standardized research dataset containing only the variables needed for an analysis, or transform data into a common ontology agreed upon by multiple collaborators.

Prerequisites

You must have the "Manage Data Mappings" permission.

Before you begin:

• The source data you want to use should already be available in Rhino FCP.

  • The schema for this will be auto-generated if you do not explicitly define it.

• Determine which fields you want to include in your custom data model.

• Determine how you want to transform your fields from source to target.

Steps

To define the structure of your custom data model, you first create a Data Schema specifying the fields, data types, and other properties that the resulting dataset should contain. You then create a Syntactic Mapping that defines how data from your source dataset should be transformed to match that schema.

1

Select the project

Select the project that contains the syntactic mapping of the data.

2

Open Data Schemas

Select Data Schemas from the menu on the left.

3

Create a new data schema

Select Create New Data Schema button in the upper right corner.

4

Enter schema details

Enter the name and description of the target data schema.

5

Choose how to create the schema

Select the Create Blank Data Schema or Upload From File button.

If you want to create your own schema from scratch, select create blank data schema.

If you have a CSV file, select Upload from File and select the file from your computer or device.

6

Create the schema

Select the Create New Data Schema button. The schema appears.

If you selected the Create Blank Data Schema button, a blank schema will appear like the following.

If you chose Upload From File button, you’ll see the fields from your CSV file.

7

Add fields

For each tabular column, add the Name, Identifier, Description, Role, Type, Type Params, Units, May Contain PHI, and Permissions.

To add additional fields, select the Add Fields button.

8

Save the schema

When complete, click Save.

9

Create the syntactic mapping

Create a new Syntactic Mapping by following instructions in Syntactic Mapping.

Make sure that the target data model is Custom.

Select the new schema that you created in the previous steps for the Target field.