Study
User-Centred DesignNew This WeekModerate effect

Entity reconciliation in cultural heritage requires flexible, many-to-many modelling to accommodate inherent data ambiguity.

Direct, one-to-one mapping of entities is insufficient for reconciling diverse cultural heritage records due to inherent ambiguities, incomplete data, and varying cataloguing traditions.

Journal of Documentation · 2026

01

Key Findings

  • 01Entity reconciliation is rarely a one-to-one operation.
  • 02Ambiguities, incomplete data, shifting attributions, and varying practices significantly shape reconciliation outcomes.
  • 03Observed strategies include creating anonymous/collective entities, using umbrella terms, adding uncertainty qualifiers, and acknowledging unresolvable ambiguity.
02

Application

Design takeaway

Design systems for cultural heritage data to support many-to-many relationships and explicitly model uncertainty, rather than forcing one-to-one mappings.

How to apply

When designing a database for historical documents, allow for multiple authors, multiple subjects, and multiple locations to be associated with a single document.

Project actions

  • 01Consider how your design will handle situations where a single input relates to multiple outputs, or vice versa.
  • 02Think about how to visually represent uncertainty or multiple connections in your user interface.
03

Method & Evidence

AimWhat are the usability challenges and effective strategies for reconciling heterogeneous entity records across cultural institutions, particularly within art historical photo archives?
MethodCase Study
ProcedureThe study analyzed reconciliation workflows and cataloguing traditions within art historical photo archives, considering institutional contexts, data granularities, and modelling strategies.
ContextCultural heritage institutions, specifically art history and photographic archives.

Variables

IVData reconciliation workflow strategies (e.g., one-to-one vs. many-to-many modelling).
DVUsability challenges and effectiveness of reconciliation.
CVInstitutional cataloguing traditions, data granularity, specific cultural heritage domain (art history photo archives).
04

Strengths & Limitations

Strengths

  • +Focuses on a real-world, complex problem in digital humanities.
  • +Provides practical strategies observed in practice.

Limitations

The complexity of implementing a true many-to-many database structure can be a significant technical challenge for a design project.

Reliability & validity

The study's validity is strengthened by its focus on real-world case studies within specific institutional contexts. Reliability could be enhanced by a larger, more diverse sample of institutions and data types.

Think critically

How might the 'many-to-many' nature of entity reconciliation impact the user experience and the perceived trustworthiness of the information presented?

05

Design Principles

"Embrace ambiguity: Design systems that can represent and manage uncertainty and complex relationships, rather than assuming perfect, singular data."

This research highlights a critical usability challenge in digital humanities and cultural heritage informatics. Designers of databases, archival systems, and research platforms must move beyond simplistic data models to accommodate the complex, often non-linear relationships found in real-world historical data.

06

What This Means for Your Design

When you're trying to link up information from different places, like photos and art descriptions, it's not always a simple one-to-one match. Sometimes one photo can relate to many artworks, or one artwork can have many photos. You need to design your system to handle these 'many-to-many' connections and show when information isn't perfectly clear.

How to use in your project

  • 1.Reference this study when discussing the challenges of data modelling or user interface design for complex datasets.
  • 2.Use the findings to justify the need for flexible relationship types in your proposed design solution.
07

Add to My Project

08

Quick Cite

(2026). Many-to-many. Usability challenges of entity reconciliation in art history and photographic studies. Journal of Documentation. https://doi.org/10.1108/jd-09-2025-0284 Retrieved from https://designdex.org/study/981ce0e9-2855-4e99-9b58-e57986656df7/entity-reconciliation-in-cultural-heritage-requires-flexible-many-to-many-modelling-to-accommodate-inherent-data-ambiguity

Paragraph starter

This design project acknowledges the inherent complexities in data reconciliation, drawing upon research that highlights the inadequacy of one-to-one mapping for heterogeneous records (Daquino, Mambelli, & Kozlov, 2026). The findings suggest that systems must be designed to accommodate many-to-many relationships and explicitly model uncertainty to effectively manage ambiguous or incomplete data, a principle that will guide the development of the proposed solution.

09

Source

Journal of Documentation

Many-to-many. Usability challenges of entity reconciliation in art history and photographic studies

journal · 2026

View source

Questions about this research

What does the research say about entity reconciliation in cultural heritage requires flexible, many-to-many modelling to accommodate inherent data ambiguity?
Design systems for cultural heritage data to support many-to-many relationships and explicitly model uncertainty, rather than forcing one-to-one mappings. Evidence: Journal of Documentation (2026).
Why does "Entity reconciliation in cultural heritage requires flexible, many-to-many modelling to accommodate inherent data ambiguity." matter for design?
This research highlights a critical usability challenge in digital humanities and cultural heritage informatics. Designers of databases, archival systems, and research platforms must move beyond simplistic data models to accommodate the complex, often non-linear relationships found in real-world historical data.
How can designers apply this research?
Design systems for cultural heritage data to support many-to-many relationships and explicitly model uncertainty, rather than forcing one-to-one mappings.
What were the main findings?
Entity reconciliation is rarely a one-to-one operation.. Ambiguities, incomplete data, shifting attributions, and varying practices significantly shape reconciliation outcomes.. Observed strategies include creating anonymous/collective entities, using umbrella terms, adding uncertainty qualifiers, and acknowledging unresolvable ambiguity.
What research method was used?
Case Study.
How strong is the evidence?
Evidence strength is rated Moderate effect, based on a 2026 journal from Journal of Documentation.
What should I do differently in my next project?
When designing a database for historical documents, allow for multiple authors, multiple subjects, and multiple locations to be associated with a single document.
What are the limitations?
The study focuses on art historical photo archives, and findings may not directly translate to all types of cultural heritage data.
Is there evidence that cultural heritage affects design outcomes?
Reconciling historical records is complex, often involving multiple entities and requiring flexible approaches to handle incomplete or ambiguous information. This research highlights a critical usability challenge in digital humanities and cultural heritage informatics. Designers of databases, archival systems, and res Source: Journal of Documentation (2026).
Where does this entity reconciliation research apply?
Cultural heritage institutions, specifically art history and photographic archives. It sits within user-centred design research on designdex.org.

Related research topics

cultural heritage design research · evidence on cultural heritage · does cultural heritage improve design outcomes · entity reconciliation studies for designers · cultural heritage and entity reconciliation findings · user-centred design research evidence