1 / 25

euroCRIS Members Meeting Tartu

euroCRIS Members Meeting Tartu. Eddy Grąbczewski May 2005. 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)

Download Presentation

euroCRIS Members Meeting Tartu

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. euroCRIS Members MeetingTartu Eddy Grąbczewski May 2005

  2. KM Workshop, SLE 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

  3. KM Workshop, SLE 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

  4. KM Workshop, SLE Where is CCLRC? • Rutherford Appleton Laboratory, Oxfordshire • Daresbury Laboratory, Cheshire • Chilbolton Observatory, Hampshire

  5. KM Workshop, SLE 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

  6. KM Workshop, SLE CCLRC Database Systems

  7. KM Workshop, SLE 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?

  8. KM Workshop, SLE 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.

  9. KM Workshop, SLE 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.

  10. KM Workshop, SLE Workflow = Business Processes

  11. KM Workshop, SLE 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.

  12. KM Workshop, SLE 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.

  13. KM Workshop, SLE CDR Features • Ontology based (objects, entities) • ANSI/SPARC architecture • CERIF view • Temporal database (VT, TT) • Distributed architecture • Naming subschema • Support for hierarchies

  14. KM Workshop, SLE Ontology • Object at the top level • Entity is a subtype of Object • All relationships are types of entity

  15. KM Workshop, SLE ANSI/SPARC Architecture ANSI/X3/SPARC Architecture (1975)

  16. KM Workshop, SLE CERIF (euroCRIS) Common European Research Information Format

  17. KM Workshop, SLE CDM (CCLRC)

  18. KM Workshop, SLE CDM Subtypes

  19. KM Workshop, SLE 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?

  20. KM Workshop, SLE CDM Temporal Database • Stores Valid Time • Stores Transaction Time • Stores Last Update Time

  21. KM Workshop, SLE CDM Distributed Architecture

  22. KM Workshop, SLE Supports Many Data Models

  23. KM Workshop, SLE Naming Subschema • Based on Pierce’s ontology: Sign SymbolReferenceIcon • Any entity may have multiple signs, symbols, references or icons.

  24. KM Workshop, SLE 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

  25. KM Workshop, SLE 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)

More Related