1

Katerina Pouliasi /ERCOMER, Utrecht University

CRIS-MERThe CRIS on Migration and Ethnic Relation,

an interactive on-line tool

Background Highly focused and already existing audience WWW Virtual Library on MER / Bulletin board

Research data in electronic structured form

Requests from July 2000: http://www.ercomer.org/logs/access.html

Requests from July 1999-July 2000: http://www.ercomer.org/logs/access2000.html

2

Goal

WEB accessible,

database-driven information system,

European standards-based,

on research in

Migration and Ethnic Relations

Current

Research

Information

System

on

Migration

Ethnic

Relations

3

User InterfaceWorld Wide Web

DatabaseCERIF 2000

CRIS-MERMajor Components

4

CERIF 2000 / System requirements

CERIF 2000 Supports

Exchange of records/ Integration

Standard database design

Supports Networked knowledge

ISO/Commonly defined sets of values

CRIS-MER AIMS

Real time publishing

Authoritative and trusted

Moderated

5

Exceptions to CERIF 2000

Avoid extensive secondary info (e.g. Org unit, financial details)

Some tables not adopted in case links to supplementary I.S. may exist.

Enumlists instead of look-up tables for short definite lists

CHAR (2) instead of VARCHAR in case of primary keys.

Very long detailed lists not implemented (UNIMARC Manual - Bibliographic Format) and replaced by shorter lists.

ORTELIUS, very (too?) general, not translated in other languages.

6

PROJECT

PROJ_ID EVENT_ID PROJ_EVENT_ROLE

PROJ_EVENT

Research results + Networked I.S.

PUB_ID PUB_TYPE PUB__DATE PUB_REFERENCE PUB_URI

RESULT_PUBLICATION

PER_ID PUB_ID PERS_PUB_ROLE PER_PUB_COPYRIGHT

PERS_PUB

PERS_PUB_ROLE PERS_PUB_ROLE_FULL

PER_PUB_ROLE

PUB_LANGUAGE PUB_TRANS_TYPEPUB_ID PUB_TITLE

PUBLICATION_TRANSLATION

PROJ_PERSON

PROJ_ID PUB_ID PROJ_PUB_ROLE

PROJ_PUB

PERSON

PUB_TYPE

PUBLICATION_TYPE

7

Contributors interaction

Registration procedure

Is registered ?

Login Yes

No

New project Data entry

Data submission confirmed

Review entries

Update project data

Incomplete IncorrectUser OK

8

Administrators interaction

Data submission

Temporary database storage

Email moderators

Moderating interface:New records list

Data acceptance and publication

Review entries

Moderator OK

Reject

Moderator not OK

9

Current status and outlook

• Database design finished• Contributors, administrators and visitors

interaction first designs• Collaboration on an international level required• Financial support for implementation of CERIF

2000 ?.

http://www.ercomer.org/wwwvl/