Current CERIF
model (corrected 2002.09.20)
Current
Metadata model (corrected
2002.09.11)
CERIF database schema for MySQL,
Andrei S.
Lopatenko,31. october 2002
Postgres version of
CERIF-2000, Andrei S.
Lopatenko, october 2002
This version is based on Oracle version of CERIF and support all
cerif features - data model with integrity constraints. This file
is based on old 2000 version of CERIF without updates and
improvements done by Keith. I'll adopt them little later.
I have tested postgres CERIFD with
Postgres 7.2.3 in my RedHat Linux environment and it works fine (of
course, we it should be tested in real environment) At least one
can easilty create postgres database using these script or dump.
PostgreSQL is a free database, so to implement CERIF one does
not need to buy Oracle, MS SQL, Access. PogreSQL may be installed
in 4 minutes, loading of CERIF database takes 20 seconds.
The verified error-free version of
CERIF-2000 database, Andrei S.
Lopatenko, 2002
The list of errors in original CORDIS CERIF version and
corrections of them.
A CERIF-2001 distributive,
Andrei S.
Lopatenko, 2002
I hope the installation and development of CRIS based on CERIF-2000
can be little easy. The main file in distribution is loadCERIF.sql
To create CERIF database, you need to create Oracle user and then
run loadCERIF.sql file in Oracle SQLPlus with specified username and
passwords LoadCERIF.cmd batch file can be used. The only username
and password should be replaces in the file
Contains SQL DDL files to create CERIF-2000
database schema and a set of INSERT scripts to populate CERIF
vocabulary tables with vocabualries according to CERIF-2000
specification
In MS environment loadCERIF.cmd should be
runned (please, change username and password) loadCERIF.sql
Can be used as a script for Oracle SQL* PLUS in any environment
|