CERIF 1.5 Tutorial

1. cfFederated Identifier cfGeographicBoundingBox cfEquipment cfFunding cfFacility cfService cfCitation cfEvent cfExpertise AndSkills CERIF 1.5 Tutorial cfQualification cfOrganisation Unit cfResultPatent cfResultPublication cfResultProduct cfPerson cfProject cfElectronicAddress cfPrize cfPostalAddress cfCurriculumVitae November 5th, 2012 euroCRISMembership MeetingMadrid, Spain cfIndicator cfMeasurement cfCountry cfLanguage cfCurrency

2. www.eurocris.org www.eurocris.org Slides Author Brigitte Jörg M.A. Information Science Information Systems, Business Economics CERIF Support Project – National Co-ordinator Innovation Support Center, UKOLN, University of Bath, Bath, UK CERIF TG Leader, Board Member euroCRIS, non-profit organization registered in the Netherlands Contact: b.joerg@ukoln.ac.uk

3. www.eurocris.org www.eurocris.org Introduction of the Speaker Jan Dvořák euroCRIS • CERIF TG Deputy Lead • CRIS2012 (Prague, June 2012) Organizer Charles University in Prague • Faculty of Arts • Institute of Information Studies & Librarianship InfoSciencePraha • Research & Development & Innovation Information System (the national CRIS for CZ) Contact: jan.dvorak@infoscience.cz

4. www.eurocris.org www.eurocris.org 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

5. www.eurocris.org www.eurocris.org Who needs Research Information? performance, strategicdecisions, priorities, comparisons visibility, finding collaborations, competitors, CV generation Researchers Decision Makers Funding Organisations Project Managers distributionofprogramsevaluationofresults, findingreviewers overview of ongoing activities Research Information Libraries acquisition, dissemination Research Organisations Publishers integration and interoperability strategic management findingreviewers, editors Education Intermediaries / Brokers integrationof relevant findingsintolecturesandtraining findingresearchresultsofpotential marketor innovative value General Public Media Enterprises findinginformationforparticipation in projects, partnerships, usageofresults informationandeducation, interest distributionand communication

6. www.eurocris.org www.eurocris.org Kinds of questions we want to support • How many articles has author X published in 2011 as a first author? • How many timeshave 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?

7. Funding Organisation Organisation Person Person Project Project Service Skills Publication Equipment CV Patent Classification Classification Product ( ( ) ) Semantics Semantics Event www.eurocris.org www.eurocris.org Common European Research Information Format

8. CERIF 1.5 CERIF 1.4 (XML) CERIF 1.3 www.eurocris.org www.eurocris.org The CERIF Evolution CERIF 2006 / 2008 Model CERIF 1.3 Funding Infrastructure Equipment Similar Ideas UN/UNESCO OECD CODATA Facility Link Base Base Link ExpertiseAndSkills Measurement GEO Semantics Semantics Language Language 2ndLevel 2ndLevel Service Qualification FOR MA L SEMANT IC S EU Working Group on Research Databases Workshop CERIF 2000 Model Prize ElectronicAddresse Roles EXPERTISE OrgUnit PERSON • - Data Model • Infrastructure - Facility, Equipment, Service • - Measurement & Indicator • - Entities and Link Tables • GeographicBounding Box- CERIF 1.3 Vocabulary • - UUIDs - Terms - Schemes • - CERIF 1.4 new XML format • - CERIF 1.5 FederatedIdentifiers CV CERIF 91 PostalAddress PROJECT RESULTS EQUIPMENT PROJECT CLASSIFICATION Citation Acronym: ERGO Participant: Keith Jeffery, Anne Asser son, many more Organisations: Rutherford Appleton, Uni- versity of Bergen, … • - Data Model • Model Normalization • - Robust/ConsistentStructure • - Extensible Structure • - SemanticLayer • XML Exchange Specification- Elaboration on Publication • CERIF CoreSemantics (2008 1.2) • Data Model - Multilinguality- ControlledVocabulary- Roles / Types- User-driven • EC Recommendationto Member States Metrics Indicator Measurement Country • - Networking of DBs • Exchange of Records • EC Recommendation to Member States Event Language Currency + Linked Data 2012 2006 2008 1987 1991 2000

9. www.eurocris.org CommonEuropeanResearchInformation Format • CERIF is an EU Recommendation to Member Stateshttp://cordis.europa.eu/cerif/ • The European Commission (EC) has authorisedeuroCRIS to maintainand develop CERIF and its usage http://www.eurocris.org/Index.php?page=CERIFreleases&t=1

10. Funding Organisation Organisation Person Person Project Project Service Skills Publication Equipment CV Patent Classification Classification Product ( ( ) ) Semantics Semantics Event www.eurocris.org www.eurocris.org Model Levels • 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 (DeclaredSemantics)A formalized controlled vocabulary describing ageneral contextual semantics of the research domaininline with the conceptual, logical and machine description SQL Script ----------------------- CREATE Table cfPers CREATE Table cfProj CREATE Table cfOrgUnit

11. www.eurocris.org www.eurocris.org CERIF Model Structure (Views) • CERIF EntityTypes • Base Entities • Result Entities • Infrastructure Entities • 2nd Level Entities • Link Entities • CERIF Features • Multiple Language • Semantics • Measures & Indicators • GeographicBounding Box

12. www.eurocris.org www.eurocris.org CERIF Base Entities

13. Person ID URI Gender FirstNames OtherNames FamilyNames NameVariants ResearchInterest Keywords Project ID URI Acronym StartDate EndDate Title Abstract Keywords OrganisationUnit ID URI Acronym Name HeadCount CurrencyCode Turnover ResearchActivity Keywords www.eurocris.org www.eurocris.org CERIF Base Entities

14. cfPerson cfID cfURI cfGender cfBirthdate cfProject cfID cfURI cfAcronym cfStartDate cfEndDate cfOrganisationUnit cfID cfURI cfAcronym cfHeadCount cfCurrencyCode cfTurnover www.eurocris.org www.eurocris.org CERIF Base Entities cfTitle cfAbstract cfKeywords cfFamilyNames cfFirstNames cfName cfDescription cfOtherNames cfDescription cfKeywords cfNameVariants cfKeywords

15. www.eurocris.org www.eurocris.org CERIF Result Entities

16. ResultPublication ID URI Title Subtitle Abstract Bibl. Note PublicationDate TotalPages StartPage EndPage Keywords ResultPatent ID URI PatentNumber Title CountryCode RegistrationDate ApprovalDate Description Keywords ResultProduct ID URI www.eurocris.org www.eurocris.org CERIF Result Entities

17. cfResultPublication cfID cfURI cfNumber PublicationDate cfStartPage cfEndPage cfTotalPages cfEdition cfSeries cfIssue cfVolume cfISBN cfISSN cfResultPatent cfID cfURI cfPatentNumber cfCountryCode cfRegistrationDate cfApprovalDate cfResultProduct cfID cfURI www.eurocris.org www.eurocris.org CERIF Result Entities cfTitle cfBibliographic Note cfSubtitle cfAbstract cfVersionInfo cfKeywords cfAbbreviation cfName cfName cfDescription cfAbstract cfKeywords cfKeywords cfVersionInfo cfVersionInfo

18. www.eurocris.org www.eurocris.org CERIF Infrastructure Entities Equipment Facility Service

19. Service ID Acronym URI Title Description Keywords Equipment ID Acronym URI Title Description Keywords Facility ID Acronym URI Title Description Keywords www.eurocris.org www.eurocris.org CERIF Infrastructure Entities Equipment Facility Service

20. cfService cfID cfURI cfAcronym cfEquipment cfID cfURI cfAcronym cfFacility cfID cfURI cfAcronym www.eurocris.org www.eurocris.org CERIF Infrastructure Entities cfName cfDescription Equipment Facility cfKeywords Service cfName cfDescription cfName cfKeywords cfDescription cfKeywords

21. www.eurocris.org cfFederated Identifier CERIF 1.5 cfFunding cfEquipment cfEvent cfGeographicBoundingBox cfService cfCitation cfFacility cfExpertise AndSkills cfQualification cfResultProduct cfResultPublication cfOrganisation Unit cfPerson cfResultPatent cfProject cfElectronicAddress cfPrize cfPostalAddress cfCurriculumVitae cfIndicator cfMeasurement cfCountry cfLanguage cfCurrency

22. www.eurocris.org www.eurocris.org Measuring Impact in CERIF (MICE) MICE, a JISC-funded Project coordinated by Richard Gartner, Kings College, London, UK

23. www.eurocris.org www.eurocris.org CERIF Measurement & Indicator Is an Aggregation Entity cfMeasureIdentifier cfCountInteger • cfCountIntegerChange cfValueFloatingPoint • cfCountFloatingPointChange cfValueJudgementalNumeric cfValueJudgementalNumericChange cfValueJudgementalText cfValueJudgementalTextChange cfURI

24. www.eurocris.org Measurement & Indicator (some examples) • economic and commercial • economic • impact on business • improving performance of existing businesses • increased turnover • time savings • reduced costs • new products/processes • Creating • numbers of new products/services • commercialising • success measures Indicator Measurement Extract from the MICE List of Indicators

25. www.eurocris.org Measurement & Indicator (some examples) • economic and commercial • economic • impact on business • improving performance of existing businesses • increased turnover • time savings • reduced costs • new products/processes • Creating • numbers of new products • commercialising • success measures cfIndicator cfIndicID=00123 cfMeasurement cfMeasID=012345 cfValueFloat=X cfProduct_Measurement cfResultProductID=0123456 cfMeasID=01234567 cfClassID=new-2010 cfClassSchemeID=ImpactOnBusiness cfStartDate=2010-01-01 cfEndDate=2010-12-31 cfOrganisation_Measurement cfOrgUnitID=01234 cfMeasID=012345 cfClassID=turnover cfClassSchemeID=ImpactOnBusiness cftStartDate=2010-01-01 cfEndDate=2010-12-31 cfMeasurement cfMeasID=012345678 cfCount=Z

26. www.eurocris.org Measurement & Indicator (some examples) • economic and commercial • economic • impact on business • improving performance of existing businesses • increased turnover • time savings • reduced costs • new products/processes • Creating • numbers of new products • commercialising • success measures cfIndicator cfIndicID=00123 cfMeasurement cfMeasID=012345 cfValueFloat=X cfMeasurement cfMeasID=012345678 cfValueFloat=Y X-Y cfMeasurement_Measurement cfMeasID1=012345 cfMeasID2=012345678 cfClassID=increasedTurnover cfClassSchemeID=ImpactOnBusiness cfStartDate=2010-01-01 cfEndDate=2010-12-31 cfOrganisation_Measurement cfOrgUnitID=01234 cfMeasID=012345; 012345678 cfClassID=turnover cfClassSchemeID=ImpactOnBusiness cfStartDate=2010-01-01 cfEndDate=2010-12-31

27. www.eurocris.org CERIF Federated Identifiers • Organisation • VAT Identification Number • Internal Code • ResultPublication • DOI • WoS Accession Number • Person • Social Security Number • Staff Id in HR system • Author identifier • ORCID • ScopusID

28. www.eurocris.org cfFederated Identifier CERIF 1.5 cfFunding cfEquipment cfEvent cfGeographicBoundingBox cfService cfCitation cfFacility cfExpertise AndSkills cfQualification cfResultProduct cfResultPublication cfOrganisation Unit cfPerson cfResultPatent cfProject cfElectronicAddress cfPrize cfPostalAddress cfCurriculumVitae cfIndicator cfMeasurement cfCountry cfLanguage cfCurrency

29. www.eurocris.org www.eurocris.org CERIF – Generic Entity Structure Generic Identifier URI Attributes Multilingual Entities Relationships (Links)

30. www.eurocris.org www.eurocris.org Some CERIF Link Entities Funding Equipment Facility ExpertiseAndSkills Qualification Service Prize ElectronicAddresse CV PostalAddress Citation GeographicBounding Box Metrics Indicator Measurement Country Event Language Currency

31. role=author‘saffiliation role=author role=deliverable role=researchassistant role=coordinator role=principalinvestigator www.eurocris.org www.eurocris.org Some CERIF Link Entities Funding Equipment Facility ExpertiseAndSkills Qualification Service Prize ElectronicAddresse CV PostalAddress Citation GeographicBounding Box Metrics Indicator Measurement Country Event Language Currency

32. www.eurocris.org www.eurocris.org Some CERIF Link Entities

33. www.eurocris.org www.eurocris.org CERIF – Generic Link Entity Structure Generic Applied Binary, Time-based Links with Semantics Semantic Layer Valid Time Range Contextual Roles Vocabulary

34. www.eurocris.org www.eurocris.org CERIF Modularisation ResultPublication Funding Equipment OrganisationUnit Facility ExpertiseAndSkills Qualification Project Service Prize ElectronicAddresse Funding CV PostalAddress Citation GeographicBounding Box SCHEMA 1 Metrics Indicator Measurement SCHEMA 2 Role X Country SCHEMA 3 Role Y Role A Event Role Z Role A Language Role C Currency Role B Role C Role B Semantic Layer

35. www.eurocris.org www.eurocris.org Result_Publication Instance Diagram(slide by Keith Jeffery) OrgUnit M Part of member Person A OrgUnit O employee member OrgUnit N Part of Project leader Project P author owns IPR Publication X

36. www.eurocris.org www.eurocris.org CERIF Example (Person)

37. www.eurocris.org www.eurocris.org CERIF Example (Project)

38. www.eurocris.org www.eurocris.org CERIF Semantic Layer • Allowstocaptureany Schema orStructure • Flat Lists • Thesauri • ClassificationSystems (e.g. SKOS, ...) • Taxonomies • Ontologies • Open / Extensible in all directions • New Schemas • New Concepts / Terms • New Relationships • Enablestomanage • Roles/ TypesSemantics • SubjectHeadings • Archiving(Time component) • Allowsfor simple MappingsbetweenSchemes

39. www.eurocris.org www.eurocris.org CERIF Semantic Layer (Declared Semantics) Recursion is-a maps-to is-part-of Is-broader-term Scheme-Assignment Time-based

40. www.eurocris.org www.eurocris.org CERIF Semantic Layer (Declared Semantics) CERIF / SKOS ------------------------------ Class / Concept ClassScheme / ConceptScheme class-class / broadMatch class-class / broader class-class / broaderTransitive class-class / hasTopConcept class-class / mappingRelation generic / explicit (open set) / (defined sets) Joerg, B.; Jeffery, K.G.; Van Grootel, G. (2011): Towards a Sharable Research Vocabulary – A Model-driven Approach; MTSR 2011, Izmir, Turkey.

41. www.eurocris.org cfFederated Identifier CERIF 1.5 cfFunding cfEquipment cfEvent cfGeographicBoundingBox cfService cfCitation cfFacility cfExpertise AndSkills cfQualification cfResultProduct cfResultPublication cfOrganisation Unit cfPerson cfResultPatent cfProject cfElectronicAddress cfPrize cfPostalAddress cfCurriculumVitae cfIndicator cfMeasurement cfCountry cfLanguage cfCurrency

42. www.eurocris.org CERIF Federated Identifiers • Organisation • VAT Identification Number • Internal Code • Classification • External Code • ResultPublication • DOI • WoS Accession Number • Person • Social Security Number • Staff Id in HR system • Author identifier • ORCID • ScopusID

43. www.eurocris.org 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 issuer of the identifier • Usually an information system

44. www.eurocris.org www.eurocris.org cfFederated Identifier CERIF XML 1.5 Interchange Format cfEquipment cfFunding cfFacility cfService cfCitation cfEvent cfGeographicBoundingBox cfExpertise AndSkills • Forpoint-to-point interchange • XML namespace • XML Schema • Based on theER model cfQualification cfResultProduct cfResultPublication cfPerson cfOrganisation Unit cfResultPatent cfProject cfElectronicAddress cfPrize cfPostalAddress cfCurriculumVitae cfIndicator cfMeasurement cfCountry cfLanguage cfCurrency

45. www.eurocris.org www.eurocris.org CERIF 1.5 XML Interchange Format <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> <cfTitlecfLangCode="en" cfTrans="o">The title of the project</cfTitle> <cfAbstrcfLangCode=”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>

46. www.eurocris.org www.eurocris.org CERIF 1.5 Release • CERIF Model IntroductionandSpecificationcoming • CERIF XML Data Exchange Format Specificationcoming • CERIF Formal Semantics(Vocabulary) ✓ • CERIF SQL Scripts ✓ • CERIF XML Schemas ✓ • CERIF XML Examples✓ • CERIF Semantics (Excel) ✓

47. CERIF www.eurocris.org www.eurocris.org What is a CRIS? Research Information System Current = CRIS • … thatmeans • ofcurrentinterest • not necessarilyongoing • … informationabout • Researchers • Organisations (Research-performing, Funding) • Funding Programmes, Calls • Projects • … • … drivenby • Concepts • Model • Implementation (Information System) anintegratedapproachtowardsmanagingresearchinformation

48. End-User CRIS Research Context [projects, persons, organisational units funding, products, patents, publications facilities, equipment, events] CERIF CERIF Various protocols OAI-PMH OA Repository (hypermedia) Documents e-Research repository Datasets and Software www.eurocris.org www.eurocris.org CRIS and Repositories at an institution(slide by Keith Jeffery)

49. www.eurocris.org www.eurocris.org cfFederated Identifier Ongoing Activities towards CERIF 2.0 cfEquipment cfFunding cfFacility cfService cfCitation cfEvent cfGeographicBoundingBox cfExpertise AndSkills • Model Cleaning • Cross-TG Activities • Linked Open Data TG • InstitutionalRepositories TG • Architectures TG • Indicators TG • Best Practice TG • Cooperationwith • CASRAI • VIVO cfQualification cfResultProduct cfResultPublication cfPerson cfOrganisation Unit cfResultPatent cfProject cfElectronicAddress cfPrize cfPostalAddress cfCurriculumVitae cfIndicator cfMeasurement cfCountry cfLanguage cfCurrency

50. www.eurocris.org Strategic Partnerships European Association of Research Managers and Administrators International Council for Science; Commission on Data Access All European Academies