Data Integration for Phone Users' Mobility Analysis
The aim of this paper is to develop methods for integrating external data with a mobile phone user data sample collected in Switzerland. The external data contains weather and stock price information, and the integration is done using locations and time stamps. We then analyze the resulting data using a multidimensional approach and statistical tools. Though the data is limited in scale, it indicates that weather or economic up/downturns do normally not affect the phone users' mobility very much, but there are exceptions.
Data used: 1. a subset of a phone user log data collected in Switzerland (large: millions of GPS events) 2. Meteo Swiss data about temperatures, rainfall at 18 weather stations 3. Swiss stock index figures.
Data integration by the R software package.
Virtual EZ Grid: A Volunteer Computing Infrastructure for Scientific Medical Applications
The Virtual EZ Grid (Switzerland, 2010-) project is based on the XtremWeb-CH (XWCH) volunteer computing platform. The goal of the project is to introduce a flexible distributed computing system, with (i) a non-trivial number of computing resources infrastructure from various institutes, (ii) a stable platform that manages these computing resources and provides advanced interfaces for applications, and (iii) a set of applications that take benefit of the platform. The article concentrates on the application support of the new version of XWCH and describes how a medical image application MedGIFT utilises it.
Technologies: Java EE, GlassFish server, distributed data.
Applications: Medical images.
Data Integration for Timely Report Production at the World Health Organization
In business intelligence, reporting is perceived by users as the most important area. Here, we present a case study of data integration for reporting within the World Health Organization (WHO).
WHO produces Communicable Disease Epidemiological Profiles for emergency affected countries. Given the nature of emergencies, the production of these reports should be timely. In order to automate the production of the reports, we have introduced a method of integrating data from multiple sources by using the RDF (Resource Description Framework) format. The model of the data is described using an RDF ontology, making validation of the data from multiple sources possible. However, since RDF is highly technical, we have designed a graphical tool for the end user. The tool can be used to configure the data sources of a given report. After this, data for the report is generated from the sources. Finally, templates are used to generate the reports.
Data used: country profiles and WHO provided up-to-date information about diseases in these countries.
Integration method: XML transformations, a web portal, live-linking with Microsoft Word.
Some preprints of published papers can be found here (prepared according to the publishers' copyright notice)
M. Niinimaki, T. Niemi: An ETL Process for OLAP Using RDF/OWL Ontologies, JODS, Springer, 2009.
In this article we generate OLAP (On-Line Analytic Processing) data repositories by using data sources that correspond with RDF ontologies. Since RDF is "the" language for the knowledge level of the semantic web, our method can be applied to harvest business data from the web.
M. Niinimaki, T. Niemi: Processing Semantic Web Queries in Grid, ITSSA, SIWN, 2008.
In this article we utilise the power of Grid computing in order to process complicated semantic web queries. We demonstrate that our method can be faster than traditional OLAP processing (but we do not say that it is easier).
Presentations
Digital Societies, a visiting lecture at Kasem Bundit University, January 2018