the urano system - uspwiki.icmc.usp.br/images/d/d2/scc5911scc5911integracaop2.pdfthe urano system !...

19
Data Integration and Data Provenance The Urano System Academic data from researches scattered among a variety of sources Heterogeneous sources may provide complementary, redundant and/or inconsistent data Administrative reports usually generated manually contain basically the same information, but are organized in different formats 19

Upload: others

Post on 17-Aug-2020

2 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

The Urano System

n  Academic data from researches q  scattered among a variety of sources

n  Heterogeneous sources q  may provide complementary, redundant and/or

inconsistent data n  Administrative reports

q  usually generated manually q  contain basically the same information, but are

organized in different formats

19

Page 2: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Objectives

n  Gathering academic data from distinct sources and integrating them into a central database

n  Enabling consistent reports to be generated automatically

Aiding the decision making and the institutional

administration

20

Page 3: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Data Sources

n  University’s corporate systems q  responsible for providing transactional data

relating to undergraduate and postgraduate educational activities

q  examples: the Júpiter and the Fênix systems (http://www.sistemas.usp.br)

n  External sources q  public sources containing academic data q  examples: Lattes Database (http://lattes.cnpq.br)

21

Page 4: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Main Categories of Reports

n  Lecturers, and their departments and personal information

n  Papers q  papers in journals, proceedings, books and book

chapters n  Supervisions

q  of undergraduate and postgraduate students n  Participation on examination boards

q  master, PhD

22

Page 5: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Main Categories of Reports

n  Participation in conferences and workshops n  Courses

q  undergraduate and postgraduate studies n  Projects, and their sponsors

q  projects, and their sponsors

23

Page 6: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Architecture

Extractor/Translator Lattes-Urano

Extractor/Translator Apolo-Urano

Júpiter

Apolo

...

Extractor/Translator Júpiter-Urano

Extractor/Translator Fênix-Urano

UranoSQL

UranoAdmin

Integration Subsystem

UranoWeb

Report Subsystem

Administrative Subsystem

administrator

investigator

researchers

Data Reconciler Tool

Integrated Database

Lattes Curricula

Auxiliary XML Documents

Fênix

USP Systems

24

Page 7: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

http://urano.icmc.usp.br

25

Page 8: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Interface

26

Page 9: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Reports

27

Page 10: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Example of a report

28

Page 11: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Example of a report

29

Page 12: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

List of Journal Publications

30

Page 13: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

List of Journal Publications

31

Page 14: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

List of Journal Publications

32

Page 15: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Report Composition

n  Investigator q  generates the format of a report that different

researchers should fill in

n  Researchers q  fill in the report according to their particular

academic data

33

Page 16: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

The Investigator’s View

34

Page 17: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

The Investigator’s View

35

Page 18: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

The Researchers’ View

36

Page 19: The Urano System - USPwiki.icmc.usp.br/images/d/d2/SCC5911SCC5911IntegracaoP2.pdfThe Urano System ! Academic data from researches " scattered among a variety of sources ! Heterogeneous

Data Integration and Data Provenance

Log Management

37