Improving security by using a database management system for integrated statistical data analysis

Authors:
Vadym Khatsanovskyy;Jan-Eric Litton;Ruslan Fomkin
Affiliations:
Karolinska Institutet, Stockholm, Sweden;Karolinska Institutet, Stockholm, Sweden;Karolinska Institutet, Stockholm, Sweden
Venue:
Proceedings of the 4th International Workshop on Privacy and Anonymity in the Information Society
Year:
2011

Citing 5
Cited 0

Processing Queries with Expensive Functions and Large Objects in Distributed Mediator Systems

Proceedings of the 17th International Conference on Data Engineering
Remote access systems for statistical analysis of microdata

Statistics and Computing
Data integration through database federation

IBM Systems Journal
Remote access methods for exploratory data analysis and statistical modelling: Privacy-Preserving Analytics®

Computer Methods and Programs in Biomedicine
Federated Databases as a Basis for Infrastructure Supporting Epidemiological Research

DEXA '09 Proceedings of the 2009 20th International Workshop on Database and Expert Systems Application

Quantified Score

Hi-index	0.00

Visualization

Abstract

International research collaborations access and integrate data collected in different countries. For different reasons, e.g., legislation, data owners need to control who has access to and how their data are analyzed. The analysis of data is performed in statistical software, which is usually called on top of a data management system, e.g., a database management system (DBMS). Therefore access to data is controlled by the DBMS, while statistical analyses are usually controlled by another system. To improve security we propose a novel architecture for executing statistical analysis on data stored in a DBMS. In the proposed architecture the statistical software is called from a DBMS. The architecture allows control of both data retrieval and statistical data analysis from one system, i.e., DBMS. We implemented a prototype for executing analysis programs by calling statistical software SAS from a relational DBMS IBM DB2 over data stored in DB2 database. This paper describes the proposed architecture and the implemented prototype.