<?xml version="1.0" encoding="UTF-8"?>
<TEI xml:space="preserve" xmlns="http://www.tei-c.org/ns/1.0" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://www.tei-c.org/ns/1.0 https://raw.githubusercontent.com/kermitt2/grobid/master/grobid-home/schemas/xsd/Grobid.xsd"
 xmlns:xlink="http://www.w3.org/1999/xlink">
	<teiHeader xml:lang="en">
		<fileDesc>
			<titleStmt>
				<title level="a" type="main">Publishing the 15 th Italian Population and Housing Census in Linked Open Data</title>
			</titleStmt>
			<publicationStmt>
				<publisher/>
				<availability status="unknown"><licence/></availability>
			</publicationStmt>
			<sourceDesc>
				<biblStruct>
					<analytic>
						<author>
							<persName><forename type="first">Raffaella</forename><surname>Aracri</surname></persName>
							<affiliation key="aff0">
								<orgName type="department">Istat -Istituto Nazionale di Statistica</orgName>
							</affiliation>
						</author>
						<author>
							<persName><forename type="first">Stefano</forename><surname>De Francisci</surname></persName>
							<affiliation key="aff0">
								<orgName type="department">Istat -Istituto Nazionale di Statistica</orgName>
							</affiliation>
						</author>
						<author>
							<persName><forename type="first">Andrea</forename><surname>Pagano</surname></persName>
							<affiliation key="aff0">
								<orgName type="department">Istat -Istituto Nazionale di Statistica</orgName>
							</affiliation>
						</author>
						<author>
							<persName><forename type="first">Monica</forename><surname>Scannapieco</surname></persName>
							<affiliation key="aff0">
								<orgName type="department">Istat -Istituto Nazionale di Statistica</orgName>
							</affiliation>
						</author>
						<author>
							<persName><forename type="first">Laura</forename><surname>Tosco</surname></persName>
							<affiliation key="aff0">
								<orgName type="department">Istat -Istituto Nazionale di Statistica</orgName>
							</affiliation>
						</author>
						<author>
							<persName><forename type="first">Luca</forename><surname>Valentino</surname></persName>
							<affiliation key="aff0">
								<orgName type="department">Istat -Istituto Nazionale di Statistica</orgName>
							</affiliation>
						</author>
						<title level="a" type="main">Publishing the 15 th Italian Population and Housing Census in Linked Open Data</title>
					</analytic>
					<monogr>
						<imprint>
							<date/>
						</imprint>
					</monogr>
					<idno type="MD5">DAD5DC0D8FF49106BDD9202FD56CEEFE</idno>
				</biblStruct>
			</sourceDesc>
		</fileDesc>
		<encodingDesc>
			<appInfo>
				<application version="0.7.2" ident="GROBID" when="2023-03-24T12:24+0000">
					<desc>GROBID - A machine learning software for extracting information from scholarly documents</desc>
					<ref target="https://github.com/kermitt2/grobid"/>
				</application>
			</appInfo>
		</encodingDesc>
		<profileDesc>
			<abstract>
<div xmlns="http://www.tei-c.org/ns/1.0"><p>The paper describes the first project that Istat, the Italian National Institute of Statistics, has set up for publishing data in LOD on its own SPARQL endpoint. Both the publication process and the underlying technical architecture are described with a focus on design choices (e.g. the adoption of RDF Data Cube Vocabulary for multidimensional data representation and the usage of R2RML for mapping rules specification) and on the adopted technological platform.</p></div>
			</abstract>
		</profileDesc>
	</teiHeader>
	<text xml:lang="en">
		<body>
<div xmlns="http://www.tei-c.org/ns/1.0"><head n="1">Introduction</head><p>National Statistical Institutes (NSIs) play an important role as data producers, by publishing Official Statistics in the service of citizens and policy-makers. Statistical production processes are indeed intended to produce "data" as their final output. An important phase of such processes is the dissemination phase, dedicated to the design and development of publication tools aimed to reach the widest possible range of users. In this respect, the Linked Data paradigm <ref type="bibr" target="#b0">[1]</ref> appears to be extremely promising as part of the dissemination strategy of NSIs. The increasing Internet penetration and the subsequent proliferation of electronic data exchanges, resulted in the study of new protocols, models and formats specific for the statistical data domain. Ten years work on searching and defining "a common language and a common perception of the structure of classifications and the links between them" has originated the Neuchâtel model, the first relevant standard for data and metadata representation <ref type="bibr">[2]</ref>.</p><p>In recent years, further standard statistical data models have emerged, namely GSIM and SDMX. GSIM (Generic Statistical Information Model) <ref type="bibr" target="#b1">[3]</ref> is a reference framework of internationally agreed concepts, attributes and relationships that describes the conceptual view of information relevant to Official Statistics production. SDMX (Statistical Data and Metadata Exchange) [4] is an ISO international standard, based on XML, available since 2004. It provides a framework (i.e., models, formats, guidelines, software tools, etc.) with the purpose of supporting the exchange of data and metadata. In addition to GSIM and SDMX, DDI (Document Data Initiative) [5] is also emerging as an XML based standard that can be possibly used for data and metadata representation in the statistical domain.</p><p>With respect to data standardization activities, NSIs are moving towards two directions; on the one hand they are promoting the development of models that are "adhoc" to the statistical domain, like SDMX; on the other hand, they are instead working for the purpose of extending the base of data users, going also beyond the established statistical users. The approach to achieve this latter goal involves the use of worldwide standard models and formats for data sharing, mainly Semantic Web standards. Indeed, several NSIs have set up a SPARQL endpoint for publishing their data in Linked Open Data (LOD) format, including INSEE (France) [20], EL.STAT (Greece) <ref type="bibr" target="#b13">[19]</ref> and CSO (Ireland) <ref type="bibr">[21]</ref>.</p><p>In this paper, we describe a project by Istat (the Italian National Institute of Statistics) aimed to publish indicators of the 2011 Population Census as Linked Open Data. The project, named Census-LOD, is a flagship project that also has the ambitious goal to pave the way for the introduction of LOD as a stable channel for Official Statistics dissemination.</p><p>The remaining of the paper is structured as follows. After providing an overview of the dissemination activities related to the latest Italian Population and Housing Census in Section 2, we present the main contribution of the paper in Section 3 by describing the process followed to publish Census data in LOD. In Section 4, we briefly discuss the certified publication of Istat data, while in Section 5 we conclude with final remarks.</p></div>
<div xmlns="http://www.tei-c.org/ns/1.0"><head n="2">The 15 th Italian Population and Housing Census: an Overview</head><p>The data collection phase of the 15 th Italian General Population and Housing Census begun in October 2011 and ended in early 2012. The first outputs were disseminated during 2012 (namely, provisional data and legal population). After the dissemination of the legal population, the correction and validation phase for data relating to individuals, households and buildings started. A large amount of statistical analyses are being available since May 2014 through the I.Stat system, the Istat Web warehouse <ref type="bibr" target="#b2">[6]</ref>. The reports disseminated via I.Stat have municipalities as the lowest detail of the territorial dimension. As for the previous Census editions, Istat plans to publish a defined subset of indicators also at the territorial level of Census section, which is a sub-municipality level. Currently, the Italian territory is divided into 400000 Census sections, so this level of publication concerns a huge amount of data that, in the past Census editions, were distributed as CSV or MS Excel files. A provisional version of these files is already available on the Web with a list of 43 indicators related to the population measures.</p><p>The number of published indicators is expected to grow to around 200 by December 2014 with the inclusion of population, households, dwellings and buildings.</p></div>
<div xmlns="http://www.tei-c.org/ns/1.0"><head n="3">The Census-LOD Project</head><p>The Census-LOD project aims to make available the Census data at the Census section level in LOD.</p><p>The Istat dissemination architecture is so far based mainly on SDMX; in particular, the machine-to-machine data exchange is implemented by a set of Web services that return SDMX data (the system is collectively called SEP -Single Exit Point).</p><p>Following the guidelines for the enhancement of the quality of public information <ref type="bibr" target="#b3">[7]</ref> distributed by the Agency for Digital Italy, Istat realized the need to broaden the dissemination to non-statistical/non-SDMX users and, in 2012, it started a project implementing a translator from SDMX to RDF Data Cube Vocabulary (RDF-QB) <ref type="bibr" target="#b4">[8]</ref>.</p><p>The realized translator was validated on real Istat datasets, which were selected in order to maximize their diversity with respect to both dataset number of observations and number of dimensions <ref type="bibr" target="#b5">[9]</ref>. We are working on the inclusion of the translator into the SEP architecture with the goal of reusing the huge work on metadata already carried out for SDMX-based dissemination.</p><p>Later, the possibility of publishing data directly according to LOD paradigm, was taken into consideration independently from the SDMX-based publishing process. In particular, with the Census-LOD project, we decided to develop a platform for the LOD dissemination of: (i) the Population Census indicators at the territorial level of Census sections, linked to (ii) the "Territory" dataset describing the Italian territorial structure including regions, provinces, municipalities and Census sections and to (iii) the "Geonames" ontology that is an international ontology for the description of physical and other territorial characteristics.</p><p>In more details, the Census-LOD project consisted of three main phases, specifically:</p><p>1. Domain analysis and ontology definition; 2. Triples generation; 3. LOD publishing.</p><p>In the following sections, we describe the above phases in details.</p></div>
<div xmlns="http://www.tei-c.org/ns/1.0"><head n="3.1">Domain Analysis and Ontology Definition Phase</head><p>As a first step of the project, we made an in-depth domain analysis, resulting in a conceptual model of the domain of interest. We started analyzing two datasets, named Censpop and Territory; such datasets were used to be published in previous Census editions as CSV and XLS files.</p><p>The Censpop dataset describes the population Census indicators at the territorial level of Census section. Table <ref type="table" target="#tab_0">1</ref> shows an excerpt of one of the Censpop files; only three of the total amount of about 200 indicators are shown, namely: (i) total population, (ii) male population and (iii) female population. The Territory dataset describes the Italian territorial features from both administrative and geographical perspectives. Fig. <ref type="figure" target="#fig_0">1</ref> shows an excerpt of one of the Territory file composed by several sheets, describing the territory in its different aspects as localities, municipalities, administrative zones etc. The amount of involved data is huge: there are about 402903 Census sections, 74482 localities, 2200 Census areas, 3631 geomorphological entities and 43 indicators for each entity (e.g., "Resident Population -Males", "Resident Population -age &gt; 74 years", "Foreigners and stateless persons resident in Italy -Males" and so on). In order to design the ontologies necessary for the data publication, we met periodically domain experts and interviewed them. In addition, we followed an abstraction process starting from the concrete data representations that we had at hand (i.e. CSV and Excel files). We designed two distinct ontologies: (i) the Territorial Ontology, and (ii) the Census Data Ontology. The Territorial Ontology is an OWL <ref type="bibr" target="#b6">[10]</ref> ontology and describes the administrative and the geographical organization of the territory. It is composed by:  95 entities, describing regions, provinces, municipalities, locations, census sections, special areas, special units (e.g., abbeys or hospitals), and so on.  About 200 roles, describing relationships between entities, e.g. appartieneAC-DASC links a municipality with its sub-municipalities components. Moreover, the ontology describes for each role its cardinalities and its inverse roles. For the entities having a corresponding definition in the Geonames ontology a relation of EquivalentTo has been defined with the relative Geonames entity. Finally, sub-ClassOf roles have been defined to descript the hierarchies between entities.</p><p>The Census Data Ontology has been written using the Data Cube Vocabulary <ref type="bibr" target="#b4">[8]</ref>, which is in turn based on OWL: it describes the Census data in terms of measures and dimensions for a total of:  Fig. <ref type="figure">2</ref> shows an example of an observation expressed with the Data Cube vocabulary. Both ontologies make use of meta Ontologies as: (i) SKOS <ref type="bibr" target="#b7">[11]</ref> for the description of classifications, (ii) ADMS <ref type="bibr">[12]</ref> for the description of interoperability assets, and (iii) PROV ontology <ref type="bibr" target="#b8">[13]</ref> for the description of the provenance of the data in terms of information about entities, activities, and people involved in the data production process.</p></div>
<div xmlns="http://www.tei-c.org/ns/1.0"><head n="3.2">Tr</head><p>The triple the LOD Fig. <ref type="figure">3</ref> sho ly produc into stagi formed u defined a map (i) th tologies. which we riples Genera es generation p format.</p><p>ows the desig ced as CSV f ing tables tha sing the direc a set of mapp he concepts s The rules def e followed the  In order to specify mapping rules we used R2RML <ref type="bibr" target="#b10">[15]</ref> that is the language for expressing customized mappings from relational databases to RDF datasets recommended by W3C. In Fig. <ref type="figure" target="#fig_3">4Fig</ref>. <ref type="bibr" target="#b1">3</ref> an example of R2RML mapping rule is shown. In particular, the rule maps each row in the logical table (base table, view or a valid SQL Query) to a number of RDF triples.</p><p>The mapping implementation can be on-demand or made by data materialization; in the first case the triples are created as a response to a query while, in the second case, they are materialized into the triple store. The triple store loading phase is completed by adding the new triples obtained as result of a reasoning phase; these rules are specified by the defined ontologies and are not coded by explicit mapping rules. </p></div>
<div xmlns="http://www.tei-c.org/ns/1.0"><head n="3.3">LOD Publishing Phase</head><p>The publishing phase includes a first step related to the choice of the Web application layer needed to access the triple store: specifically we provide three access points to cover the requirements of the different possible users interested to LOD data. As shown in Fig. <ref type="figure">5</ref>, the design of the Web site consists of three different components: (i) a SPARQL endpoint, (ii) a Linked Data Interface (Faceted/Graph browser) and (iii) an ad-hoc GUI for datasets downloading. Advanced users are supposed to be SPARQL knowledgeable and can directly access the SPARQL endpoint, which in turn can also be used for machine-to-machine communication. Basic users can instead use the Linked Data Interface to browse data or the ad-hoc application that provides a set of predefined queries and functionalities to build customized queries. The Linked Data API provides a configurable way to access RDF data using simple RESTful URLs that are translated into queries to a SPARQL endpoint. ELDA customization consists of writing down, using the turtle syntax [18], an API that specifies how to translate URLs into queries. Fig. <ref type="figure" target="#fig_4">6</ref> shows the complete technological architecture. People make trust judgments based on data provenance that may or may not be explicitly offered to them. Since the data represented in LOD format, are accessible via machine-to-machine communication, it is necessary to explicitly represent provenance information in an accessible way to machines, so that software agent can make trust judgments. This issue has been recognized extremely important, and, indeed, the Italian guidelines for the enhancement of public information <ref type="bibr" target="#b3">[7]</ref>, point out the issue of data provenance suggesting the usage of the W3C PROV Ontology <ref type="bibr" target="#b8">[13]</ref>. We used the PROV framework to certify the origin of the published data and the role of Istat as official data producer. In more details, we associated to data provenance metadata that specify who is responsible for the data, which are the entities, activities and agents involved in the generation/manipulation processes, allowing to certify data quality and reliability.</p></div>
<div xmlns="http://www.tei-c.org/ns/1.0"><head n="5">Conclusions</head><p>Census-LOD is the first project that deploys Istat data on a SPARQL endpoint that is owned by Istat itself. The publication of Census indicators at the sub-municipality level will be available in December 2014. Published data will be enriched with information related to the administrative and geo-morphological division of the national territory. All published data will be accompanied by their own formal semantics specification through the Territory and Census ontologies.</p><p>The LOD-based data dissemination will provide several benefits, including:</p><p> Fostering harmonization of information concepts also within Istat. Indeed, a schema integration step is necessary in order to publish data and this will also provide a positive feedback by forcing statistical processes to share a common data semantics.  Improving machine-to-machine data provisioning by Istat, by providing an RDFbased channel in addition to the already available SDMX one.  Providing final users with advanced functionalities like navigational querying and information discovery.</p></div><figure xmlns="http://www.tei-c.org/ns/1.0" xml:id="fig_0"><head>Fig. 1 .</head><label>1</label><figDesc>Fig. 1. Excerpt of Territory dataset</figDesc><graphic coords="5,136.08,191.88,379.80,296.46" type="bitmap" /></figure>
<figure xmlns="http://www.tei-c.org/ns/1.0" xml:id="fig_1"><head>Fig</head><label></label><figDesc>Fig. 2. Examp</figDesc></figure>
<figure xmlns="http://www.tei-c.org/ns/1.0" xml:id="fig_2"><head></head><label></label><figDesc>Fig. 3</figDesc></figure>
<figure xmlns="http://www.tei-c.org/ns/1.0" xml:id="fig_3"><head>Fig. 4 .</head><label>4</label><figDesc>Fig. 4. Mapping of "Area in Dispute" to the corresponding subject with predicate "Disput-edBy" and object "Municipaliy"</figDesc><graphic coords="7,124.74,291.42,345.84,181.44" type="bitmap" /></figure>
<figure xmlns="http://www.tei-c.org/ns/1.0" xml:id="fig_4"><head>Fig. 6 .</head><label>6</label><figDesc>Fig. 6. Functional and technological stacks</figDesc><graphic coords="9,135.00,219.42,325.32,181.08" type="bitmap" /></figure>
<figure xmlns="http://www.tei-c.org/ns/1.0" type="table" xml:id="tab_0"><head>Table 1 .</head><label>1</label><figDesc>Excerpt of Censpop Dataset</figDesc><table /></figure>
		</body>
		<back>
			<div type="references">

				<listBibl>

<biblStruct xml:id="b0">
	<monogr>
		<ptr target="http://linkeddata.org/" />
		<title level="m">Linked Data</title>
				<imprint/>
	</monogr>
</biblStruct>

<biblStruct xml:id="b1">
	<monogr>
		<ptr target="http://www1.unece.org/stat/platform/display/metis/Generic+Statistical+Information+Model" />
		<title level="m">GSIM</title>
				<imprint/>
	</monogr>
</biblStruct>

<biblStruct xml:id="b2">
	<analytic>
		<title/>
		<ptr target="http://dati.istat.it" />
	</analytic>
	<monogr>
		<title level="j">I.Stat</title>
		<imprint/>
	</monogr>
</biblStruct>

<biblStruct xml:id="b3">
	<monogr>
		<ptr target="http://www.agid.gov.it/sites/default/files/linee_guida/patrimoniopubblicolg2014_v0.6.pdf" />
		<title level="m">Linee Guida per la valorizzazione del patrimonio informativo pubblico</title>
				<imprint>
			<date type="published" when="2014">2014</date>
		</imprint>
	</monogr>
</biblStruct>

<biblStruct xml:id="b4">
	<monogr>
		<ptr target="http://www.w3.org/TR/2013/CR-vocab-data-cube-20130625/" />
		<title level="m">RDF Data Cube Vocabulary</title>
				<imprint>
			<date type="published" when="2013-06-25">25 June 2013</date>
		</imprint>
	</monogr>
</biblStruct>

<biblStruct xml:id="b5">
	<analytic>
		<title level="a" type="main">Integrating Statistical Data with the Semantic Web: The ISTAT Experience&quot; negli Atti della</title>
		<author>
			<persName><forename type="first">R</forename><surname>Aracri</surname></persName>
		</author>
		<author>
			<persName><forename type="first">S</forename><surname>De Francisci</surname></persName>
		</author>
		<author>
			<persName><forename type="first">A</forename><surname>Pagano</surname></persName>
		</author>
		<author>
			<persName><forename type="first">M</forename><surname>Scannapieco</surname></persName>
		</author>
		<author>
			<persName><forename type="first">L</forename><surname>Tosco</surname></persName>
		</author>
		<author>
			<persName><forename type="first">L</forename><surname>Valentino</surname></persName>
		</author>
	</analytic>
	<monogr>
		<title level="m">Congresso Nazionale AICA &quot;Frontiere Digitali: dal Digital Divide alla Smart Society</title>
				<imprint>
			<date type="published" when="2013-09">Settembre 2013</date>
			<biblScope unit="page" from="8" to="20" />
		</imprint>
	</monogr>
</biblStruct>

<biblStruct xml:id="b6">
	<monogr>
		<ptr target="http://www.w3.org/TR/owl-ref/" />
		<title level="m">Ontology Web Language</title>
				<imprint>
			<date type="published" when="2004-02-10">10 February 2004</date>
		</imprint>
	</monogr>
</biblStruct>

<biblStruct xml:id="b7">
	<monogr>
		<ptr target="https://joinup.ec.europa.eu/asset/adms/home" />
		<title level="m">Simple Knowledge Organization System</title>
				<imprint>
			<date>18 August 2009 12</date>
		</imprint>
	</monogr>
	<note>Asset Description Metadata Schema</note>
</biblStruct>

<biblStruct xml:id="b8">
	<monogr>
		<ptr target="http://www.w3.org/TR/2013/NOTE-prov-overview-20130430/" />
		<title level="m">PROV Ontology</title>
				<imprint>
			<date type="published" when="2013-04-30">30 April 2013</date>
		</imprint>
	</monogr>
</biblStruct>

<biblStruct xml:id="b9">
	<monogr>
		<ptr target="http://www.w3.org/2011/gld/wiki/223_Best_Practices_URI_Construction" />
		<title level="m">W3C</title>
				<imprint>
			<date type="published" when="2011">2011</date>
		</imprint>
	</monogr>
</biblStruct>

<biblStruct xml:id="b10">
	<monogr>
		<ptr target="http://www.w3.org/TR/r2rml/" />
		<title level="m">RDB to RDF Markup Language</title>
				<imprint>
			<date type="published" when="2012-09-27">27 September 2012</date>
		</imprint>
	</monogr>
</biblStruct>

<biblStruct xml:id="b11">
	<monogr>
		<title level="m" type="main">A survey of RDB to RDF translation approaches and tools</title>
		<author>
			<persName><forename type="first">F</forename><surname>Michel</surname></persName>
		</author>
		<author>
			<persName><forename type="first">J</forename><surname>Montagnat</surname></persName>
		</author>
		<author>
			<persName><forename type="first">C</forename><surname>Faron-Zucker</surname></persName>
		</author>
		<ptr target="http://hal.archives-ouvertes.fr/hal-00903568No-vember2013" />
		<imprint/>
	</monogr>
	<note type="report_type">Research report</note>
</biblStruct>

<biblStruct xml:id="b12">
	<monogr>
		<title/>
		<author>
			<persName><surname>Elda</surname></persName>
		</author>
		<ptr target="http://www.epimorphics.com/web/tools/elda.html" />
		<imprint/>
	</monogr>
</biblStruct>

<biblStruct xml:id="b13">
	<monogr>
		<author>
			<persName><surname>El</surname></persName>
		</author>
		<ptr target="http://linked-statistics.gr/" />
		<title level="m">STAT RDF site</title>
				<imprint/>
	</monogr>
</biblStruct>

				</listBibl>
			</div>
		</back>
	</text>
</TEI>
