Doesburg, J.L.H. and Kaiser, R.B.J. (2009) Universitaire Persoons Registratie. Bachelor's Thesis, Industrial Engineering and Management.
![[img]](https://fse.studenttheses.ub.rug.nl/style/images/fileicons/text.png) |
Text
TBK-BA_2009_Joost_Doesburg.pdf - Published Version Restricted to RUG campus only Download (1MB) |
Abstract
This report identifies some problems surrounding master data management at the University of Groningen (RUG). Personal data from people that are registered in multiple databases is not consistent. To solve this problem, the RUG envisions a ‘Universitaire Persoons Registratie’ (UPR) system. Two database systems, Progress.NET and PeopleSoft, are analyzed and modeled. A federated system is designed using Object Role Modeling (ORM) and compared to a system proposed by the ‘Administratieve Infomatievoorziening’ AIV). The federated system, UPR, will act as a view on top of both databases. The main problems are: data migration, keeping data consistent and handling future mutations. Various mechanisms to keep the data consistent have been considered, a queuing mechanism is chosen. Data migration is a topic by itself, a start is being made in this report. Research revealed that Progress.NET does not capture the ‘Burger Servicenummer’ (BSN). This number, unique for every Dutch person, was to be the main variable for the migration process. The RUG should find other ways to capture the BSN, to simplify the migration. The system Progress.NET should be adapted, to handle future mutations and avoid numerous problems. There are many similarities between the UPR system designed with ORM and the one designed by the AIV. Main difference is that the ORM based model is conceptual and the one by the AIV has a lot of implementation details. Other differences are the way phone numbers and names are modeled, the AIV makes a mistake here.
| Item Type: | Thesis (Bachelor's Thesis) |
|---|---|
| Degree programme: | Industrial Engineering and Management |
| Thesis type: | Bachelor's Thesis |
| Language: | Dutch |
| Date Deposited: | 15 Feb 2018 07:30 |
| Last Modified: | 15 Feb 2018 07:30 |
| URI: | https://fse.studenttheses.ub.rug.nl/id/eprint/9089 |
Actions (login required)
 |
View Item |