3007 14282 1 PB

MODELAGEM DE PROCESSOS DE REFATORAÇÃO DE BANCO DE DADOS
UTILIZANDO BPMN
Márcia Beatriz Pereira Domingues (Universidade de São Paulo, São Paulo, Brasil) [e-mail]
Jorge Rady de Almeida Jr. (Universidade de São Paulo, São Paulo, Brasil) [e-mail]
Francisco Carlos Paletta (Universidade de São Paulo, São Paulo, Brasil) - [e-mail]
Projecting and maintaining a database is an important challenge, due to the frequent requirement of changes demanded by the users. To support those changes, the database schema must go through structural modifications that, many times, affect its performance and the queries' results, such as: un necessary relationships, primary and foreign keys strongly attached to the domain; obsolete attributes and types of attributes which are inadequate. The literature about Agile Methods for software development suggests the use of refactoring for the evolution of the database’s schema, when there are requirement changes. A refactoring is a simple change that improves the design but does not alter the database semantics nor adds new functionalities. Each refactoring has a group phases to be performed, which makes the implementation process possible. However, some changes on the database demand many refactoring to be made in the same process, which means that they can be combined and many steps can be suppressed. In this context, the present work aims at presenting how the refactoring phases can be modeled using processes notation
Keywords: Database Refactoring, BPMN, Database Maintenance
MODELAGEM DE PROCESSOS DE REFATORAÇÃO DE BANCO DE DADOS
UTILIZANDO BPMN
O projeto e manutenção de bancos de dados é um importante desafio, tendo em vista as frequentes mudanças de requisitos solicitados pelos usuários. Para acompanhar essas mudanças o modelo do banco de dados deve passar por alterações estruturais que muitas vezes prejudicam o desempenho e o projeto das consultas, tais como: relacionamentos desnecessários, chaves primárias ou