The Tuscany's Observatory of Research and Innovation portal is an instrument to promote more transparent and inclusive governance in the region. We show its interactive dashboard and underlying SPARQL endpoint, powered by SIRIS Academic's UNiCS platform, which integrates Open Data on the Higher Education & Research field, following the Ontology-Based Data Access approach.
In line with the orientation adopted by the EU in its Europe 2020 strategy, the Italian region of Tuscany has defined a set of policies aimed at supporting the Higher Education and Research (HE&R) system, and promoting innovation in the Tuscan territory. Tuscany has provided the Regional Research and Innovation Observatory as a tool to support the implementation of the Regional Development Program (PRS 20016/201). The PRS is the cornerstone of regional policies: “[A] tool that expresses a vision for the future of Tuscany and proposes constructive dialogue with the actors of the territory” (E. Rossi, Region’s President, PRS introductory speech). This tool has the ambition to communicate and enhance the strengths of the research system, and to host information on research, innovation and higher education.
Within the Observatory, and in support of the PRS, the Tuscany Region has decided
to have an information dashboard capable of integrating HE&R data, keeping them up
to date, and supporting policy makers in designing their policies. This paper shows the
Observatory’s interactive dashboard, currently located at toscanaopenresearch.it2,
and the underlying SPARQL endpoint, which is powered by SIRIS Academic’s UNiCS
platform [
2Guest users can login with username/password: dao2017/dao2017
Local Governments & Public Administration
Department Regional Government
Directorate
Citizens KPIs EXPLORER FULL-FLEDGE ACCESS POINT Compliant SPARQL protocol service
Ontology Mappings ryLaaeenod itr e F
HE&R Open Data Tuscany Internal data END-USERs
DATA VISUALISATIONs, QUERY SYSTEM
OBDA LAYER
DATA SOURCEs
The paper is structured as follows. First, Section 2 introduces the underlying platform that provides data to the Observatory, then Section 3 describes the Observatory’s interactive dashboard.
University Analytics (UNiCS) integrates open data repositories about HE&R in Europe
and makes them available via a dedicated SPARQL endpoint [
In the context of the Tuscany’s Observatory, the core architecture of UNiCS includes
a relational DB into which the different Italian and European open data repositories have
been integrated, as per the Data Exchange [
4Ministero dell’Istruzione, dell’Universita` e della Ricerca: (i) Anagrafe nazionale studenti: anagrafe.miur.it; (ii) Cerca universita`: cercauniversita.cineca.it also datasets that are behind given SPARQL endpoints is an -ontop- extension we are currently working on in collaboration with the KRDB Research Centre5).
Currently, the Observatory consists mainly of an interactive dashboard, hosting data visualisations (co-designed with the relevant stakeholders) fed by the underlying UNiCS SPARQL endpoint. The visualisations are generated in real time by Javascript code running on the user’s browser, which interrogates the endpoint for the necessary data. Visualisations are interactive: the user can click on different components to drill down on the results being displayed, as well as apply filters to focus on a particular data subset. Pop-up windows are also displayed with additional information that is not originally provided by the visual representation of the data, once the user selects a specific item in it. As an example, Figure 2 shows the distribution of graduated students per Italian bachelor faculty, and the different colours are meant to represent the overall number of years they spent at the university. Once the user mouses over the graphic of a given faculty, a window appears with a summarized view of the data behind, showing numbers that are not visible in the original visualisation. Users can either download the data behind each visualisation or copy and paste the queries which generate those data (see Figure 3), and execute them, possibly modified according to new specific needs.
The dashboard is now conceptually divided into four main sections: Teachers & researchers (showing distributions per gender, age, and disciplinary sectors), Teaching (on student data, with provenance, success rates per bachelor and master degrees), Research at universities (on EU funded projects, relative/absolute budgets, targeted to public organisations), and Research at private companies (on EU/regional funded projects, targeted to private organisations).
The Observatory’s portal also includes a dedicated SPARQL endpoint and the LODE-powered documentation of the relative domain ontology6. The endpoint includes 5http://www.inf.unibz.it/krdb/, Free University of Bozen-Bolzano, Italy.
6http://34.250.237.252/toscana/sparql/docs/index.html a library of pre-defined queries that either refer to the dashboard visualisations or have been collaboratively specified with the managers of the regions to satisfy specific needs and strategic demands. Users that are not familiar with SPARQL can then profit of the library, modify existing queries and execute them. The portal’s visualisations and the SPARQL endpoint can be used by policy makers to get a better understanding of the current situation, and both monitor the effectiveness of recent policies and also be able to design new policies based on evidence rather than intuition.