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

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.