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

https://hal.inria.fr/hal-01705437
Contributor : Hal Ifip <>
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

File

457609_1_En_14_Chapter.pdf
Files produced by the author(s)

Licence


Distributed under a Creative Commons Attribution 4.0 International License

Identifiers

Citation

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⟩

Share

Metrics

Record views

308

Files downloads

106