Comparison: Fine-Grained-Access Control to Governance Data in Relational Databases

Status: open
Supervisor: Alois Paulin

Problem Statement

Competing technologies address the challenge to provide dynamic multi-stakeholder access tailored to fit the context of the request for data and the identity of the requester. This so-called fine-grained-access control can be utilised for disruptive governance technology allowing for low-level access to governance data. The objective of this study is to identify the most suiting technology for this context.

Goal

The study will compare the features and provide a SWOT analysis of different technologies providing fine grained control of access to data stored in relational databases. The context of the evaluation is self-service access to governance data, as described in e.g. [1]. The technologies to be compared are the Oracle Virtual Private Database (VPD) and the in-house developed Secure SQL Server (SecSQL) system.

Workflow

  • Familiarisation with the technologies under comparison
  • Development of KPIs for the SWOT analysis
  • Publication of main findings
  • Bachelor/Master thesis (in English) and final presentation

Requirements

  • Strong analytical skills
  • Good command of written and spoken english
  • Ambitions to undertake further engage in disruptive technology for governance research and developments
  • SQL, C# / .Net

References

  1. Paulin, A. (2014): Through Liquid Democracy to Sustainable Non-Bureaucratic Government