Development of a database migration and compatibility system

Pereira, Marcos Vinícius Alves

http://hdl.handle.net/10198/34591

Use this identifier to reference this record.

Name:	Description:	Size:	Format:
Marcos Pereira.pdf		4.08 MB	Adobe PDF	Download

Send Feedback

Authors

Pereira, Marcos Vinícius Alves

Advisor(s)

Alves, Paulo

Cadavez, Vasco

Leite, Mateus

Abstract(s)

Biological hazards, such as bacteria, viruses, and parasites, pose significant threats to human health when encountered through inhalation, ingestion, or skin contact. The Pathogens-in-Foods (PIF) database was established to address these concerns, serving as a centralized resource for accessing information about food borne pathogens in Europe. The European Food Safety Authority (EFSA) plays a pivotal role in ensuring food and feed safety within the European Union. However, the EFSA and PIF databases employ different data structures, making compatibility and data migration essential to enhance the relevance of PIF. This thesis focuses on the development of a data migration and compatibility system, allowing seamless communication between the PIF and EFSA databases. Through this system, the databases can align their information more effectively, ultimately improving food safety and public health. Using Python data migration scripts, it was possible to migrate the old PIF database to EFSA standards, making the two databases compatible. The script was developed following a system of classes, making it possible to use these same classes for future migrations if necessary or even migrations to other databases. The compatibility system developed offers the possibility of converting variables between different databases without the need for data migration. This system is especially useful for variables or entities that cannot or should not undergo the data migration process. In this way, the system operated as a conversion system, making PIF entities compatible with EFSA variables.