Basic information


Old - Version: 2008 - 1.2 FDM New - Version: CERIF 1.3 FDM
Project CERIF 2008 Release CERIF 2008 Release
Model CERIF 2008 - 1.2 Full Data Model CERIF - 1.3 Full Data Model
Version 2008 - 1.2 FDM CERIF 1.3 FDM
Company euroCRIS euroCRIS
Author CERIF Taskgroup CERIF Taskgroup
Created 30.11.2006 30.11.2006
Last modified 14.11.2010 10.01.2012
Notes The CERIF 2008 - 1.2 release is the last version of the 2008 series. Compared
to its preceding version CERIF 2008 - 1.1, the current release CERIF 2008 - 1.2
incorporates the following features:

• Pending Entities have been discussed with the following results:
No cfCall and no cfGrant entity and related entities will be added.
Instead, the Funding entity will be renamed and via the cfClass plus
cfClassScheme entities, a typification for FundingProgramme, Call,
Tender, etc. can be realized.

• Deletion of Entities in the Context of Funding:
cfCall (so far pending, now removed)
cfCall_FundingProgramme (so far pending, now removed)
cfCallDescription (so far pending, now removed)
cfCallKeywords (so far pending, now removed)
cfCallName (so far pending, now removed)
cfGrant (so far pending, now removed)
cfGrant_FundingProgramme (so far pending, now removed)
cfGrantDescription (so far pending, now removed)
cfGrantKeywords (so far pending, now removed)
cfGrantName (so far pending, now removed)

• Renaming of Funding Programme entity and its related entities:
cfFundingProgramme -> cfFunding
cfFundingProgramme_Classification -> cfFunding_Classification
cfFundingProgramme_FundingProgramme -> cfFunding_Funding
cfFundingProgrammeDescription -> cfFundingDescription
cfFundingProgrammeKeywords -> cfFundingKeywords
cfFundingProgrammeName -> cfFundingName
cfFundingProgramme_Equipment -> cfFunding_Equipment
cfEvent_FundingProgramme -> cfEvent_Funding
cfFacility_FundingProgramme -> cfFacility_Funding
cfService_FundingProgramme -> cfService_Funding
cfOrganisationUnit_FundingProgramme -> cfOrganisationUnit_Funding
cfPerson_FundingProgramme -> cfPerson_Funding
cfProject_FundingProgramme -> cfProject_Funding
cfResultPatent_FundingProgramme -> cfPatent_Funding
cfResultProduct_FundingProgramme -> cfProduct_Funding
cfResultPublication_FundingProgramme -> cfResultPublication_Funding

• Renaming of Attributes:
cfSex -> cfGender
cfFundProgId -> cfFundId
cfFundProgId -> cfFundId
cfFundProgId1 -> cfFundId1
cfFundProgId2 -> cfFundId2

• Renaming of Relationships:
"(...)FProg" -> "(...)Fund" // for all

• CERIF Semantics (not physically a part of the model):
The terms for relationships between CORE CERIF entities have
been collected and definitions provided for a better understanding

The CERIF - 1.3 version is the last version of the 2008 series. Compared to its preceding version CERIF 2008 - 1.2, the current release omits the year in its official name and is called "CERIF 1.3". It incorporates the following features:

New Entities
cfClassificationSchemeDescription; cfClassificationSchemeName; cfClassificationExample; cfClassificationDefinition

cfMedium; cfMediumTitle; cfMediumDescription; cfMediumKeywords; cfMedium_Medium; cfMedium_Classification; cfResultPublication_Medium; cfResultProduct_Medium; cfFacility_Medium; cfService_Medium; cfProject_Medium; cfPerson_Medium; cfOrganisationUnit_Medium; cfEvent_Medium; cfFunding_Medium; cfCitation_Medium;

cfEquipment_Equipment; cfService_Service; cfFacility_Facility; cfFacility_Equipment; cfFacility_Service; cfEquipment_Service; cfFacility_Event; cfEquipment_Event; cfResultPublication_Service; cfResultPatent_Facility; cfResultPatent_Service; cfResultPatent_Equipment; cfResultProduct_Facility; cfResultProduct_Service; cfResultProduct_Equipment;
cfGeographicBoundingBox; cfGeographicBoundingBox_GeographicBoundingBox; cfGeographicBoundingBoxName; cfGeographicBoundingBoxDescription; cfGeographicBoundingBoxKeywords; cfGeographicBoundingBox_Classification; cfPostAddress_GeographicBoundingBox; cfEquipment_PostAddress; cfFacility_PostAddress; cfService_PostAddress;

cfMeasurement; cfIndicator; cfIndicator_Measurement; cfMeasurement_Classification; cfIndicator_Classification; cfIndicatorName; cfIndicatorDescription; cfIndicatorKeywords; cfMeasurementName; cfMeasurementDescription; cfMeasurementKeywords; cfPerson_Measurement; cfOrganisationUnit_Measurement; cfProject_Measurement; cfResultPublication_Measurement; cfResultPatent_Measurement; cfResultProduct_Measurement; cfFacility_Measurement; cfService_Measurement; cfEquipment_Measurement; cfPerson_Indicator; cfOrganisationUnit_Indicator; cfProject_Indicator; cfResultPublication_Indicator; cfResultPatent_Indicator; cfResultProduct_Indicator; cfFacility_Indicator; cfService_Indicator; cfEquipment_Indicator; cfEvent_Measurement; cfEvent_Indicator; cfMedium_Indicator; cfMedium_Measurement; cfIndicator_Indicator; cfMeasurement_Measurement;

New Attributes
cfRoleExpression; cfRoleExpressionOpposite with cfClassificationTerm entity
cfMediumIdentifier; cfMediumCreationDate; cfSize; cfMimeType; cfUniformResourceIdentifier with cfMedium entity
cfAcronym with cfEquipment; cfFacility; cfService; cfFunding entities
cfDescriptionSource; cfTermSource; cfDefinitionSource; cfNameSource; cfExampleSource with Classification entities
cfStartDate/cfEndDate with cfResultPublication_Metrics entity
cfTranslation in cfLanguageName entity

Removed Attributes:
cfEquipmentOwnerIdentifier; cfOriginalEquipmentManufacturerIdentifier with cfEquipment entity
cfResultProductInternalIdentifier with cfResultProduct entity;

Renamed Attributes:
cfName in entity cfCurrencyEntityName to cfEntityName

Pending Entities:
cfResPublVersInf; cfResPatVersInf; cfResProdVersInf
cfMiddleNames with cfPersonName entity


Statistic information


Old - Version: 2008 - 1.2 FDM New - Version: CERIF 1.3 FDM
Entities 195 286 91 - 57
Attributes 1175 1766 597 6 50
Indexes 0 0 - - -
Alternative keys 1 1 - - -
User type 1 1 - - -
Procedures 0 0 - - -
Triggers 0 0 - - -
Views 0 0 - - -
Functions 0 0 - - -
Packages 0 0 - - -
Package bodies 0 0 - - -
Types 0 0 - - -
Type bodies 0 0 - - -
Sequences 0 0 - - -
Synonyms 0 0 - - -
Object Tables 0 0 - - -
XMLType Tables 0 0 - - -