Skip to Main content Skip to Navigation
Conference papers

Unified Access Layer with PostgreSQL FDW for Heterogeneous Databases

Abstract : Large-scale application systems usually consist of various databases for different purposes. However, the increasing use of different databases, especially NoSQL databases, makes it increasingly challenging to use and maintain such systems. In this paper, we demonstrate a framework for designing a foreign data wrapper (FDW) for external data sources. We propose a novel method to access heterogeneous databases, including SQL and NoSQL databases, by using a unified access layer. This method was applied in some real business applications of Alibaba, in which we were able to do various operations on Redis, MongoDB, HBase, and MySQL by using a simple SQL statement. In addition, the information exchange and data migration between these databases can be done by using unified SQL statements. The experiments show that our method can maintain good database performance and provide users with a lot more convenience and efficiency.
Document type :
Conference papers
Complete list of metadata

Cited literature [8 references]  Display  Hide  Download
Contributor : Hal Ifip Connect in order to contact the contributor
Submitted on : Friday, February 9, 2018 - 2:25:54 PM
Last modification on : Tuesday, September 3, 2019 - 3:04:02 PM
Long-term archiving on: : Friday, May 4, 2018 - 2:36:06 AM


Files produced by the author(s)


Distributed under a Creative Commons Attribution 4.0 International License



Xuefei Wang, Ruohang Feng, Wei Dong, Xiaoqian Zhu, Wenke Wang. Unified Access Layer with PostgreSQL FDW for Heterogeneous Databases. 14th IFIP International Conference on Network and Parallel Computing (NPC), Oct 2017, Hefei, China. pp.131-135, ⟨10.1007/978-3-319-68210-5_14⟩. ⟨hal-01705437⟩



Record views


Files downloads