Transcript National + regional CRIS - CCLRC repository

euroCRIS
Members Meeting
Tartu
Eddy Grąbczewski
May 2005
1
November 30, 2001
KM Workshop, SLE
Brian Matthews
Eddy Grąbczewski








Worked in IT development/support for 15 years
EU 3D MURALE project – Brunel University
CCLRC – Data Management Team
CCLRC – Corporate Data Model designer
EU CISTRANA project (EU nationals)
EU IST World project (SME)
euroCRIS CERIF Task Group Leader
Technical view of the CCLRC repository
2
November 30, 2001
KM Workshop, SLE
Brian Matthews
Council for the
Central Laboratory of the
Research Councils (CCLRC)


Multi-disciplinary research organisation
supporting scientists and engineers worldwide
Operates world-class large-scale research
facilities





ISIS (neutron source)
Lasers (sapphire and glass lasers)
Main shareholder in Diamond Light Source (X-ray, UV
source)
Provides strategic advice to the UK government
Manages and participates in international
research projects
3
November 30, 2001
KM Workshop, SLE
Brian Matthews
Where is CCLRC?

Rutherford Appleton Laboratory, Oxfordshire

Daresbury Laboratory, Cheshire
Chilbolton Observatory, Hampshire

4
November 30, 2001
KM Workshop, SLE
Brian Matthews
CCLRC CDR Project

Corporate Data Repository (CDR)
project:
To address the poor database
integration affecting CCLRC business.
 Create a infrastructure for future
corporate systems: SSO, CRIS, Open
Archive

5
November 30, 2001
KM Workshop, SLE
Brian Matthews
CCLRC Database Systems
6
November 30, 2001
KM Workshop, SLE
Brian Matthews
Typical questions





Why can’t I use my RAL security pass at DL?
(security access)
Why is my Windows login not transparent across
sites? (SSO)
Why are room booking services so disjointed
across sites? (integration)
How many papers has a department produced
this year?
Which EU projects to a member of staff work on?
7
November 30, 2001
KM Workshop, SLE
Brian Matthews
Causes

Heterogeneous db’s storing similar
data on different sites:
• CCLRC db’s are structurally different.
• CCLRC db’s need to share data.

Heterogeneous db’s makes
developing corporate applications
more complex and expensive.
8
November 30, 2001
KM Workshop, SLE
Brian Matthews
Possible Approaches

A single corporate db for all applications?
• Complex, difficult to agree and hence develop.

A corporate global db and local db’s for
all applications?
• probably the best compromise.

We need corporate applications that work
transparently across sites as well as local
applications.
• Web based applications using open interfaces.
9
November 30, 2001
KM Workshop, SLE
Brian Matthews
Workflow = Business Processes
Process Application
S1
S3
Process
Management
Systems
Rule Application
Rule
Management
Systems
S5
S4
Database Application
Database
Management
Systems
S2
Business
Repository
Processes
Rules
Databases
10
November 30, 2001
KM Workshop, SLE
Brian Matthews
Corporate Data Repository (CDR)



We use the term “repository” to mean a
common database to complement local
databases.
The CDR contains the Corporate Data
Model (CDM).
Implemented in Oracle but can be ported
to PostgreSQL, MS SQL Server or
Informix.
11
November 30, 2001
KM Workshop, SLE
Brian Matthews
Corporate Data Model (CDM)

The CDM models:
•
•
•
•
•


People in and outside CCLRC.
Jobs, roles and permissions of People.
Organisation Units in and outside CCLRC.
Projects related to CCLRC.
Publications in and outside CCLRC.
Consolidate data from the existing site
databases at RAL, DL and Chilbolton.
Based on euroCRIS CERIF standard.
12
November 30, 2001
KM Workshop, SLE
Brian Matthews
CDR Features







Ontology based (objects, entities)
ANSI/SPARC architecture
CERIF view
Temporal database (VT, TT)
Distributed architecture
Naming subschema
Support for hierarchies
13
November 30, 2001
KM Workshop, SLE
Brian Matthews
Ontology
Object at the top level
 Entity is a subtype of Object
 All relationships are types of entity

14
November 30, 2001
KM Workshop, SLE
Brian Matthews
ANSI/X3/SPARC Architecture (1975)
ANSI/SPARC Architecture
15
November 30, 2001
KM Workshop, SLE
Brian Matthews
Common European Research Information Format
CERIF (euroCRIS)
16
November 30, 2001
KM Workshop, SLE
Brian Matthews
CDM (CCLRC)
17
November 30, 2001
KM Workshop, SLE
Brian Matthews
CDM Subtypes
18
November 30, 2001
KM Workshop, SLE
Brian Matthews
Organization Temporal Data
Most databases only store current
facts.
What if we want to store historical
facts?
For example:
 What was the organisation structure three
years ago?
 What was an employee’s name before she
married?
19
November 30, 2001
KM Workshop, SLE
Brian Matthews
CDM Temporal Database



Stores Valid Time
Stores Transaction Time
Stores Last Update Time
20
November 30, 2001
KM Workshop, SLE
Brian Matthews
CDM Distributed Architecture
CCLRC
CF
DL
DtbId = 3
DtbId = 2
RAL
DtbId = 1
21
November 30, 2001
KM Workshop, SLE
Brian Matthews
Supports Many Data Models
22
November 30, 2001
KM Workshop, SLE
Brian Matthews
Naming Subschema
Based on Pierce’s ontology:
Sign
Symbol Reference Icon
 Any entity may have multiple signs,
symbols, references or icons.

23
November 30, 2001
KM Workshop, SLE
Brian Matthews
Support for hierarchies



Date (1986) proposed the EXPLODE
operator for SQL to view the ‘Parts
Explosion’ problem
CDM implements EXPLODE to traverse
hierarchies and simple graphs eg.
OrgUnit_OrgUnit.
CDM also implements Transitive Closure
operators
24
November 30, 2001
KM Workshop, SLE
Brian Matthews
Summary









Multiple-purpose database infrastructure
Ontology based (objects, entities)
ANSI/SPARC architecture
CERIF view
Temporal database (VT, TT)
Distributed architecture
Multiple Names for any object or entity
Support for hierarchies
Architecture extended for CISTRANA and IST
World (programme, language & keyword
support)
25