A STUDY OF DATABASE MIGRATION: UNDERSTANDING THE USER EXPERIENCE

This thesis reports on a participatory field study of a database migration project. The purpose of the study is to understand the user experiences in the database migration. Both the field observations during the process and the post-migration user interviews provided valuable data to gain insight into what challenges the users faced and how they adapted to the new database. The findings suggest that the users were generally positive about the new database, although they were still not entirely confident about the system’s outputs or certain functions. They developed strategies to ensure data accuracy: keeping paper archives to check outputs and postponing implementation of certain modules. Some of the challenges were due to the missing vital steps in data migration, such as data migration without performing data cleaning first. The year-long learning and interaction with the database have not resulted in a coherent mental model of the database; the contributing factors include 1) the complexity of the back-end database schema, 2) the inclusive all-in-one front-end interface design, and 3) the disadvantage of the generic trainer-based training sessions held before the data migration. From this study, we provide five recommendations for a robust data migration process: 1) data cleaning before migration, 2) incorporating elements to help build adequate mental models, 3) training on the migrated real database (never on a demo database), 4) customizability to hide unused tabs and functions, 5) creating task-based user guides.