Please use this identifier to cite or link to this item:
Title: Diseño de la migración de una base de datos legacy IDMS a una base de datos relacional Postgres
Author: Daza Povedano, Cristian
Tutor: Ferrer Durán, Jordi
Others: Cobarsí-Morales, Josep  
Abstract: The objective of this work is to design and apply some series of processes that allow migrating the structure of an IDMS hierarchical database to a more current relational database such as PostgreSQL. The main objective is not the data migration itself, but to define a process that can be applied to any other IDMS database. This migration would allow a company to improve its systems, as well as ease integration with existing ERP and applications, while reducing the ever-increasing costs imposed by CA IDMS as well as the shortage of professionals. In order acomplish it, in a first step some equivalences between structures will be established and a series of initial rules will be defined for the transformation of the components. Later, as an iterative process, the standardization and identification of improvements will be carried out. As a final conclusion, the objective has been achieved, covering as many aspects as possible (indexes, functions, triggers, or query optimization, among others) and obtaining a functional PostgreSQL database.
Keywords: IDMS
Document type: info:eu-repo/semantics/bachelorThesis
Issue Date: 23-Jun-2023
Publication license:  
Appears in Collections:Treballs finals de carrera, treballs de recerca, etc.

Files in This Item:
File Description SizeFormat 
cdazapTFG0623presentacion.zipPresentación del TFG499,54 MBUnknownView/Open
cdazapTFG0623producto.zipProducto6,91 kBUnknownView/Open
cdazapTFG0623memoria.zipMemoria del TFG1,64 MBUnknownView/Open
View statistics

This item is licensed under aCreative Commons License Creative Commons