Volume 13 Number 9 (Sep. 2018)
Home > Archive > 2018 > Volume 13 Number 9 (Sep. 2018) >
JCP 2018 Vol.13(9): 1042-1052 ISSN: 1796-203X
doi: 10.17706/jcp.13.9.1042-1052

Design and Implementation of A Cross-Database Query Tool on Multi-Source Databases

Liang Liang1, Zhu Guangxin2, Li Yuqian2, Hu Junjun2
1State Grid Jiangxi Electric Power Company Information and Telecommunication Branch, Nanchang, Jiangxi, China.
2NARI Group Corporation, Nanjing, Jiangsu, China.

Abstract—With the rapid development of the company's business, and the demand for inter-business type data correlation inquiry, an easy and efficient cross-database query tool is urgently needed. Currently, the cross-database query method has the following problems: firstly, it can not meet the needs of multiple data sources; second, there are complicated operations and waste of resources; third, full real-time data can not be guaranteed. In order to solve these problems, this paper designs a cross-database query tool with multiple data sources, which is realized by adapters, distributed parallel collaborative query and heterogeneous data association. The tool can insert a variety of data sources through plug-in, shield different data source differences, use the unified SQL accessing to query relationship,and use the memory to ensure query efficiency and real-time。It does not store data itself, only as data processing Channel to reduce the waste of storage resources.

Index Terms—Cross-database query tool, multi-source databases, collaborative inquiry, related query.

[PDF]

Cite: Liang Liang, Zhu Guangxin, Li Yuqian, Hu Junjun, "Design and Implementation of A Cross-Database Query Tool on Multi-Source Databases," Journal of Computers vol. 13, no. 9, pp. 1042-1052, 2018.

General Information

ISSN: 1796-203X
Frequency: Monthly
Editor-in-Chief: Prof. Liansheng Tan
Executive Editor: Ms. Nina Lee
Abstracting/ Indexing: DBLP, EBSCO,  ProQuest, INSPEC, ULRICH's Periodicals Directory, WorldCat, CNKI,etc
E-mail: jcp@iap.org
  • Sep 13, 2018 News!

    Vol 13, No 10 has been published with online version   [Click]

  • Apr 28, 2019 News!

    Vol 14, No 4 has been published with online version 8 papers are published in this issue after peer review   [Click]

  • Mar 20, 2019 News!

    Vol 14, No 3 has been published with online version   [Click]

  • Feb 22, 2019 News!

    Vol 14, No 2 has been published with online version 8 papers are published in this issue after peer review   [Click]

  • Jan 04, 2019 News!

    Vol 14, No 1 has been published with online version   [Click]

  • Read more>>