项目作者: HicServices

项目描述 :
Research Data Management Platform (RDMP) is an open source application for the loading,linking,anonymisation and extraction of datasets stored in relational databases.
高级语言: C#
项目地址: git://github.com/HicServices/RDMP.git
创建时间: 2017-08-23T15:25:09Z
项目社区:https://github.com/HicServices/RDMP

开源协议:GNU General Public License v3.0

下载


Research Data Management Platform" class="reference-link">logoResearch Data Management Platform

Build status Total alerts NuGet Badge Coverage Status

RDMP is a free, open source software application for cohort building, loading, linking, anonymisation and extraction of datasets stored in relational databases (SQL Server, MySQL, Postgres and Oracle). It was designed from the bottom up to support with data provenance, preserving domain knowledge and configuration management workflows.

RDMP does not require your data be moved or transformed prior to processing and is integrates into existing SQL based extraction practices.

image

Install

Signed release binaries for the RDMP client and Command Line Interface (CLI) are in the available in the GitHub releases section.

Windows Install Guide

Download and unzip rdmp-client.zip from the GitHub releases section and run ResearchDataManagementPlatform.exe. This will take you to an installation/setup screen which will guide you through the rest of the initial setup process.

Linux CLI Install Guide

The following steps can be used to install the RDMP CLI and start an SqlServer docker container to install into. Make sure to set the version (e.g. 7.0.14) to the latest and set a custom password if desired.

  1. wget https://github.com/HicServices/RDMP/releases/download/v7.0.14/rdmp-cli-linux-x64.zip
  2. unzip -d rdmp-cli ./rdmp-cli-linux-x64.zip
  3. sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=<YourStrong@Passw0rd>" \
  4. -p 1433:1433 --name sql1 --hostname sql1 \
  5. -d mcr.microsoft.com/mssql/server:2019-latest
  6. cd rdmp-cli
  7. cat > Databases.yaml << EOF
  8. CatalogueConnectionString: Server=localhost;Database=RDMP_Catalogue;User ID=SA;Password=<YourStrong@Passw0rd>;Trust Server Certificate=true;
  9. DataExportConnectionString: Server=localhost;Database=RDMP_DataExport;User ID=SA;Password=<YourStrong@Passw0rd>;Trust Server Certificate=true;
  10. EOF
  11. chmod +x ./rdmp
  12. ./rdmp install localhost RDMP_ -e -D -u SA -p "<YourStrong@Passw0rd>"
  13. ./rdmp gui

Build

Building on Windows

You can build RDMP from the command line using dotnet build or through an IDE e.g. Visual Studio or Visual Studio Code (Requires latest dotnet SDK).

The Windows client:

  1. dotnet build
  2. cd Application\ResearchDataManagementPlatform\bin\Debug\net6.0-windows\win-x64
  3. ./ResearchDataManagementPlatform.exe

The console client:

  1. dotnet build
  2. cd Tools\rdmp\bin\Debug\net6.0\
  3. ./rdmp.exe --help

Building on Linux

Only the console client can be built/run in Linux

  1. cd Tools/rdmp
  2. dotnet build
  3. cd bin/Debug/net6.0
  4. ./rdmp --help

Tests

To run tests you will need an instance of SQL Server. These instructions use LocalDb which is an optional installable package in Visual Studio. See Tests.md for more information on setting up LocalDb, testing on linux or using an alternate server as well as information on the types of tests included and how to write new ones.

  1. dotnet test ./scripts/run-all-tests.proj -c Release -p:BuildInParallel=false

Contributing

We welcome all contributions including:

PipelineExample_1649129092458.pptx
QueryBuilderDiagrams_1649129092768.pptx
CohortBuilder_1649129093048.pptx
Extracting Data_1649129093738.pptx
MainUI_1649129094259.pptx
Anonymisation_1649129096722.pptx
DQEDiagram_1649129096868.pptx
DataExtractionModel_1649129096994.pptx
DataLoad_1649129097281.pptx
GovernancePeriods_1649129097368.pptx
PasswordsAndAuthentication_1649129097445.pptx
PlatformDatabases_1649129097856.pptx
RDMPUniverse_1649129097959.pptx
flowchart_1649129099037.pptx
QueryBuildinginRDMP_1649129092903.docx
UserManual_1649129096160.docx
CSVUnescapedFreeTextDiagram_1649129082640.pptx
DataTableUploadDestination_1649129083258.pptx
TestCategories_1649129084732.pptx
AliasResolutionUseCase_1649129085868.pptx
KVPAttacher_1649129086101.pptx
RDMP Presentation_1649129088605.pptx
RDMP Presentation2_1649129091055.pptx
DemandsPipeline_1649129092369.pptx
AliasHandler_1649129085759.docx
KVPAttacher_1649129086014.docx
flowchart_1649751996227.pptx
RDMPUniverse_1649751994962.pptx
Anonymisation_1649751994061.pptx
DQEDiagram_1649751994279.pptx
DataExtractionModel_1649751994352.pptx
DataLoad_1649751994458.pptx
GovernancePeriods_1649751994661.pptx
PasswordsAndAuthentication_1649751994760.pptx
PlatformDatabases_1649751994867.pptx
UserManual_1649751993529.docx
Extracting Data_1649751992911.pptx
MainUI_1649751993097.pptx
DemandsPipeline_1649751992040.pptx
PipelineExample_1649751992058.pptx
QueryBuilderDiagrams_1649751992151.pptx
CohortBuilder_1649751992450.pptx
QueryBuildinginRDMP_1649751992285.docx
RDMP Presentation2_1649751990868.pptx
KVPAttacher_1649751990003.pptx
RDMP Presentation_1649751990321.pptx
AliasResolutionUseCase_1649751989805.pptx
AliasHandler_1649751989683.docx
KVPAttacher_1649751989896.docx
TestCategories_1649751987513.pptx
DataTableUploadDestination_1649751983807.pptx
CSVUnescapedFreeTextDiagram_1649751981771.pptx