Reconciliation-Based Data Enrichment

Data enrichment is a crucial component of data preparation, aimed at improving the quality of input datasets by integrating external information from third-party sources. One approach to support this process is reconciliation-based data enrichment. In this approach, data providers organize their information around entities and expose reconciliation services for data consumers. Data consumers use these services to match tabular values in their data with entities in the source they want to access, enabling them to fetch additional information by querying the source with canonical identifiers. This approach reduces information asymmetry and facilitates access to external data, making enrichment more effective and user-friendly. The chapter introduces reconciliation-based enrichment, reviews current techniques for entity reconciliation in tabular data, and highlights the emerging role of large language models in supporting such tasks. Finally, it discusses the advantages of reconciliation-based enrichment with respect to sustainability principles, including reducing computational effort, limiting human intervention, and promoting resource efficiency in data preparation pipelines.