Database comparison
CERIF-2000 and AURIS
This report describes compatibility of CERIF and AURIS. The base point of report is CERIF.
PC partially compatible. In this case it is applied only for relations between string attributes of different length. Entity identifiers in CERIF are 32-length string, in AURIS are 49 or 50-length identifiers. So data from CERIF can be imported into AURIS without information lack, but data from AURIS into CERIF database might be exported without information lack if actual length of some identifiers are more then 32 characters. But in exporting AURIS operation, it is possible to preserve graph structure of AURIS, based on reference by id, if we transform all identifiers and references on it (primary keys and foreign keys) simultaneously to CERIF compatible values
C compatible.
BLACK COLOR CERIF tables and column names
BLUE COLOR AURIS tables and column names
|
Entity |
Attribute |
Type |
Constraint |
Comments / Meaning |
|
|
Project FD_FORSHUNGAKTIVITAET |
Project Id NR |
char(32) varchar2(49) pc |
m, pk |
|
I |
|
Start Date BEGINN |
Date AUDATE tc |
M O |
|
I |
|
|
End Date ENDE |
Date AUDATE Tc |
O O |
|
I |
|
|
Status |
char(8) |
m, enumlist NE |
stalled, completed Should be assigned by default or
derived |
I |
|
|
URI URL |
char(128) varchar2(150) pc |
|
project homepage |
I |
|
|
Person FD_PERSON |
Person Id NR |
char(32) varchar2(49) pc |
m, pk M |
|
I |
|
Family Names NACHNAME |
char(32) varchar2(50) PC |
M M |
list, separated |
I |
|
|
First Names VORNAME |
char(16) varchar2(40) PC |
O M |
list, separated |
I |
|
|
Other Names |
char(32) |
o |
list, separated |
N |
|
|
Sex |
char(1) |
o, enumlist |
M|F| |
N |
|
|
Honorific Title |
char(12) |
o, enumlist |
enumlist, separated |
N |
|
|
Academic Title TITEL |
char(12) varchar2(60) PC |
o, enumlist O |
enumlist, separated |
I |
|
|
Qualifications |
char(24) |
o, enumlist |
enumlist, separated |
N |
|
|
Nationalities |
char(16) |
o, enumlist |
enumlist, ISO 3166
standard, two letter codes, separated |
N |
|
|
URI |
char(128) |
|
Person homepage |
N |
|
|
OrgUnit FD_FORSHUNGSEINRICHTUNG |
OrgUnit Id NR |
char(32) varchar2(49) PC |
M, pk M |
|
I |
|
Acronym KURZBEZEICHUNG |
char(16) varcgar2(10) C |
O M |
|
I |
|
|
Type |
Char(8) |
M, enumlist |
enumlist, separated Can be taken by default or
derived |
I |
|
|
Headcount |
char(2) |
O |
The harmonised package for
the European Union Fifth Framework Programme provides definitions for
Organisation/Company size, which are used here. |
N |
|
|
Turnover |
float |
O |
total annual working budget |
N |
|
|
Currency |
char(3) |
m if value else o |
3 letter ISO 4217 currency
codes to be used. |
N |
|
|
URI FD_DE_ADRESSE.FD_ADRESSE.URL |
char(128) varchar2(150) PC |
|
OrgUnit homepage |
I |
|
Entity |
Attribute |
Type |
Constraint |
Comments / Meaning |
|
|
Result_Publication FD_VEROEFFENTLICHUNG |
Result_Publication Id NR |
char(32) varchar2(49) pc |
m, pk |
unique identifier |
|
|
Date ERSCHEININGSJAHR |
Date Number(4) C |
o |
year of publication need type conversion |
||
|
Reference |
char(512) |
m |
where to find it -
classical reference UC |
||
|
Type |
char(16) |
o |
unimarc |
||
|
URI URL |
char(128) varchar2(100) C |
O |
Publication homepage |
||
|
URI Type |
char(16) |
|
Type of Publication URI Can be derived |
||
|
Contact FD_ADRESSE |
Contact Id NR |
char(32) varchar2(49) PC |
m, pk |
|
|
|
Addrline1 STRASSE_HAUSNUMMER |
char(80) varchar2(40) PC |
O O |
|
||
|
Addrline2 |
char(80) |
O |
|
||
|
Addrline3 |
char(80) |
O |
|
||
|
Addrline4 |
char(80) |
O |
|
||
|
Addrline5 |
char(80) |
O |
|
||
|
.LAND.NAME |
char(32) varchar2(100) PC |
M M |
|
||
|
State of .LAND.NAME |
char(32) varchar2(100) PC |
O O |
|
||
|
Postcode POSTLEITZAHL |
char(16) varchar2(20) PC |
M O |
|
||
|
Country code .LAND.ISO_CODE2 |
char(2) varchar2(10) PC |
M, enumlist M |
|
||
|
NUTS Code .LAND.NAME |
char(10) |
M, enumlist O |
Eurostat region locator
code, mandatory in EU |
||
|
Telephone TELEFONNUMBER |
char(24) varchar2(50) |
O O |
list, separated |
||
|
Fax FAX_NUMBER |
char(24) varchar2(50) |
O O |
list, separated |
||
|
Email EMAIL_ADRESSE |
char(32) varchar2(150) PC |
O O |
|
||
|
URI URL |
char(128) varchar2(150) |
O O |
contact URI |
||
|
Entity |
Attribute |
Type |
Constraint |
Comments / Meaning |
|
Project-title FD_TITEL_BESCHREIB_FA |
Project Id FD_FA_NR |
char(32) varchar2(49) C |
m, pk(part) M |
|
|
Language FD_SPRACHE_NR |
char(2) varchar2(50) PC |
M, pk(part) M |
|
|
|
Translation ORIGINAL |
char(1) char(1) C |
M, pk(part) M |
o(rig), h(uman), m(achine) needs translation all Deucth Y
English - N |
|
|
Title TITEL |
char(1024) varchar2(300) C |
M |
|
|
|
Project-Keywords FD_SCHLAGWORT |
Project Id FD_FA_NR |
Char(32) varchar2(49) C |
m, pk(part) M |
|
|
Language FD_SPRACHE_NR |
Char(2) varchar2(50) PC |
M, pk(part) M |
|
|
|
Translation |
char(1) |
M, pk(part) M |
o(rig), h(uman), m(achine) should be used default valur |
|
|
Keywords NAME |
char(1024) varchar2(60) |
M |
ORTELIUS, NACE and CPA are
recommended for subject indexing. |
|
|
Project-Abstract FD_TITEL_BESCHREIB_FA RE: The same row as a project title in FD_TITEL_* |
ProjectId FD_FA_NR |
char(32) varchar2(49) C |
M, pk(part) M |
|
|
Language FD_SPRACHE_NR |
char(2) varchar2(50) PC |
M, pk(part) M |
|
|
|
Translation ORIGINAL |
char(1) char(1) C |
M, pk(part) M |
o(rig), h(uman), m(achine) needs translation all Deucth Y
English - N |
|
|
Abstract KURZFASSUNG |
char(4096) LONG(6000) PC |
M |
|
|
Classification FD_SACHGEBIET_TEXT |
Classification NAME |
char(16) varchar2(60) PC |
M, pk(part) M |
Where subject indexing of the following types of entities is used, the following classification codes are recommended: 1/ ORTELIUS should be used
to subject index research subject. 2/ For the indication of
"Economic Activity Area" the NACE (Nomenclature statistique des
activits conomiques de la Communaut Europenne) has been chosen in line
with the EUROSTAT guidelines. The 2-digit level is mandatory, the 4-digit
level is recommended for CERIF 2000. |
I |
|
|
Class code |
char(16) |
m,pk(part) |
Should be derived |
N |
||
|
URI |
char(128) |
|
Classification homepage |
N |
||
|
Classification-Description FD_SACHGEBIET_TEXT |
Classification Id |
char(32) |
m, pk(part) |
|
|
|
|
Language Fd_SACHGEBIET_TEXTE |
char(2) FD_SPRACHE_NR VARCHAR(50) pc |
m, pk(part) M |
COMPATIBLE AFTER TRANSFORMATION |
|
||
|
Translation |
char(1) |
m, pk(part) |
o(rig), h(uman), m(achine) Should be derived or by default |
|
||
|
Description |
char(64) |
|
|
|
||
|
Language FD_SPRACHE |
Language CODE |
char(2) varchar2(10) PC |
m, pk, enumlist M |
ISO 639 standard,
two-letter code ISO 3166. Mapping should be established. |
|
|
|
Language full Name NAME |
char(32) varchar2(60) |
M M |
|
|
||
|
Language English Name NAME_ENGL |
char(32) varchar2(60) |
O M |
|
|
||
|
Entity |
Attribute |
Type |
Constraint |
Comments / Meaning |
|
|
Project-Person FD_PERSONEN_FA |
Project Id FD_FA_NR |
char(32) varchar2(49) C |
m, fk, pk(part) M |
|
|
|
Person Id FD_PERSON_NR |
char(32) varchar2(49) C |
m, fk, pk(part) M |
|
||
|
Role FD_PERSON.FUNCTION |
char(16) |
o, enumlist |
e.g. project leader, investigator, accountant Possible lack of information |
||
|
Start Date |
date |
o |
|
||
|
End Date |
date |
o |
|
||
|
Project-Project FD_FORSHUNGSAKTIVITAET |
Project Id NR |
char(32) varchar2(49) C |
m, fk, pk(part) M |
|
|
|
Project Id FD_FA_NR |
char(32) varchar2(49) C |
m, fk, pk(part) M |
|
||
|
Role |
char(16) |
o, enumlist |
e.g. subproject, parallel
project PARENT only |
||
|
Start Date |
date |
o |
|
||
|
End Date |
date |
o |
|
||
|
Project-OrgUnit FD_FORSHUNG_ENRICHUNG_FA |
Project Id FD_FA_NR |
char(32) varchar2(49) C |
m, fk, pk(part) M |
|
|
|
OrgUnit Id FD_FE_NR |
char(32) varchar2(49) C |
m, fk, pk(part) M |
|
||
|
Role |
char(16) |
o, enumlist |
List of values are defined
for EU Fifth Framework Programme CO : Co-ordinator (=scientific,
administrative and financial co-ordinator) CF: Only financial
co-ordinator (if different from co-ordinator) AC: Associate contractor CR: Contractor (other than
the co-ordinator) |
||
|
Start Date |
date |
o |
|
||
|
End Date |
date |
o |
|
||
|
Project-Result_Publication FD_VEROEFFENTLIGHUNG_FA |
Project Id FD_FA_NR |
char(32) varchar2(49) C |
m, fk, pk(part) M |
|
|
|
Result_Publication Id FD_VEROEFFNR |
char(32) varchar2(49) C |
m, fk, pk(part) M |
|
||
|
Role |
char(16) |
o, enumlist |
e.g. techreport.. |
||
|
Copyright |
char(32) |
m |
Should be taken default value |
||
|
Project-Classification FD_FA_SACHGEBIET |
Project Id FD_FA_NR |
char(32) varchar2(49) C |
m, fk, pk(part) M |
|
|
|
Class code FD_SACHGEB_NR |
char(16) varchar2(50) C |
o, fk M |
|
||
|
Class Scheme |
char(32) |
o, fk |
|
||