Otimização de base de dados de sistema de tramitação de processos governamentais
On-line Transaction Processing (OLTP) environments, or transactional environments, are database management systems generally designed to optimize the processing of short, real-time transactions where data is constantly changing. These solutions are usually very well designed for the recovery of all...
| Autor principal: | Gomes, Pedro Henrique de Andrade |
|---|---|
| Formato: | Trabalho de Conclusão de Curso (Especialização) |
| Idioma: | Português |
| Publicado em: |
Universidade Tecnológica Federal do Paraná
2023
|
| Assuntos: | |
| Acesso em linha: |
http://repositorio.utfpr.edu.br/jspui/handle/1/31717 |
| Tags: |
Adicionar Tag
Sem tags, seja o primeiro a adicionar uma tag!
|
| Resumo: |
On-line Transaction Processing (OLTP) environments, or transactional environments, are database management systems generally designed to optimize the processing of short, real-time transactions where data is constantly changing. These solutions are usually very well designed for the recovery of all information referring to an individual, however, they can have considerable loss of performance in the recovery based on clusters. In this work, a proof of concept is presented for the resolution of information retrieval problems in a well-known governmental process processing system. Substantiated proposals are presented, as well as the result of their deployments in a production environment, bringing gains: better database performance, improved user experience and savings in computational resources. |
|---|