Federal database system based on foreign data wrapper
Yong Wen, Hao Zhang, Xihua Liu, Yuanlin Zhou, Wenjie Gao, Xmglin Zhu · 2022
Nowadays, the heterogeneity of databases and the diversity of systems lead to the independence of different systems and the inability to share data horizontally and vertically. It makes the data forming a data silo, between each system can only be stored in the local database. To eliminate the data isolation phenomenon between systems, because of the database heterogeneity caused by the difference of software, hardware and development mode. This paper realizes different Cross-domain connection and data exchange between system database, by building a federated database system through technologies such as PostgreSQL database extension, Foreign data wrapper and triggers. Through practical application verification, the results show that the federation database built by this paper can effectively realize the cross-domain connection and data exchange of heterogeneous databases, which effectively improves the data utilization value and productivity.