Digital Archives - Relational Databases

 

1.1. Digital Archives of Southwest Angola -a Relational Database

The dispersal of existing archives (administrative, cartographic and oral) and printed sources (press, theses, etc.) on the 4 current Angolan provinces of Namibe, Lubango, Cunene and Cuando-Cubango makes it necessary to centralise documentary references in a relational database. The virtual archive will be accompanied by the creation of a documentary centre to be set up in coordination with partner entities in Angola. To accompany these achievements, the project envisages joint publications (critical editions, synthesis works) and methodological training.

 

Objectives

  • Organise a digital platform divided by type of source but capable of advanced keyword searches;

  • create, in a data centre to be established in one of the Angolan partner entities, a physical database with digitised copies of reproduced documentary material

  • publish critical editions of documentary sources - such as the South of Angola sub-series in the Experiencias de África collection

  • provide methodological training support in the areas of archives, history and IT to partner organisations with teaching responsibilities

 

Methods and plan

  • In agreement with the institutional partners, draw up a 4-year plan, establishing the archives to be included in the 1st phase of the project (years 1 to 4)
  • organise a work plan for each archive
  • build the digital platform
  • plan data entry and co-management of the platform
  • planning the data search

 

Realisation indicators

  • Digital platform
  • 2 volumes of the South of Angola series

 

Project coordinator First Team Team tasks Main Partnerships
Augusto Lança
  • Éva Sebestyén
  • Jorge Teixeira
  • Maciel Santos
  • Coordination
  • Research assistance
  • Field missions
  • Data collection
  • Website design
  • Isced Huíla-Angola
  • ISCED Luanda -Angola

Stages of Realisation Start period Expected duration Internal evaluation Conclusion period
(1st stage of the 2025-27 project)
  • Face-to-face and online working sessions between the CEAUP team and local partners
01/2025
  • 6 months
  • 07/2025
  • 11/2025
  • Website development

02/2025

  • 10 months
  • 10/2025
  • 11/2025
  • Research in the archives of Lisbon, Luanda, Lubango and Benguela données
05/2025
  • 36 months
  • 11/2025
  • 11/2025
  • Data input
10/2025
  • 36 months
  • 01/2026
  • 11/2027
  • Methodological training to be coordinated with partners
08/2025
  • 36 months
  • 11/2025
  • 11/2027
Obs. There may be changes to deadlines for reasons specific to each project


1.7. Western Sahara War Archives- A Digital Archive for the 3rd phase of the Western Sahara War

Summary

This website aims to inform and organise data about the latest stage of the last colonial war in Africa, which started on 13th November 2020 in Western Sahara.
Is this a meaningful task in a society overloaded with news and data, in which some of the most profitable corporations belong to the media branch? More than five decades ago, some regretted that the market demand for facts had set up a fact-producing industry, in which journalists were now replacing scholars. As expected, when so much capital is poured into one branch, the unit cost of this particular good, news, tends now to zero. It is consensual, however, that something went wrong in the process. Since the “monstrous event” (which was the monumental label given by erudite historians of the 1960s for what is now just ordinary fake news in social networks), this branch of the industry has surely progressed in a peculiar way.

Objectives

  • Organisation of a digital platform divided by type of source, but capable of advanced keyword searches; 
  • Publishing statistical and cartographic analyses of the conflict
  • Publication of articles, working papers and books on the conflict,
  • Production and defence of master's theses
  • Training and methodological support in the areas of history, GIS, statistics applied to the social sciences and computer science for team members

Methods and Research Plan

  • Organisation of a work plan
  • Building and maintaining the digital platform
  • Planning data entry and co-management of the platform
  • Planning the data search
  • Realisation indicators

Indicadores de realização

  • Digital platform
  • Publication of at least 1 scientific article
  • Publication of at least 1 book
  • Organisation of at least 1 scientific event on the subject
  • Defence of at least 1 master's thesis
  • Publishing statistical and cartographic analyses of the conflict
Project Coordinator First Team Team tasks Main Partnerships
Jorge Teixeira
  • Helena Furtado
  • Isabel Lourenço
  • José Ramiro Pimenta
  • Maciel Santos
  • Tânia Mainsel
  • Co-ordination
  • Research assistance
  • Data collection
  • Analysing data
  • Cartography construction
  • Website design
  • Website maintenance

Stages of Realisation Start period Expected duration Internal evaluation Conclusion period
1st stage of the 2025 project
  • In-person and online working sessions between the CEAUP team and local partners
  • 01/2025
  • 6 months
  • 07/2025
  • 11/2025
2nd stage of the 2025 project
  • Website development 
  • 02/2025
  • 10 months
  • 10/2025
  • 11/2027
  • Creation of automated data collection systems
  • 12/2025
  • 36 months
  • 08/2026
  • 11/2027
  • Research in SPS archives, UN, media, European Parliament, US Congress
  • 02/2025
  • 36 months
  • 11/2025
  • 11/2027
3rd stage of the project 2026
  • Data input
  • 08/2025
  • 36 months
  • 01/2026
  • 11/2027

  • Publication of results
  • 08/2025
  • 36 months
  • 11/2025
  • 11/2027
Obs. There may be changes to deadlines for reasons specific to each project

 

R&D Supported by

R&D Unit integrated in the project number UIDB/00495/2020 (DOI 10.54499/UIDB/00495/2020) and UIDP/00495/2020.

 

Contacts

Centro de Estudos Africanos da Universidade do Porto
Via panorâmica, s/n
4150-564 Porto
Portugal

+351 22 607 71 41
ceaup@letras.up.pt