¹State Grid Jiangxi Electric Power Company Information and Telecommunication Branch, Nanchang, Jiangxi, China.
²NARI 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.