A distributed database cross-database association query method and system

Abstract

The invention relates to a cross-database associated query method and system for a distributed database. The method comprises the steps of differentially dividing a cross-database management query sql into two sqls which are sql1 and sql2 respectively, wherein query field lists of the two sqls contain associated fields; when a sql1 query result returns a preset number of rows, assembling associated field values obtained by sql1 query and sql, and performing query; and finally combining query results and returning a combined query result to a client. According to the method and system, an sql table is horizontally split, so that associated query of two tables with data distributed in different database nodes is realized and the system usability is improved; and sql2 is sent after sql1 returns a certain number of data rows, so that the problem of excessive memory occupation caused by execution of sql2 after execution of sql1 is effectively avoided and the execution efficiency is improved.

Description

technical field [0001] The invention relates to the field of distributed databases and cloud computing, in particular to a distributed database cross-database association query method and system. Background technique [0002] In many key fields such as the Internet and telecommunications, with the continuous development of enterprise business, the I / T environment of enterprises is also constantly evolving. It is difficult for a single database to meet the requirements of massive database storage and high concurrent data access. The emergence of distributed databases has become Inevitably, distributed databases can effectively solve massive data storage and concurrency problems. Through horizontal alignment of data and vertical segmentation of data tables, massive data storage is effectively alleviated, and high Concurrency issues. However, the horizontal splitting of distributed database tables brings about the problem of cross-database association queries between tables af...

AI Technical Summary

Problems solved by technology

However, the horizontal splitting of distributed database tables brings about the problem of cross-database association queries between tables after data is distributed in different databases. Although table redundancy and table grouping can be used to avoid cross-database association queries between tables, However, there are still some business needs that cannot avoid the cross-database association query between tables through the above method, and need to perform cross-database association query between tables

However, the distributed database middleware does not really support the associated query between tables across databases, and the associated query cannot be implemented for two tables whose data is split on different database nodes.

Images