Unified Access Layer with PostgreSQL FDW for Heterogeneous Databases - Inria - Institut national de recherche en sciences et technologies du numérique
Communication Dans Un Congrès Année : 2017

Unified Access Layer with PostgreSQL FDW for Heterogeneous Databases

Xuefei Wang
  • Fonction : Auteur
  • PersonId : 1027959
Ruohang Feng
  • Fonction : Auteur
  • PersonId : 1027960
Wei Dong
  • Fonction : Auteur
  • PersonId : 1027961
Wenke Wang
  • Fonction : Auteur
  • PersonId : 1027963

Résumé

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
Origine Fichiers produits par l'(les) auteur(s)
Loading...

Dates et versions

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

Licence

Identifiants

Citer

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 Consultations
166 Téléchargements

Altmetric

Partager

More