1 / 20

The system SK CRIS and its data model

The system SK CRIS and its data model. Short report about Slovak research information system in preparation Danica Zendulková , SC STI. Starting point. Actual IS-CIP VVI consists of: InfoPath forms (6) SQL database (data tables, registries- about 50)

lester
Download Presentation

The system SK CRIS and its data model

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. 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

  2. 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

  3. Data suppliers Forms Subjects R&D Organizations Project responsibles Researcher Surveyof R&D Potential Project registration Certification LaboratoryInfrastructure Project responsible Expert SK CRIS. TG CERIF Meeting 18-19 August 2011

  4. Organization - R&D survey Data record in xml SK CRIS. TG CERIF Meeting 18-19 August 2011

  5. Organization – data record SK CRIS. TG CERIF Meeting 18-19 August 2011

  6. 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

  7. 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

  8. 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

  9. 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

  10. Organization –fieldscfOrgUnit • Name cfOrgUnitName • Identification Number of Organization (IČO) • Faculty Identification • Key Words cfOrgUnitKeyw • Research ActivitiecfOrgUnitReAct • 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

  11. Researcher - fieldsAbout 20 000 researchersfromallR&D institutionscfPers • Surname • NamecfPersName • Gender • DateofBirth • KeyWordscfPersKeyw • AnotationcfPersResInt • Address • CV • QualificationcfQual • ExperiencescfExpSkillswhat to write? • R&D Fieldsregistry(SK MinistryofEducation) • Sector R&D registry(SK Statistical Office) • Sectorsub-classificationregistry(FrascatiManual) • Title • Yearoftitlereach • Expert - projectreviewer Y/N • OrganizationcfPers_OrgUnit • PublicationcfPers_ResPubl • Citationby Organization, by Project – no entities? • PatentscfPers_ResPat • ProductscfPers_ResProd • ProjectscfProj_Pers SK CRIS. TG CERIF Meeting 18-19 August 2011

  12. 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

  13. Project-fieldscfProj • I. Provideroffunds • Name • Type cfFund • Callforproject • II.Project • Code: • Name • Acronym • Startdate • End date • AbstractcfProjAbtr • KeyWordscfProjKeyw • CharacterR&Dregistry • R&D Fieldsregistry • III. OrganizationcfProj_OrgUnit • IV. Finance • Requestedamount • Grantedamount • Drawnamount • Startdate • End date • Co-financing/otherresources • V. Project outputs • PublicationcfProj_ResPubl, cfOrgUnit_ResPubl, cfPers_ResPubl • CitationcfResPubl_Cite • Patent cfProj_ResPat , cfOrgUnit_ResPat, cfPers_ResPat • ProductcfProj_ResProd , cfOrgUnit_ResProd, cfPers_ResProd SK CRIS. TG CERIF Meeting 18-19 August 2011

  14. 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

  15. Exemple - Graphic representation SK CRIS. TG CERIF Meeting 18-19 August 2011

  16. cfOrgUnit dbo.cfOrgUnitName cfOrgUnitId: SK56036 cfLangCode: ENG cfTrans: cfName Slovak Centre of Scientific and Technical Information cfStartDate 20000101 cfEndDate dbo.cfOrgUnitKeyw cfOrgUnitID: SK56036 cfLangCode: ENG cfTrans: cfKeyw National Information Centre, Specialized Scientific Library, Popularization of Science, Technology transfer dbo.cfEAddr cfEAddrId: SK56036_E01 cfURI: http://www.cvtisr.sk cfURI: https://www.vedatechnika.sk cfURI: cvti@cvtisr.sk Dbo.cfOrgUnit_EAddr cfOrgUnitId SK56036 cfEAddrId SK56036_E01 cfStartDate 20000101 cfEndDate Dbo.cfPAddr 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 Dbo.cfOrgUnit 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

  17. cfProj dbo.cfProjKeyw cfProjId: SKEUfund1234 cfLangCode: ENG cfTrans cfKeyw: Research Information, Project Registry, CRIS, CERIF, Dbo.cfFund cfFundID:FUND0001 CurrCode:Eur cfStartDate:20070101 cfEndDate:20131231 cfAmount: 1 209 415 373 cfURI: http://www.nsrr.sk/operacne-programy/vyskum-vyvoj/ Dbo.cfProj_Fund cfProjId SK1234 cfFundId FUND0001 cfStartDate20081201 cfEndDate 20140630 cfCurrCode Eur cfAmount 19 881 676 Dbo.cfProj cfProjId: SK1234 cfStartDate:20081201 cfEndDate:20140630 cfAcro:NISPEZ cfURI: http://nispez.cvtisr.sk/index.php?&menu=1 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. dbo.cfProjTitle cfProjId: : SKEUfund1234 cfLangCode:ENG cfTrans cfTitle: National Information System Supporting Research and Development in the Slovak Republic – Access to Electronic Information Resources dbo.cfFundName FundID: FUND0001 cfLangCode: ENG cfTrans cfName:Operational Programme Research and Development SK CRIS. TG CERIF Meeting 18-19 August 2011

  18. dbo.cfPersKeyw cfPersId: SK98765 cfLangCode:ENG cfTrans cfKeyw: Information system, Database, CRIS dbo.cfPersName cfPersId: SK98765 cfFamilyNames:Zendulkova cfOtherNames: Mrkvickova cfFirstNames:Danica dbo.cfEAddr cfEAddrId: SK56036_E02 cfURI: http://www.cvtisr.sk/index/go.php?id=526&id_type=11&page=6&sort=2&sdir=ASC&id_detail=&param2=&param4=&id_detail=986 cfURI: danica.zendulkova@cvtisr.sk cfPers Dbo.cfPers_EAddr cfPersId:SK98765 cfEAddrId SK56036_E02 cfStartDate 20000101 cfEndDate Dbo.cfPers cfPersId:SK98765 cfBirthdate:19700101 cfGender:F cfURI: http://www.cvtisr.sk/index/go.php?id=526&id_type=11&page=6&sort=2&sdir=ASC&id_detail=&param2=&param4=&id_detail=986 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.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. Dbo.cfPers_PAddr cfPersId:SK98765 cfPAddrId SK56036_P02 cfStartDate 20000101 cfEndDate SK CRIS. TG CERIF Meeting 18-19 August 2011

  19. cfResPubl dbo.cfResPubl 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/file/Aktivita%204.1/Statne_IS_o_vede_v_EU_final(1).pdf Dbo.cfResPublTitle cfResPublId SKPub00001 cfLangCode ENG cfTrans cfTitle: State operated research information systems in the EU Dbo.cfResPublKeyw cfResPublId SKPub00001 cfLangCode ENG cfTrans cfKeyw information system criteria, research information,euroCRIS, CERIF SK CRIS. TG CERIF Meeting 18-19 August 2011

  20. Thank you very muchfor your attention SK CRIS. TG CERIF Meeting 18-19 August 2011

More Related