RDMP-113 Dataset Linkage

Request

We want to be able to know what dataset (if any) a piece of information came from. This is so that when the data is extracted we can list the datasets that should be referenced in papers etc.

Initial Requirements

• Be able to link a dataset to a DOI (Digital Object Identifier)

  • Datasets are tables that are ingested by RDMP and form the underlying data that catalogues are constructed from

• Be able to link datasets with catalogues

• Have the dataset information be contained in the extraction data word document.

Potential Future Requirements

• This functionality is likely to be extended to accommodate HDR and other dataset providers. This functionality should be constructed with this in mind

Proposed Solution

1. Create a new “Dataset” Object type with in RDMP

   1. Will have the attributes:

      1. DOI (varchar(100),optional)

      2. Name (varchar(255), optional)

      3. Source (varchar(250),optional)

2. Add a new column to the ColumnInfo Table

   1. Will be a Foreign Key to a Dataset entry

3. Add ability to link existing columns to datasets

   1. “Link all” will populate the FK in all coluninfo items that match the same database table as the selected item

4. Add ability to Create/View/Edit/Delete Datasets

   1. New “Datasets” nav bar item

      1. Typical tree view structure in left hand panel

      2. Edit field in main view

5. When ingesting new data, have the option to select a dataset/create a new onw

6. When extraction occur, any dataset that was used in the extraction is noted on the extraction work document
   
   
   
   Images For Point 3

   Open

   

Open