Unified Access Layer with PostgreSQL FDW for Heterogeneous Databases - Network and Parallel Computing (NPC 2017)
Conference Papers Year : 2017

Unified Access Layer with PostgreSQL FDW for Heterogeneous Databases

Xuefei Wang
  • Function : Author
  • PersonId : 1027959
Ruohang Feng
  • Function : Author
  • PersonId : 1027960
Wei Dong
  • Function : Author
  • PersonId : 1027961
Wenke Wang
  • Function : Author
  • PersonId : 1027963

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.
Fichier principal
Vignette du fichier
457609_1_En_14_Chapter.pdf (499.61 Ko) Télécharger le fichier
Origin Files produced by the author(s)
Loading...

Dates and versions

hal-01705437 , version 1 (09-02-2018)

Licence

Identifiers

Cite

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⟩
215 View
167 Download

Altmetric

Share

More