Speaker
Description
Modern data ecosystems are increasingly heterogeneous, with data and metadata distributed across multiple databases, file systems, and external services. This fragmentation creates challenges for organising data, managing systems, and enabling efficient access. This poster presents an approach for unifying access to distributed data sources using PostgreSQL Foreign Data Wrappers (FDWs). PostgreSQL FDWs allow external sources to be queried transparently as local tables, enabling seamless integration of relational databases, NoSQL stores, and file-based systems through a single SQL interface. We describe how FDWs are applied within our architecture to centralise access to both data and metadata, while preserving source autonomy and reducing unnecessary data duplication.