Dictionary Mapping Specification

The SDD is made up of several tables, including the Dictionary and Code Mapping tables, the Timeline, and the Codebook.

Dictionary Mapping

The bulk of the annotation is done using the Dictionary Mapping Table, which is used to annotate the columns of a given dataset. The SDD DM Specification is shown below.

DM Column	Related Property	Description
Attribute	rdf:type	Class of attribute entry
attributeOf	sio:isAttributeOf	Entity having the attribute
Column		Entry column header in dataset
Comment	rdfs:comment	Comment for the entry
Definition	skos:definition	Entry text definition
Entity	rdf:type	Class of entity entry
Format		Specifies the structure of the Unit value
inRelationTo	sio:inRelationTo	Entity that the role is linked to
Label	rdfs:label	Label for the entry
Relation		Custom relation that replaces inRelationTo
Role	sio:hasRole	Type of the role of the entry
Time	sio:existsAt	Time point of measurement
Unit	sio:hasUnit	Unit of Measure for entry
wasDerivedFrom	prov:wasDerivedFrom	Entity from which the entry was derived
wasGeneratedBy	prov:wasGeneratedBy	Activity from which the entry was produced

An example Dictionary Mapping from the CHEAR project is provided below.

Column	Attribute	attributeOf	Entity	Unit	Time	Role	inRelationTo	wasDerivedFrom
id	sio:Identifier	??child					??study
race	sio:Race	??mother
age	sio:Age	??mother		sio:Year	??visit1
edu	chear:EducationLevel	??mother			??visit2
insur	chear:InsuranceType	??mother			??visit3
urineam_3	sio:Quality	??sample3			??visit3
t1bmi	chear:BMI	??mother		kg/m2	??visit1			t1weight, ??height
t1weight	chear:Weight	??mother		kg	??visit1
smoke	chear:SmokingStatus	??mother			??pregnancy
birthwt	chear:Weight	??child		g	??birth
??height	sio:Height	??mother
??mother			sio:Human			chear:Mother	??child
??child			sio:Human			chear:Child	??mother
??birth			sio:Birthing				??child
??pregnancy			chear:PregnancyPeriod				??birth
??conception			chear:Conception				??child
??sample3			U					??mother