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 (2006-2014); Bimonthly (Since 2015)
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]

  • Aug 06, 2018 News!

    Vol 13, No 1-No 8 has been indexed by EI (Inspec)   [Click]

  • Aug 06, 2018 News!

    Vol 12, No 6 has been indexed by EI (Inspec)   [Click]

  • Apr 24, 2018 News!

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

  • Dec 26, 2017 News!

    Vol 12, No 1-No 5 has been indexed by EI (Inspec)     [Click]

  • Read more>>