Transcript SK CRIS

The system SK CRIS and its data model
Short report about Slovak research information
system in preparation
Danica Zendulková, SC STI
SK CRIS. TG CERIF Meeting 18-19 August 2011
Starting point
Actual IS-CIP VVI consists of:
• InfoPath forms (6)
• SQL database (data tables, registries- about 50)
• Outputs (Reporting Services – statistics R&D potential)
• WebAccess
SK CRIS. TG CERIF Meeting 18-19 August 2011
Data suppliers
Subjects
R&D
Organizations
Project
responsibles
Researcher
Survey of R&D
Potential
Certification
Project
registration
Laboratory
Infrastructure
Project
responsible
Forms
SK CRIS. TG CERIF Meeting 18-19 August 2011
Expert
Organization - R&D survey
Data record in xml
SK CRIS. TG CERIF Meeting 18-19 August 2011
Organization – data record
SK CRIS. TG CERIF Meeting 18-19 August 2011
SK CRIS
• Guarrantee: Ministry of Education,
Science, Research and Sport
•Supplier: InterWay s.r.o
•Provider: SC STI
•Scope: National Information system
•Data format: CERIF
SK CRIS. TG CERIF Meeting 18-19 August 2011
Users functionality
Public area:
• General information (portal content)
• Webaccess to CRIS entities
• Registration tool
Private area:
• Different roles by type of user
–
–
–
–
–
–
Online accessible e-forms
Data and document entry
Access to all stored data (search, modify)
Metadata creating
Access rights modify
Reporting
SK CRIS. TG CERIF Meeting 18-19 August 2011
E-forms
• CERIF core entities
– Organization
– Project
– Expert
• CERIF result entities
– Publication
– Patent
– Product
• Certification (assessment of competence to perform R&D)
• Survey of R&D Potential
SK CRIS. TG CERIF Meeting 18-19 August 2011
Organization
About 700 R&D subjects: Universities, Academy
of Science, R&D Institutes, Private R&D
Organizations, Non-for-Profit R&D
Organization etc.
SK CRIS. TG CERIF Meeting 18-19 August 2011
Organization –fields
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
cfOrgUnit
Name cfOrgUnitName
Identification Number of Organization (IČO)
Faculty Identification
Key Words cfOrgUnitKeyw
Research Activitie cfOrgUnitReAct
Address*
Language cfLang
Country cfCountry
Currency cfCurrency
Contact person
Representative person
Founder if any (ministries) registry
Resort registry (SK Statistical Office)
SK NACE- organization activity registry (EU)
SK NACE – R&D registry (EU)
R&D Fields registry
Economy type registry
Sector R&D registry
Predominant activity (R&D or other)
Certificate No (assessment of competence to perform R&D)
Certificate - release date
Certificate - valid from
Certificate - valid until
*Address (post&electronic) cfEAddr, cfPAddr
•
•
•
•
•
•
•
•
•
•
Street
No
Mailbox
City/Town
Postal Code
Regional code
Phone
Fax
E-mail
www
SK CRIS. TG CERIF Meeting 18-19 August
2011
Researcher - fields
About 20 000 researchers from all R&D institutions
•
•
•
•
•
•
•
•
•
•
•
•
•
Surname
Name cfPersName
Gender
Date of Birth
Key Words cfPersKeyw
Anotation cfPersResInt
Address
CV
Qualification cfQual
Experiences
cfExpSkills what to write?
R&D Fields registry (SK Ministry of Education)
Sector R&D registry (SK Statistical Office)
Sector sub-classification registry (Frascati
•
•
•
•
•
•
Organization
cfPers_OrgUnit
Publication cfPers_ResPubl
Citation
by Organization, by Project – no entities?
Patents
cfPers_ResPat
Products
cfPers_ResProd
Projects
cfProj_Pers
Manual)
•
•
•
cfPers
Title
Year of title reach
Expert - project reviewer Y/N
SK CRIS. TG CERIF Meeting 18-19 August 2011
Project
R&D Projects funded from public resources:
state budget: different form of subsidies, grant
agency; EU structural funds etc.
SK CRIS. TG CERIF Meeting 18-19 August 2011
Project-fields
cfProj
•
•
•
•
•
•
•
•
•
•
•
•
•
•
I. Provider of funds
Name
Type
cfFund
Call for project
II.Project
Code:
Name
Acronym
Start date
End date
Abstract cfProjAbtr
Key Words cfProjKeyw
Character R&D registry
R&D Fields registry
•
•
•
•
•
•
•
•
•
•
•
•
•
III. Organization cfProj_OrgUnit
IV. Finance
Requested amount
Granted amount
Drawn amount
Start date
End date
Co-financing/other resources
V. Project outputs
Publication cfProj_ResPubl,
cfOrgUnit_ResPubl, cfPers_ResPubl
Citation cfResPubl_Cite
Patent cfProj_ResPat ,
cfOrgUnit_ResPat, cfPers_ResPat
Product cfProj_ResProd ,
cfOrgUnit_ResProd, cfPers_ResProd
SK CRIS. TG CERIF Meeting 18-19 August 2011
R&D Results
Publications, Patents, Products (detailed semantics...)
• Name
• Category (cfResPubl, cfResPat, cfResProd)
• ID Number
• Date of issue
• Owner
SK CRIS. TG CERIF Meeting 18-19 August 2011
Exemple - Graphic representation
SK CRIS. TG CERIF Meeting 18-19 August 2011
dbo.cfOrgUnitKeyw
cfOrgUnitID: SK56036
cfLangCode: ENG
cfTrans:
cfKeyw National
Information Centre,
Specialized Scientific
Library, Popularization of
Science, Technology
transfer
dbo.cfOrgUnitName
cfOrgUnitId: SK56036
cfLangCode: ENG
cfTrans:
cfName Slovak Centre of Scientific
and Technical Information
cfStartDate 20000101
cfEndDate
Dbo.cfPAddr
Dbo.cfOrgUnit
cfPAddrId: SK56036_P01
cfCountryCode: SK
cfAddrline1: Lamačská 8/A
cfAddrline2:
004212/69253102
cfAddrline3:
004212/69253180
cfAddrline4
cfAddrline5
cfPostCode: 81104
cfCityTown: Bratislava
(ClassSchemeId: Cobec,
ClassID:1)
cfStateOfCountry Slovakia
cfURI: http://www.cvtisr.sk
cfOrgUnitId: SK56036
cfCurrCode: Euro
CfAcro: SC STI
cfHeadcount: 112
cfTurn: 23000000
cfURI:
http://www.cvtisr.sk
Dbo.cfOrgUnit_
PAddr
cfOrgUnitId
SK56036
cfPAddrId
SK56036_P01
cfStartDate
20000101
cfEndDate
SK CRIS. TG CERIF Meeting 18-19 August 2011
cfOrgUnit
dbo.cfEAddr
cfEAddrId: SK56036_E01
cfURI: http://www.cvtisr.sk
cfURI: https://www.vedatechnika.sk
cfURI: [email protected]
Dbo.cfOrgUnit
_EAddr
cfOrgUnitId
SK56036
cfEAddrId
SK56036_E01
cfStartDate
20000101
cfEndDate
cfProj
dbo.cfProjKeyw
cfProjId: SKEUfund1234
cfLangCode: ENG
cfTrans
cfKeyw: Research
Information, Project
Registry, CRIS, CERIF,
Dbo.cfFund
Dbo.cfProj
dbo.cfProjAbstr
cfProjId: : SKEUfund1234
cfLangCode: ENG
cfTrans
cfAbstr: Enlargement of
Central Information Portal
for Research, Development
and Innovation (CIP RDI)
with new functionalities
complying with EU
standards. It focuses on
effective work with project
including a connection with
other information systems.
cfProjId: SK1234
cfStartDate:20081201
cfEndDate:20140630
cfAcro:NISPEZ
cfURI:
http://nispez.cvtisr.sk/i
ndex.php?&menu=1
Dbo.cfProj_Fund
cfProjId SK1234
cfFundId
FUND0001
cfStartDate20081
201
cfEndDate
20140630
cfCurrCode Eur
cfAmount 19 881
676
cfFundID:FUND0001
CurrCode:Eur
cfStartDate:20070101
cfEndDate:20131231
cfAmount: 1 209 415 373
cfURI:
http://www.nsrr.sk/operacn
e-programy/vyskum-vyvoj/
dbo.cfProjTitle
dbo.cfFundName
cfProjId: : SKEUfund1234
cfLangCode:ENG
cfTrans
cfTitle: National Information
System Supporting Research and
Development in the Slovak
Republic – Access to Electronic
Information Resources
FundID: FUND0001
cfLangCode: ENG
cfTrans
cfName:Operational
Programme Research
and Development
SK CRIS. TG CERIF Meeting 18-19 August 2011
dbo.cfPersKeyw
dbo.cfPersName
cfPersId: SK98765
cfLangCode:ENG
cfTrans
cfKeyw: Information
system, Database, CRIS
cfPersId: SK98765
cfFamilyNames:Zendulkova
cfOtherNames: Mrkvickova
cfFirstNames:Danica
cfPers
Dbo.cfPers
Dbo.cfPAddr
cfPAddrId: SK56036_P02
cfCountryCode: SK
cfAddrline1: Lesna 1
cfAddrline2: 004212/69253133
cfAddrline3:
cfAddrline4
cfAddrline5
cfPostCode: 81104
cfCityTown: Bratislava
(ClassSchemeId: Cobec,
ClassID:1)
cfStateOfCountry Slovakia
cfURI:
Dbo.cfPers_PAddr
cfPersId:SK98765
cfPAddrId
SK56036_P02
cfStartDate
20000101
cfEndDate
cfPersId:SK98765
cfBirthdate:19700101
cfGender:F
cfURI:
http://www.cvtisr.sk/ind
ex/go.php?id=526&id_ty
pe=11&page=6&sort=2&
sdir=ASC&id_detail=&par
am2=&param4=&id_deta
il=986
SK CRIS. TG CERIF Meeting 18-19 August 2011
dbo.cfEAddr
cfEAddrId: SK56036_E02
cfURI:
http://www.cvtisr.sk/index/go.php
?id=526&id_type=11&page=6&sor
t=2&sdir=ASC&id_detail=&param2
=&param4=&id_detail=986
cfURI: [email protected]
Dbo.cfPers_EAdd
r
cfPersId:SK98765
cfEAddrId
SK56036_E02
cfStartDate
20000101
cfEndDate
dbo.cfPersResInt
cfPersId: SK98765
cfLangCode:ENG
cfTrans
cfResInt: As a member of a
project team I am interested in
best practice in the process of
preparing and providing the
CRIS. In 2009 I prepared an
analysis of the CRIS systems. The
analysis is based on information
research oriented to state –
operated CRIS systems mainly
within the EU.
cfResPubl
dbo.cfResPubl
Dbo.cfResPublTitle
cfResPublId: SKPub00001
cfResPublDate:2011
cfNum
cfVol
cfEdition SC STI
cfSeries
cfIssue
cfStartPage
cfEndPage
cfTotalPages: 66
cfISBN: ISBN:978-80-89354-04-7
cfISSN
cfURI
http://nispez.cvtisr.sk/userfiles/fil
e/Aktivita%204.1/Statne_IS_o_ve
de_v_EU_final(1).pdf
cfResPublId SKPub00001
cfLangCode ENG
cfTrans
cfTitle: State operated research
information systems in the EU
SK CRIS. TG CERIF Meeting 18-19 August 2011
Dbo.cfResPublKeyw
cfResPublId SKPub00001
cfLangCode ENG
cfTrans
cfKeyw information
system criteria, research
information,euroCRIS,
CERIF
Thank you very much
for your attention
SK CRIS. TG CERIF Meeting 18-19 August 2011