cerif 1.5 tutorial

42
www.eurocris.org CERIF 1.5 Tutorial November 13 th , 2013 euroCRIS Membership Meeting Porto, Portugal cfExpert ise AndSkill s cfEquipm ent cfFundin g cfFacili ty cfServic e cfCitati on cfEvent cfLangua ge cfCurren cy cfCountr y cfCurric ulum Vitae cfPrize cfQualif ication cfGeogra phic Bounding Box cfPostalA ddress cfElectronicA ddress cfPerson cfProjec t cfOrgani sation Unit cfResult Patent cfResult Publicat ion cfResultP roduct cfIndica tor cfMeasurem ent cfFedera ted Identifi er

Upload: ciro

Post on 25-Feb-2016

42 views

Category:

Documents


0 download

DESCRIPTION

cfFederated Identifier. cfGeographic BoundingBox. cfEquipment. cfFunding. cfFacility. cfService. cfCitation. cfEvent. cfExpertise AndSkills. CERIF 1.5 Tutorial. cfQualification. cfOrganisation Unit. cfResultPatent. cfResult Publication. cfResultProduct. cfPerson. cfProject. - PowerPoint PPT Presentation

TRANSCRIPT

Page 1: CERIF 1.5 Tutorial

CERIF 1.5 Tutorial

November 13th, 2013euroCRIS Membership

MeetingPorto, Portugal

cfExpertiseAndSkills

cfEquipmentcfFunding

cfFacility

cfService

cfCitation

cfEventcfLanguage cfCurrency

cfCountry

cfCurriculumVitae

cfPrize

cfQualification

cfGeographicBoundingBox

cfPostalAddress

cfElectronicAddress

cfPerson

cfProject

cfOrganisation

Unit

cfResultPatent

cfResultPublication

cfResultProduct

cfIndicator cfMeasurement

cfFederated Identifier

Page 2: CERIF 1.5 Tutorial

Jan Dvořák [email protected]

euroCRIS• CERIF TG Leader since 2013• CRIS2012 (Prague, June 2012) Organizer

Charles University in Prague• Faculty of Arts

– Institute of Information Studies & Librarianship

InfoScience Praha• Research & Development & Innovation Information System

(the national CRIS for CZ)

___Most slides by Brigitte Jörg

www.eurocris.orgwww.eurocris.org

Page 3: CERIF 1.5 Tutorial

What is Research Information?

Information about:• Researchers• Organisations (Research-performing, Funding)• Funding Programmes, Calls• Projects (Proposed, Ongoing, Completed)• Publications, Patents, Data, Products• Facilities, Equipment, Services• Addresses, Geographic Bindings, Languages

• And their Relationships

www.eurocris.orgwww.eurocris.org

Page 4: CERIF 1.5 Tutorial

Who needs Research Information?www.eurocris.orgwww.eurocris.org

Research Informati

on

Funding Organisations

Researchers

Research Organisations

Decision Makers

Project Managers

Publishers

Enterprises

Intermediaries / Brokers

Media

Educators

General Public

visibility, finding collaborations, competitors, CV generation

performance, strategic

decisions, priorities,

comparisons

integration of relevant findings into lectures

and trainingfinding research results of

potential market or innovative value

distribution andcommunication

information and education,interest

finding reviewers, editors

distribution of programsevaluation of results, finding reviewers

finding information for participation in projects, partnerships, usage of results

integration and interoperabilitystrategic management

overview of ongoing activities

Librariesacquisition, dissemination

Page 5: CERIF 1.5 Tutorial

Kinds of questions we want to supportwww.eurocris.orgwww.eurocris.org

• How many articles has author X published in 2011 as a first author?

• How many times have articles by author X been cited by the end of the previous year?

• Did author X publish with institutionally external authors?• In how many FP7 projects does/did organisation Z participate?• How many publications have resulted from project Y?• How many people have been employed in the course of FP7

projects from the 1st call in the New Member States?• How many PhD students have participated in national research

projects in country C? In which countries have they earned their masters degrees?

• How many women have been involved in FP7 projects?• How often have articles in journal A been requested in 2010?• How many articles have been published in field B?

Page 6: CERIF 1.5 Tutorial

The Ultimate Answer:Common European Research Information Format

www.eurocris.orgwww.eurocris.org

Equipment

ProjectProject OrganisationOrganisation

Service

Funding

Patent

Skills

CV

Product

Event

PersonPerson

Classification(Semantics )Classification(Semantics )

Publication

Page 7: CERIF 1.5 Tutorial

The CERIF Evolutionwww.eurocris.orgwww.eurocris.org

EU Working Group on Research DatabasesWorkshop

1987 1991

CERIF 91

PROJECT

Similar IdeasUN/UNESCOOECDCODATA

Acronym: ERGOParticipant: Keith Jeffery, Anne Asser son, many moreOrganisations: Rutherford Appleton, Uni- versity of Bergen, …

2000

CLASSIFICATION

RESULTS EQUIPMENT

PROJECT

OrgUnit PERSON

EXPERTISERoles

CERIF 2000 Model

- Networking of DBs- Exchange of Records

- EC Recommendation to Member States

- Data Model - Multilinguality- Controlled Vocabulary- Roles / Types- User-driven

- EC Recommendation to Member States

ProjectProject OrganisationOrganisation

Service

Funding Programme

Patent

Skills

CV

Product

Event

PersonPerson

Classification(Semantics)

Classification(Semantics)

PublicationEquipment

2ndLevel Base

LanguageSemantics Link

CERIF 2006 / 2008 Model

- Data Model- Model Normalization - Robust/Consistent Structure - Extensible Structure - Semantic Layer - XML Exchange Specification- Elaboration on Publication- CERIF Core Semantics (2008 1.2)

2006 2008 2012

Measurement GEO

Citation

CV

Prize

Qualification

ExpertiseAndSkills

EquipmentFacility

Funding

Service

ElectronicAddresse

PostalAddress

Country

CurrencyLanguage

Event

Metrics

ResultProduct

ResultPublication

ResultPatent ResultProduct

ResultPublicationResultPublication

ResultPatent

Person OrganisationUnit

Project

PersonPerson OrganisationUnitOrganisationUnit

ProjectProject

Indicator Measurement

2ndLevel Base

CERIF 1.3

Semantics LanguageLink

Infrastructure

- Data Model- Infrastructure - Facility, Equipment, Service- Measurement & Indicator - Entities and Link Tables- Geographic Bounding Box- CERIF 1.3 Vocabulary - UUIDs - Terms - Schemes- CERIF 1.4 new XML format- CERIF 1.5 Federated Identifiers

CERIF 1.5CERIF 1.4 (XML)

CERIF 1.3

FOR MA L

SEMANT ICS

+ Linked Data

Page 8: CERIF 1.5 Tutorial

Common European Research Information Format

CERIF is an EU Recommendation to Member Stateshttp://cordis.europa.eu/cerif/

The European Commission (EC) has authorised euroCRIS to maintainand develop CERIF and its usage http://www.eurocris.org/Index.php?page=CERIFreleases&t=1

www.eurocris.org

Page 9: CERIF 1.5 Tutorial

Model Levelswww.eurocris.orgwww.eurocris.org

• Conceptual Level (Specification) Concepts relevant for the research domainand their relationships

• Logical Level (ER Model)Entities and their relationships

• Physical Level (Database Scripts)Data Definition commands for the database

• Semantic Layer (Declared Semantics)A formalized controlled vocabulary describing ageneral contextual semantics of the research domaininline with the conceptual, logical and machine description

Equipment

ProjectProjectOrganisationOrganisation

Service

Funding

Patent

Skills

CV

Product

Event

PersonPerson

Classification

(Semantics )

Classification

(Semantics )

Publication

SQL Script-----------------------------CREATE Table cfPers (...);CREATE Table cfProj (...);CREATE Table cfOrgUnit (...);

Page 10: CERIF 1.5 Tutorial

CERIF Model Structure (Views)www.eurocris.orgwww.eurocris.org

CERIF Entity Types• Base Entities• Result Entities • Infrastructure Entities• 2nd Level Entities• Geographic Bounding Box• Link Entities

CERIF Features• Multiple Language • Semantics• Measures & Indicators

Page 11: CERIF 1.5 Tutorial

CERIF Base Entitieswww.eurocris.orgwww.eurocris.org

Person OrganisationUnit

Project

PersonPerson OrganisationUnitOrganisationUnit

ProjectProject

Page 12: CERIF 1.5 Tutorial

CERIF Base Entitieswww.eurocris.orgwww.eurocris.org

PersonIDURIGenderFirstNamesOtherNamesFamilyNamesNameVariantsResearchInterestKeywords

ProjectIDURIAcronymStartDateEndDateTitleAbstractKeywords

OrganisationUnitIDURIAcronymNameHeadCountCurrencyCodeTurnoverResearchActivityKeywords

Person OrganisationUnit

Project

PersonPerson OrganisationUnitOrganisationUnit

ProjectProject

Page 13: CERIF 1.5 Tutorial

CERIF Base Entitieswww.eurocris.orgwww.eurocris.org

cfOrganisationUnitcfIDcfURIcfAcronymcfHeadCountcfCurrencyCodecfTurnover

Person OrganisationUnit

Project

PersonPerson OrganisationUnitOrganisationUnit

ProjectProject

cfTitle

cfAbstract

cfKeywords

cfName

cfDescr

iption

cfKeywo

rds

cfDescription

cfKeywords

cfFamil

yNames

cfFirst

Names

cfOther

Names

cfNameV

ariants

cfPersoncfIDcfURIcfGendercfBirthdate

cfProjectcfIDcfURIcfAcronymcfStartDatecfEndDate

Page 14: CERIF 1.5 Tutorial

CERIF Result Entitieswww.eurocris.orgwww.eurocris.org

ResultProduct

ResultPublication

ResultPatent ResultProduct

ResultPublicationResultPublication

ResultPatent

Page 15: CERIF 1.5 Tutorial

CERIF Result Entitieswww.eurocris.orgwww.eurocris.org

ResultProductIDURI

ResultPublicationIDURITitleSubtitleAbstractBibl. NotePublicationDateTotalPagesStartPageEndPageKeywords ResultPatent

IDURIPatentNumberTitleCountryCodeRegistrationDateApprovalDateDescriptionKeywords

ResultProduct

ResultPublication

ResultPatent ResultProduct

ResultPublicationResultPublication

ResultPatent

Page 16: CERIF 1.5 Tutorial

CERIF Result Entitieswww.eurocris.orgwww.eurocris.org

cfResultPublicationcfIDcfURIcfNumbercfPublicationDatecfStartPagecfEndPagecfTotalPagescfEditioncfSeriescfIssuecfVolumecfISBNcfISSN

cfResultPatentcfIDcfURIcfPatentNumbercfCountryCodecfRegistrationDatecfApprovalDate

ResultProduct

ResultPublication

ResultPatent ResultProduct

ResultPublicationResultPublication

ResultPatent

cfTitle

cfAbstract

cfKeywords

cfSubtitle

cfVersionInfo

cfVersionInfo

cfBibliographic Note

cfAbbreviation

cfDescription

cfKeywords

cfName

cfResultProductcfIDcfURI

cfVersionInfo

cfAbstract

cfKeywords

cfName

Page 17: CERIF 1.5 Tutorial

CERIF Infrastructure Entitieswww.eurocris.orgwww.eurocris.org

Equipment

Facility

Service

Page 18: CERIF 1.5 Tutorial

CERIF Infrastructure Entitieswww.eurocris.orgwww.eurocris.org

FacilityIDAcronymURITitleDescriptionKeywords

ServiceIDAcronymURITitleDescriptionKeywords

EquipmentIDAcronymURITitleDescriptionKeywords

Equipment

Facility

Service

Page 19: CERIF 1.5 Tutorial

CERIF Infrastructure Entitieswww.eurocris.orgwww.eurocris.org

cfServicecfIDcfURIcfAcronym

cfEquipmentcfIDcfURIcfAcronym

Equipment

Facility

Service

cfFacilitycfIDcfURIcfAcronym

cfName

cfDescriptio

n

cfKeywords

cfName

cfDescription

cfKeywords

cfName

cfDescription

cfKeywords

Page 20: CERIF 1.5 Tutorial

CERIF 1.5

cfExpertiseAndSkills

cfEquipmentcfFunding

cfFacility

cfService

cfCitation

cfEventcfLanguage cfCurrency

cfCountry

cfCurriculum

Vitae

cfPrize

cfQualification

cfGeographic

BoundingBox

cfPostalAddress

cfElectronicAddress

cfPerson

cfProject

cfOrganisation

Unit

cfResultPatent

cfResultPublication

cfResultProduct

cfIndicator cfMeasurement

cfFederated Identifier

www.eurocris.org

Page 21: CERIF 1.5 Tutorial

Measuring Impact in CERIF (MICE)www.eurocris.orgwww.eurocris.org

MICE, a JISC-funded Project coordinated by Richard Gartner, Kings College, London, UK

Page 22: CERIF 1.5 Tutorial

CERIF Measurement & Indicatorwww.eurocris.orgwww.eurocris.org

cfMeasureIdentifiercfCountIntegercfCountIntegerChangecfValueFloatingPointcfCountFloatingPointChangecfValueJudgementalNumericcfValueJudgementalNumericChangecfValueJudgementalTextcfValueJudgementalTextChangecfURI

Is an Aggregation Entity

Page 23: CERIF 1.5 Tutorial

Measurement & Indicator (some examples)

– economic and commercial• economic

– impact on business » improving performance of existing businesses

• increased turnover by 1.2M€ in 2012 • time savings of 14.56%• reduced costs by 42%

» new products/processes• creating numbers of new products/services • commercialising / other success measures

www.eurocris.org

Indicator

Measurement

Extract from the MICE List of Indicators

Page 24: CERIF 1.5 Tutorial

CERIF 1.5

cfExpertiseAndSkills

cfEquipmentcfFunding

cfFacility

cfService

cfCitation

cfEventcfLanguage cfCurrency

cfCountry

cfCurriculum

Vitae

cfPrize

cfQualification

cfGeographic

BoundingBox

cfPostalAddress

cfElectronicAddress

cfPerson

cfProject

cfOrganisation

Unit

cfResultPatent

cfResultPublication

cfResultProduct

cfIndicator cfMeasurement

cfFederated Identifier

www.eurocris.org

Page 25: CERIF 1.5 Tutorial

CERIF – Generic Entity Structurewww.eurocris.orgwww.eurocris.org

Generic

IdentifierURIAttributes

Multilingual EntitiesRelationships (Links)

Page 26: CERIF 1.5 Tutorial

Some CERIF Link Entitieswww.eurocris.orgwww.eurocris.org

Person

OrganisationUnit

Project

ResultPublication

Person_ResultPublication

Person_Project

OrganisationUnit_ResultPublication

Project_ResultPublication

Project_OrganisationUnit

Person_OrganisationUnitPersonPerson

OrganisationUnitOrganisationUnit

ProjectProject

ResultPublicationResultPublication

Person_ResultPublication

Person_Project

OrganisationUnit_ResultPublication

Project_ResultPublication

Project_OrganisationUnit

Person_OrganisationUnit

Citation

CV

Prize

Qualification

ExpertiseAndSkills

Equipment

Facility

Funding

Service

ElectronicAddresse

PostalAddress

Country

CurrencyLanguage

Event

Metrics

ResultProduct

ResultPublication

ResultPatent ResultProduct

ResultPublicationResultPublication

ResultPatent

Person OrganisationUnit

Project

PersonPerson OrganisationUnitOrganisationUnit

ProjectProject

Indicator Measurement

Geographic Bounding Box

Page 27: CERIF 1.5 Tutorial

Some CERIF Link Entitieswww.eurocris.orgwww.eurocris.org

Person

OrganisationUnit

Project

ResultPublication

Person_ResultPublication

Person_Project

OrganisationUnit_ResultPublication

Project_ResultPublication

Project_OrganisationUnit

Person_OrganisationUnitPersonPerson

OrganisationUnitOrganisationUnit

ProjectProject

ResultPublicationResultPublication

Person_ResultPublication

Person_Project

OrganisationUnit_ResultPublication

Project_ResultPublication

Project_OrganisationUnit

Person_OrganisationUnit

role=author

role=principal investigator

role=research assistant

role=deliverable

role=author‘s affiliation

role=coordinator

Citation

CV

Prize

Qualification

ExpertiseAndSkills

Equipment

Facility

Funding

Service

ElectronicAddresse

PostalAddress

Country

CurrencyLanguage

Event

Metrics

ResultProduct

ResultPublication

ResultPatent ResultProduct

ResultPublicationResultPublication

ResultPatent

Person OrganisationUnit

Project

PersonPerson OrganisationUnitOrganisationUnit

ProjectProject

Indicator Measurement

Geographic Bounding Box

Page 28: CERIF 1.5 Tutorial

Some CERIF Link Entitieswww.eurocris.orgwww.eurocris.org

Page 29: CERIF 1.5 Tutorial

Result_Publication Instance Diagram(slide by Keith Jeffery)

www.eurocris.orgwww.eurocris.org

Person A

Publication X

OrgUnit O

OrgUnit M

OrgUnit N

Project P

member

member

employee

Part of

Part of

owns IPRauthor

Project leader

Page 30: CERIF 1.5 Tutorial

CERIF Semantic Layerwww.eurocris.orgwww.eurocris.org

Allows to capture any Schema or Structure• Flat Lists• Thesauri• Classification Systems (e.g. SKOS, ...)• Taxonomies• OntologiesOpen / Extensible in all directions• New Schemas• New Concepts / Terms• New RelationshipsEnables to manage• Roles / Types Semantics• Subject Headings • Archiving (Time component)

Allows for simple Mappings between Schemes

Page 31: CERIF 1.5 Tutorial

CERIF Semantic Layer (Declared Semantics)www.eurocris.orgwww.eurocris.org

Recursionis-a

maps-tois-part-of

Is-broader-term

Scheme-Assignment

Time-based

Page 32: CERIF 1.5 Tutorial

CERIF 1.5

cfExpertiseAndSkills

cfEquipmentcfFunding

cfFacility

cfService

cfCitation

cfEventcfLanguage cfCurrency

cfCountry

cfCurriculum

Vitae

cfPrize

cfQualification

cfGeographic

BoundingBox

cfPostalAddress

cfElectronicAddress

cfPerson

cfProject

cfOrganisation

Unit

cfResultPatent

cfResultPublication

cfResultProduct

cfIndicator cfMeasurement

cfFederated Identifier

www.eurocris.org

Page 33: CERIF 1.5 Tutorial

CERIF Federated Identifiers

• ResultPublication– DOI–WoS Accession Number

• Person– Social Security Number– Staff Id in HR system– Author identifier

• ORCID• ScopusID

• Project/Grant– Funder’s

reference number• Organisation– VAT Identification

Number– Internal Code– FundId

• Classification– External Code

www.eurocris.org

Page 34: CERIF 1.5 Tutorial

CERIF Federated Identifiers

• Records the “tag” by which an object is known elsewhere

• For any Base, Result, Infrastructure, or 2nd Level entity

• Connected to a Service representing the context:– The issuer of the identifier• Usually an information system

www.eurocris.org

Page 35: CERIF 1.5 Tutorial

CERIF XML 1.5 Interchange Formatwww.eurocris.orgwww.eurocris.org

For point-to-point interchange XML namespace XML Schema

Based on the ER modelcfExpertiseAndSkills

cfEquipmentcfFunding

cfFacility

cfService

cfCitation

cfEventcfLanguage cfCurrency

cfCountry

cfCurriculumVitae

cfPrize

cfQualification

cfGeographicBoundingBox

cfPostalAddress

cfElectronicAddress

cfPerson

cfProject

cfOrganisation

Unit

cfResultPatent

cfResultPublication

cfResultProduct

cfIndicator cfMeasurement

cfFederated Identifier

Page 36: CERIF 1.5 Tutorial

CERIF 1.5 XML Interchange Formatwww.eurocris.orgwww.eurocris.org

<CERIF xmlns=“urn:xmlns:org:eurocris:cerif-1.5-1”><cfProj>

<cfProjId>internal-project-identifier</cfProjId><cfAcro>ACRO</cfAcro><cfURI>http://www.project-url.ac.uk/acro.html</cfURI><cfTitle cfLangCode="en" cfTrans="o">The title of the project</cfTitle><cfAbstr cfLangCode=”en" cfTrans="o">The goals of the project</cfAbstr>

<cfProj_Class><cfClassId>infrastructure-project-uuid</cfClassId><cfClassSchemeId>-project-types-scheme-uuid</

cfClassSchemeId></cfProj_Class><cfProj_OrgUnit>

<cfOrgUnitId>orgunit-1-identifier</cfOrgUnitId><cfClassId>coordinator-uuid</cfClassId><cfClassSchemeId>orgunit-project-roles-scheme-uuid</

cfClassSchemeId><cfStartDate>from-datetime</cfStartDate><cfEndDate>to-datetime</cfEndDate>

</cfProj_OrgUnit></cfProj>

</CERIF>

Page 37: CERIF 1.5 Tutorial

CERIF 1.5 Releasewww.eurocris.orgwww.eurocris.org

CERIF Model Introduction and Specification coming CERIF XML Data Exchange Format Specification ✓ CERIF Formal Semantics (Vocabulary) ✓ CERIF SQL Scripts ✓(euroCRIS members only)

CERIF XML Schemas ✓ CERIF XML Examples ✓ CERIF Semantics (Excel) ✓

Page 38: CERIF 1.5 Tutorial

Ongoing Activities: CERIF 1.6www.eurocris.orgwww.eurocris.org

• Model Cleaning• Research Data• Cross-TG Activities• Linked Open Data TG• Institutional Repositories TG• Architectures TG• Indicators TG• Best Practice TG

• Cooperation with• CASRAI• VIVO• RDA• ORCID

cfExpertise

AndSkills

cfEquipment

cfFunding

cfFacility

cfService

cfCitation

cfEvent cfLanguage cfCurrency

cfCountry

cfCurriculum

Vitae

cfPrize

cfQualification

cfGeographic

BoundingBox

cfPostalAddress

cfElectronicAddress

cfPerson

cfProject

cfOrganisationUnit

cfResultPatent

cfResultPublication

cfResultProduct

cfIndicator cfMeasurement

cfFederated Identifier

Page 39: CERIF 1.5 Tutorial

What makes CERIF shine

• Right level of abstraction• Normalized model– Record data only once– Reference rather than copy

• Versatile Semantic Layer• Time-based relationships• Clean design, regular structure

www.eurocris.org

Page 40: CERIF 1.5 Tutorial

What is a CRIS?www.eurocris.orgwww.eurocris.org

… information about

• Researchers• Organisations (Research-

performing, Funding)• Funding Programmes, Calls• Projects• …

… that means

• of current

interest• not

necessarily ongoing

… driven by

• Concepts• Model

• Implementation (Information System)

Current Research Information System

an integrated approach towards managing research information

= CRIS

CERIF

Page 41: CERIF 1.5 Tutorial

CRIS and Repositories at an institution(slide by Keith Jeffery)

www.eurocris.orgwww.eurocris.org

CRISResearch Context

[projects, persons, organisational unitsfunding, products, patents, publications

facilities, equipment, events]

OA Repository(hypermedia) Documents

e-Research repositoryDatasets and Software

OAI-PMH

Variousprotocols

End-User

CERIFCERIF

Page 42: CERIF 1.5 Tutorial

www.eurocris.org

International Council for Science;Commission on Data Access

European Association of Research Managers and Administrators

All European Academies

www.eurocris.org