Refatoração estrutural da base de dados do módulo Gestão RH do sistema SIAF-UFU

Abstract

Legacy systems support critical business routines, but periodic maintenance is required to ensure they remain key business assets. However, these systems may rely on legacy databases, and inadequate modeling of the database relational schemas can lead to system problems: lack of semantics, data inconsistency, a large number of null values, and even the inability to represent certain information. This work presents data normalization techniques within the structural refactoring method that minimize these issues. The complete data refactoring process is extremely complex and requires the dedication of a team of analysts within the organization. Consequently, the data normalization rules presented here were applied to the PESSOATIPORH table of the SIAF - HR Management subsystem database, and the results obtained were generalized to the other tables in the SIAF database. At the end of the development, the schema exhibited clear semantics, a reduction in null and redundant values, as well as the ability to represent certain information.