TT03 A Primer on Converting Analysis Results Data to RDF Data Cubes using Free and Open Source Tools

From PHUSE Wiki
Jump to: navigation, search

This page contains supporting materials for the PhUSE 2014 paper: "TT03 A Primer on Converting Analysis Results Data to RDF Data Cubes using Free and Open Source Tools" by Tim Williams. Please see the 2014 Conference Proceedings for the paper and presentation.

Note on file downloads:

 File extensions like .TTL, .JSON and others are not allowed as file extensions on the PhUSE Wiki.  
 As a result you will need to remove the extra ".TXT" extension present on many of the files on this page.

Companion Documents

File Description
File:TT03 CompanionDoc-OpenRefine-InstallInstructions.docx Instructions for installing OpenRefine on the Windows OS
File:TT03 CompanionDoc-OpenRefine-CubeWorkbook.docx Workbook for creating the RDF Data Cube using OpenRefine. Step-by-step data import, cube skeleton creation, data export.

Data

File Description
File:Demog3DimSource.csv.txt Source Data

JSON Skeleton

File Description
File:Demog3Dim.JSON.TXT Cube skeleton for OpenRefine, prior to defining and attaching observations. Remove ".TXT" after download.


Ruby Code

File Description
File:Demog3dim.rb.txt Ruby script for creating cube demog3Dim_p.ttl using Publisci gem


Data Cubes

File Description
File:Demog3Dim p.ttl.TXT RDF Data Cube created using Ruby Publisci
File:Demog3Dim.ttl.TXT RDF Data Cube created using OpenRefine

SPARQL Queries

File Description
File:Demog3DimPlcFemale.rq.TXT SPARQL Query: number of females in placebo treatment arm
File:Demog3DimAllFemale.rq.TXT SPARQL Query: number of females in study (all treatment arms)

Contact Information

Work email Tim.Wiliams@ucb.com
LinkedInLogo.png
http://www.linkedin.com/in/timpwilliams/