CN105930407A - Cross-database associated query method and system for distributed database - Google Patents
Cross-database associated query method and system for distributed database Download PDFInfo
- Publication number
- CN105930407A CN105930407A CN201610238173.6A CN201610238173A CN105930407A CN 105930407 A CN105930407 A CN 105930407A CN 201610238173 A CN201610238173 A CN 201610238173A CN 105930407 A CN105930407 A CN 105930407A
- Authority
- CN
- China
- Prior art keywords
- sql1
- inquiry
- sql2
- response results
- sql
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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
The present invention relates to distributed data base and field of cloud calculation, particularly relate to a kind of distributed number
According to the inter-library relation query method in storehouse and system.
Background technology
In many key areas such as the Internet, telecommunications, along with the development of business event, enterprise
The I/T environment of industry is also constantly developing, and individual data storehouse has been difficult to meet mass data
Library storage and high concurrent data access, and the appearance of distributed data base becomes inevitable, distributed number
Can effectively solve mass data storage and concurrent problem according to storehouse, be suited by the level of data
With the vertical cutting of tables of data, effectively alleviate mass data storage, by load balancing,
High Availabitity, poll etc. alleviate high concurrent problem.But the level of distributed data base table splits band
Carry out data and be distributed in after disparate databases the problem of inter-library correlation inquiry between table, although be permissible
By table redundancy, the mode such as table packet is avoided correlation inquiry inter-library between table, but is still had
Some service needed can not avoid the inter-library correlation inquiry between table by the way, need into
Inter-library correlation inquiry between row table.But distributed data base middleware do not have real support across
Correlation inquiry between the table in storehouse, the table that two data split at disparate databases node cannot be real
Existing correlation inquiry.
Summary of the invention
The technical problem to be solved is for the deficiencies in the prior art, it is provided that Yi Zhongfen
The inter-library relation query method of cloth data base and system.
The technical scheme is that a kind of distributed data base across
Storehouse relation query method, comprises the steps:
S1, receives the correlation inquiry sql of two tables of cross-node；
S2, carries out sql fractionation according to associate field, correlation inquiry sql splits into single table and looks into
Ask sql1 and sql2；
S3, is sent to all database nodes corresponding to this table according to inquiry field row by sql1
Table is inquired about, and monitors sql1 execution response results, wherein inquires about list of fields
Comprise the associate field of two tables, perform response results and include associated field value；
S4, when the number of data lines listening to sql1 execution response results reaches preset value n,
The associated field value that single sql2 obtains according to sql1 inquiry is sent out as where filtercondition
The all database nodes delivering to this table corresponding are inquired about；
S5, merges the execution response results of sql1 and the execution response results of sql2, will close
Result after and returns to client, returns S4, until poll-final.
For achieving the above object, present invention also offers a kind of inter-library pass of distributed data base
Connection inquiry system, including:
Receiver module, for receiving the correlation inquiry sql of two tables of cross-node；
Split module, for carrying out sql fractionation according to associate field, correlation inquiry sql is torn open
It is divided into single table inquiry sql1 and sql2；
First enquiry module, for being sent to all database nodes that this table is corresponding by sql1
Inquire about according to inquiry list of fields, and sql1 execution response results is monitored, its
Middle inquiry list of fields comprises the associate field of two tables, performs response results and includes associated field value；
Second enquiry module, for reaching when the number of data lines listening to sql1 execution response results
During to preset value n, the associated field value that single sql2 is obtained according to sql1 inquiry as
All database nodes that where filtercondition is sent to this table corresponding are inquired about；
Return module, for by the execution response results of sql1 and the execution response results of sql2
Merging, the result after merging returns to client, until poll-final.
The invention has the beneficial effects as follows: the present invention is by becoming two by inter-library management inquiry sql difference
Individual sql, respectively sql1 and sql2, the inquiry list of fields of two sql comprises associate field,
When sql1 Query Result returns and presets line number, by the sql1 associated field value that obtains of inquiry with
Sql is assembled, says and inquires about, and is finally merged by Query Result, and returns to client.
Sql table level is split by the present invention, it is achieved data are distributed in two tables on disparate databases node
Between correlation inquiry, improve the ease for use of system；Wherein sql2 send opportunity be sql1 return
A certain amount of data row (such as 1000 results) performs afterwards, is prevented effectively from sql1 and has performed just to hold
Row sql2 causes the problem that committed memory is too much, improves execution efficiency.
Accompanying drawing explanation
Fig. 1 is a kind of distributed data base inter-library relation query method flow chart of the present invention；
Fig. 2 is a kind of distributed data base inter-library correlation inquiry system block diagram of the present invention；
Fig. 3 is correlation inquiry schematic flow sheet in the embodiment of the present invention.
Detailed description of the invention
Being described principle and the feature of the present invention below in conjunction with accompanying drawing, example is served only for
Explain the present invention, be not intended to limit the scope of the present invention.
As it is shown in figure 1, a kind of inter-library relation query method of distributed data base, including walking as follows
Rapid:
S1, receives the correlation inquiry sql of two tables of cross-node；
S2, carries out sql fractionation according to associate field, correlation inquiry sql splits into single table and looks into
Ask sql1 and sql2；
S3, is sent to all database nodes corresponding to this table according to inquiry field row by sql1
Table is inquired about, and monitors sql1 execution response results, wherein inquires about list of fields
Comprise the associate field of two tables, perform response results and include associated field value；
S4, when the number of data lines listening to sql1 execution response results reaches preset value n,
The associated field value that single sql2 obtains according to sql1 inquiry is sent out as where filtercondition
The all database nodes delivering to this table corresponding are inquired about；
S5, merges the execution response results of sql1 and the execution response results of sql2, will close
Result after and returns to client, returns S4, until poll-final.
Specifically, being implemented as of S2:
S2.1, carries out join analysis to correlation inquiry sql, obtains inquiring about list of fields, wherein
Inquiry list of fields comprises associate field；
S2.2, is analyzed obtaining master meter and sublist, wherein, closes joint investigation correlation inquiry sql
Asking the table the most first occurred in sql is master meter, and the rear table occurred is sublist；
S2.3, for analyzing master meter and sublist further, obtains the inquiry field of master meter respectively
List and filtercondition, and the inquiry list of fields of sublist and filtercondition, respectively obtain
Sql1 and sql2.
The present invention, by correlation inquiry is carried out join analysis, obtains inquiring about list of fields, enters
And analyze acquisition master meter and sublist, according to inquiry list of fields and the filtercondition of master meter and sublist,
The sql achieving correlation inquiry sql splits, and splits and obtains two single table inquiry sql, according to
The database node of correspondence is inquired about in the single table inquiry obtained respectively, it is achieved inter-library correlation inquiry.
S3 is implemented as:
S3.1, is analyzed sql1, if inquiry list of fields does not comprise associate field,
Then the inquiry list of fields at sql1 increases associate field in arranging, and performs S3.2, the most directly
Perform S3.2；
S3.2, carries out routing resolution to sql1, obtains sql1 all data bases to be performed
Node；
S3.3, asynchronous to each database node transmission sql1, and sql1 is performed response knot
Fruit is monitored.
The present invention first ensures that in inquiry list of fields and protects associate field, will association in the present invention
Field is as the connection tie of sql1 and sql2, it is achieved the tight association of inquiry.If therefore
Not comprising and first to add associate field, after confirming to comprise associate field, routing resolution obtains sql1
All database nodes to be performed, and then carry out asynchronous execution, it is provided that search efficiency.
S4 is implemented as:
S4.1, when the number of data lines listening to sql1 execution response results reaches preset value n,
The associated field value connect in sql1 execution response results is extracted and as sql2's
Where filtercondition, carries out assembly to sql2；
S4.2, carries out routing resolution to the sql2 after assembly, obtains sql2 institute to be performed
There is database node；
S4.3, asynchronous to each database node transmission sql2, and sql2 is performed response results
Monitor.
The present invention monitors the execution response results of sql1, when number of data lines reaches preset value,
Associated field value sql1 inquiry obtained is assembled with sql2, is carried out by the sql2 after assembly
Routing resolution, asynchronous execution etc., sql2 send opportunity be sql1 return a certain amount of data row (as
Article 1000, result) perform afterwards, it is prevented effectively from sql1 and has performed just to perform sql2 and cause and take
The problem that internal memory is too much, improves execution efficiency.
S5 is implemented as:
S5.1, performs response results complete the obtaining of sql2 inquiry, sql2 is performed response
Result and sql1 perform response results and carry out result according to inquiry list of fields and associated field value
Merge, the packet after being merged；
S5.2, the packet after merging returns to client.
The present invention is assembled with the accordingly result of sql1 when sql2 inquires corresponding data, returns
To client, improve response speed, improve search efficiency.
As in figure 2 it is shown, a kind of distributed data base inter-library correlation inquiry system, including: receive
Module, for receiving the correlation inquiry sql of two tables of cross-node；Split module, for according to
Associate field carries out sql fractionation, and correlation inquiry sql splits into single table inquiry sql1 and sql2；
First enquiry module, for sql1 is sent to all database nodes corresponding to this table according to
Inquiry list of fields is inquired about, and monitors sql1 execution response results, Qi Zhongcha
Ask the associate field that list of fields comprises two tables, perform response results and include associated field value；The
Two enquiry modules, for reaching default when the number of data lines listening to sql1 execution response results
During value n, single sql2 is inquired about the associated field value obtained as where mistake according to sql1
All database nodes that filter condition is sent to this table corresponding are inquired about；Return module, be used for
The execution response results of sql1 and the execution response results of sql2 are merged, the knot after merging
Fruit returns to client, until poll-final.
Specifically, described fractionation module includes: Join analytic unit, for correlation inquiry
Sql carries out join analysis, obtains inquiring about list of fields, and wherein inquiry list of fields comprises pass
Connection field；Sql analytic unit, for being analyzed acquisition master meter and son to correlation inquiry sql
Table, wherein, the table the most first occurred in correlation inquiry sql is master meter, and the table of rear appearance is
Sublist；Sql split cells, for analyzing master meter and sublist further, obtains master meter respectively
Inquiry list of fields and filtercondition, and the inquiry list of fields of sublist and filtercondition,
Respectively obtain sql1 and sql2.
First enquiry module includes: pretreatment unit, is analyzed sql1, if inquiry
List of fields does not comprise associate field, then the inquiry list of fields at sql1 increases association in arranging
Field, calls route resolving unit, otherwise directly invokes route resolving unit；The first via is by solving
Analysis unit, carries out routing resolution to sql1, obtains all data bases joint to be performed for sql1
Point；First performance element, asynchronous to each database node transmission sql1, and sql1 is held
Row response results is monitored.
Described second enquiry module includes: assembled unit, performs sound for listening to sql1
Should the number of data lines of result when reaching preset value n, sql1 will be met and perform the pass in response results
Connection field value extracts and as the where filtercondition of sql2, sql2 is carried out assembly；
Secondary route resolution unit, for the sql2 after assembly is carried out routing resolution, obtains sql2
All database nodes to be performed；Second performance element, saves to each data base for asynchronous
Point sends sql2, and monitors sql2 execution response results.
Described return module includes: combining unit, for inquiring about complete execution at sql2
After response results, the execution response results of sql2 is performed response results according to inquiry with sql1
List of fields and associated field value carry out result merging, the packet after being merged；Send single
Unit, the packet after merging returns to client.
In order to preferably describe query script, below as a example by the sql of cross-node:
Select a.id, a.name, b.title from a, b where a.id=b.id
Wherein the data of table a are distributed on node 1,2, the data of table b be distributed in node 3,
On 4:
Step 1, receives correlation inquiry sql；
Step 2: resolve correlation inquiry sql, split into 2 sql；
select a.id,a.name from a；
select b.id,b.title from b where id in(...)；
Step 3: send select a.id, a.name from a to node 1,2；
Step 4: monitor step 3 and perform response data packet, often returns line number equal to 1000 row
Time, send select b.id, b.title from b where id in (...) to node 3,4
Step 5: merge twice sql execution result and export client, return step 4, directly
To poll-final.
Specifically, as it is shown on figure 3, wherein correlation inquiry main body be customer table customer
With order table order, customer data are distributed in database node dn1 and dn2,
Order data are distributed in dn3 and dn4, and the meaning of one's words of correlation inquiry sql is: search id
It is title and the price of all commodity of the name of the client of 001 and purchase.
The foregoing is only presently preferred embodiments of the present invention, not in order to limit the present invention, all
Within the spirit and principles in the present invention, any modification, equivalent substitution and improvement etc. made, all
Within protection scope of the present invention should being included in.
Claims (10)
1. the inter-library relation query method of distributed data base, it is characterised in that comprise the steps:
S1, receives the correlation inquiry sql of two tables of cross-node；
S2, carries out sql fractionation according to associate field, and correlation inquiry sql splits into single table inquiry sql1
And sql2；
S3, is sent to sql1 all database nodes corresponding to this table and carries out according to inquiry list of fields
Inquiry, and sql1 execution response results is monitored, wherein inquiry list of fields comprises the pass of two tables
Connection field, performs response results and includes associated field value；
S4, when the number of data lines listening to sql1 execution response results reaches preset value n, by list sql2
The associated field value obtained according to sql1 inquiry is sent to, as where filtercondition, the institute that this table is corresponding
Database node is had to inquire about；
S5, merges the execution response results of sql1 and the execution response results of sql2, after merging
Result returns to client, returns S4, until poll-final.
A kind of inter-library relation query method of distributed data base, its feature
Being, S2 is implemented as:
S2.1, carries out join analysis to correlation inquiry sql, obtains inquiring about list of fields, wherein inquiry word
Duan Liebiao comprises associate field；
S2.2, is analyzed correlation inquiry sql obtaining master meter and sublist, wherein, correlation inquiry sql
In the table that the most first occurs be master meter, the rear table occurred is sublist；
S2.3, for master meter and sublist are analyzed further, obtain respectively master meter inquiry list of fields and
Filtercondition, and the inquiry list of fields of sublist and filtercondition, respectively obtain sql1 and sql2.
A kind of inter-library relation query method of distributed data base, its feature
Being, S3 is implemented as:
S3.1, is analyzed sql1, if inquiry list of fields does not comprise associate field, then at sql1
Inquiry list of fields row in increase associate field, perform S3.2, the most directly perform S3.2；
S3.2, carries out routing resolution to sql1, obtains sql1 all database nodes to be performed；
S3.3, asynchronous to each database node transmission sql1, and sql1 execution response results is supervised
Listen.
A kind of inter-library relation query method of distributed data base, its feature
Being, S4 is implemented as:
S4.1, when the number of data lines listening to sql1 execution response results reaches preset value n, will connect
Sql1 performs the associated field value in response results and extracts and as the where filtercondition of sql2,
Sql2 is carried out assembly；
S4.2, carries out routing resolution to the sql2 after assembly, obtains sql2 all data to be performed
Storehouse node；
S4.3, asynchronous to each database node transmission sql2, and sql2 execution response results is supervised
Listen.
A kind of inter-library relation query method of distributed data base, its feature
Being, S5 is implemented as:
S5.1, sql2 inquiry complete obtain perform response results, by the execution response results of sql2 with
Sql1 performs response results and carries out result merging according to inquiry list of fields and associated field value, is merged
After packet；
S5.2, the packet after merging returns to client.
6. a distributed data base inter-library correlation inquiry system, it is characterised in that including:
Receiver module, for receiving the correlation inquiry sql of two tables of cross-node；
Split module, for carrying out sql fractionation according to associate field, correlation inquiry sql is split into list
Table inquiry sql1 and sql2；
First enquiry module, for being sent to all database nodes corresponding to this table according to looking into by sql1
Ask list of fields to inquire about, and sql1 execution response results is monitored, wherein inquiry field row
Table comprises the associate field of two tables, performs response results and includes associated field value；
Second enquiry module, for reaching default when the number of data lines listening to sql1 execution response results
During value n, the associated field value that single sql2 obtains according to sql1 inquiry is sent out as where filtercondition
The all database nodes delivering to this table corresponding are inquired about；
Return module, for the execution response results of sql1 and the execution response results of sql2 are merged,
Result after merging returns to client, until poll-final.
A kind of distributed data base inter-library correlation inquiry system, its feature
Being, described fractionation module includes:
Join analytic unit, for correlation inquiry sql is carried out join analysis, obtains inquiring about field row
Table, wherein inquiry list of fields comprises associate field；
Sql analytic unit, for correlation inquiry sql is analyzed obtaining master meter and sublist, wherein,
The table the most first occurred in correlation inquiry sql is master meter, and the rear table occurred is sublist；
Sql split cells, for analyzing master meter and sublist further, obtains the inquiry word of master meter respectively
Duan Liebiao and filtercondition, and the inquiry list of fields of sublist and filtercondition, respectively obtain sql1
And sql2.
A kind of distributed data base inter-library correlation inquiry system, its feature
Being, the first enquiry module includes:
Pretreatment unit, is analyzed sql1, if inquiry list of fields does not comprise associate field,
Then the inquiry list of fields at sql1 increases associate field in arranging, and calls route resolving unit, the most directly
Call route resolving unit；
First route resolving unit, carries out routing resolution to sql1, obtains to be performed the owning of sql1
Database node；
First performance element, asynchronous to each database node transmission sql1, and sql1 is performed response knot
Fruit is monitored.
A kind of distributed data base inter-library correlation inquiry system, its feature
Being, described second enquiry module includes:
Assembled unit, for reaching preset value n when the number of data lines listening to sql1 execution response results
Time, perform the associated field value in response results extract meeting sql1 and as the where of sql2
Filtercondition, carries out assembly to sql2；
Secondary route resolution unit, for the sql2 after assembly is carried out routing resolution, obtains sql2 institute
All database nodes to be performed；
Second performance element, sends sql2 for asynchronous to each database node, and sql2 is performed sound
Should result monitor.
A kind of distributed data base inter-library correlation inquiry system, its feature
Being, described return module includes:
Combining unit, for performing after response results, by the execution of sql2 complete the obtaining of sql2 inquiry
Response results and sql1 perform response results and carry out result conjunction according to inquiry list of fields and associated field value
And, the packet after being merged；
Transmitting element, the packet after merging returns to client.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610238173.6A CN105930407B (en) | 2016-04-18 | 2016-04-18 | A kind of inter-library relation query method of distributed data base and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610238173.6A CN105930407B (en) | 2016-04-18 | 2016-04-18 | A kind of inter-library relation query method of distributed data base and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105930407A true CN105930407A (en) | 2016-09-07 |
| CN105930407B CN105930407B (en) | 2019-05-17 |
Family
ID=56838327
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610238173.6A Active CN105930407B (en) | 2016-04-18 | 2016-04-18 | A kind of inter-library relation query method of distributed data base and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105930407B (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107644060A (en) * | 2017-08-25 | 2018-01-30 | 国网辽宁省电力有限公司 | A kind of intelligent grid cross-node join methods based on E R stripping strategies |
| CN108021578A (en) * | 2016-11-03 | 2018-05-11 | 北京国双科技有限公司 | The relation query method and device of data file |
| CN109791543A (en) * | 2016-09-30 | 2019-05-21 | 华为技术有限公司 | Execute the control method and corresponding intrument of multi-table join operation |
| CN111125158A (en) * | 2019-11-08 | 2020-05-08 | 泰康保险集团股份有限公司 | Data table processing method, device, medium and electronic equipment |
| CN111581237A (en) * | 2019-02-15 | 2020-08-25 | 阿里巴巴集团控股有限公司 | Data query method, device and system and electronic equipment |
| CN111625561A (en) * | 2019-02-28 | 2020-09-04 | 华为技术有限公司 | Data query method and device |
| CN111639095A (en) * | 2020-05-27 | 2020-09-08 | 中信银行股份有限公司 | Data table query method, device and storage medium |
| CN111914151A (en) * | 2020-08-11 | 2020-11-10 | 上海毅博电子商务有限责任公司 | Association table object query optimization method |
| CN112835930A (en) * | 2021-03-03 | 2021-05-25 | 上海渠杰信息科技有限公司 | Database query method and device |
| CN113297250A (en) * | 2021-05-28 | 2021-08-24 | 北京思特奇信息技术股份有限公司 | Method and system for multi-table association query of distributed database |
| CN114143320A (en) * | 2021-09-01 | 2022-03-04 | 浪潮云信息技术股份公司 | Data gateway method and system based on distributed database |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102163195A (en) * | 2010-02-22 | 2011-08-24 | 北京东方通科技股份有限公司 | Query optimization method based on unified view of distributed heterogeneous database |
| CN103034735A (en) * | 2012-12-26 | 2013-04-10 | 北京讯鸟软件有限公司 | Big data distributed file export method |
| CN103455641A (en) * | 2013-09-29 | 2013-12-18 | 方正国际软件有限公司 | Crossing repeated retrieval system and method |
| CN103631910A (en) * | 2013-11-26 | 2014-03-12 | 烽火通信科技股份有限公司 | Distributed database multi-column composite query system and method |
| CN104123288A (en) * | 2013-04-24 | 2014-10-29 | 阿里巴巴集团控股有限公司 | Method and device for inquiring data |
| CN104394149A (en) * | 2014-11-26 | 2015-03-04 | 中国航天科工集团第二研究院七〇六所 | Complex event processing method based on parallel distributed architecture |
| CN104572676A (en) * | 2013-10-16 | 2015-04-29 | 中国银联股份有限公司 | Cross-database paging querying method for multi-database table |
| CN104731951A (en) * | 2015-03-31 | 2015-06-24 | 北京奇艺世纪科技有限公司 | Data query method and device |
| CN105302858A (en) * | 2015-09-18 | 2016-02-03 | 北京国电通网络技术有限公司 | Distributed database system node-spanning check optimization method and system |
| CN105404638A (en) * | 2015-09-28 | 2016-03-16 | 高新兴科技集团股份有限公司 | Method for solving correlated query of distributed cross-database fragment table |
-
2016
- 2016-04-18 CN CN201610238173.6A patent/CN105930407B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102163195A (en) * | 2010-02-22 | 2011-08-24 | 北京东方通科技股份有限公司 | Query optimization method based on unified view of distributed heterogeneous database |
| CN103034735A (en) * | 2012-12-26 | 2013-04-10 | 北京讯鸟软件有限公司 | Big data distributed file export method |
| CN104123288A (en) * | 2013-04-24 | 2014-10-29 | 阿里巴巴集团控股有限公司 | Method and device for inquiring data |
| CN103455641A (en) * | 2013-09-29 | 2013-12-18 | 方正国际软件有限公司 | Crossing repeated retrieval system and method |
| CN104572676A (en) * | 2013-10-16 | 2015-04-29 | 中国银联股份有限公司 | Cross-database paging querying method for multi-database table |
| CN103631910A (en) * | 2013-11-26 | 2014-03-12 | 烽火通信科技股份有限公司 | Distributed database multi-column composite query system and method |
| CN104394149A (en) * | 2014-11-26 | 2015-03-04 | 中国航天科工集团第二研究院七〇六所 | Complex event processing method based on parallel distributed architecture |
| CN104731951A (en) * | 2015-03-31 | 2015-06-24 | 北京奇艺世纪科技有限公司 | Data query method and device |
| CN105302858A (en) * | 2015-09-18 | 2016-02-03 | 北京国电通网络技术有限公司 | Distributed database system node-spanning check optimization method and system |
| CN105404638A (en) * | 2015-09-28 | 2016-03-16 | 高新兴科技集团股份有限公司 | Method for solving correlated query of distributed cross-database fragment table |
Non-Patent Citations (3)
| Title |
|---|
| 李仁庆 等: ""基于神经网络技术的异构数据库集成查询"", 《大连轻工业学院学报》 * |
| 李宗花 等: ""旅游目的地营销系统(DMS)中异构数据集成中间件的设计"", 《淮阴师范学院学报(自然科学版)》 * |
| 陈勇 等: ""异构数据库集成中间件的设计"", 《科学技术与工程》 * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11301470B2 (en) | 2016-09-30 | 2022-04-12 | Huawei Technologies Co., Ltd. | Control method for performing multi-table join operation and corresponding apparatus |
| CN109791543A (en) * | 2016-09-30 | 2019-05-21 | 华为技术有限公司 | Execute the control method and corresponding intrument of multi-table join operation |
| CN109791543B (en) * | 2016-09-30 | 2021-02-12 | 华为技术有限公司 | Control method for executing multi-table connection operation and corresponding device |
| CN108021578A (en) * | 2016-11-03 | 2018-05-11 | 北京国双科技有限公司 | The relation query method and device of data file |
| CN107644060A (en) * | 2017-08-25 | 2018-01-30 | 国网辽宁省电力有限公司 | A kind of intelligent grid cross-node join methods based on E R stripping strategies |
| CN111581237B (en) * | 2019-02-15 | 2023-06-09 | 阿里巴巴集团控股有限公司 | Data query method, device and system and electronic equipment |
| CN111581237A (en) * | 2019-02-15 | 2020-08-25 | 阿里巴巴集团控股有限公司 | Data query method, device and system and electronic equipment |
| CN111625561A (en) * | 2019-02-28 | 2020-09-04 | 华为技术有限公司 | Data query method and device |
| CN111125158A (en) * | 2019-11-08 | 2020-05-08 | 泰康保险集团股份有限公司 | Data table processing method, device, medium and electronic equipment |
| CN111125158B (en) * | 2019-11-08 | 2023-03-31 | 泰康保险集团股份有限公司 | Data table processing method, device, medium and electronic equipment |
| CN111639095A (en) * | 2020-05-27 | 2020-09-08 | 中信银行股份有限公司 | Data table query method, device and storage medium |
| CN111639095B (en) * | 2020-05-27 | 2023-03-31 | 中信银行股份有限公司 | Data table query method, device and storage medium |
| CN111914151A (en) * | 2020-08-11 | 2020-11-10 | 上海毅博电子商务有限责任公司 | Association table object query optimization method |
| CN112835930A (en) * | 2021-03-03 | 2021-05-25 | 上海渠杰信息科技有限公司 | Database query method and device |
| CN113297250A (en) * | 2021-05-28 | 2021-08-24 | 北京思特奇信息技术股份有限公司 | Method and system for multi-table association query of distributed database |
| CN114143320A (en) * | 2021-09-01 | 2022-03-04 | 浪潮云信息技术股份公司 | Data gateway method and system based on distributed database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105930407B (en) | 2019-05-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105930407A (en) | Cross-database associated query method and system for distributed database | |
| CN103532754B (en) | A kind of by high-speed internal memory, the system and method for distributed treatment massive logs | |
| CN106649630A (en) | Data query method and device | |
| CN110674154B (en) | Spark-based method for inserting, updating and deleting data in Hive | |
| CN105243169B (en) | A kind of data query method and system | |
| CN103034663B (en) | A kind of information search method and equipment | |
| WO2019118795A1 (en) | Dynamic lead generation | |
| CN107451208B (en) | Data searching method and device | |
| CN104778188A (en) | Distributed device log collection method | |
| CN106708826A (en) | Data processing method and apparatus, and data query method and apparatus | |
| CN104008199B (en) | A kind of data query method | |
| US20210319043A1 (en) | Multi-source data management mechanism and platform | |
| CN112995273A (en) | Network call-through scheme generation method and device, computer equipment and storage medium | |
| CN111026709B (en) | Data processing method and device based on cluster access | |
| CN113779094B (en) | Batch-flow-integration-based data processing method and device, computer equipment and medium | |
| CN106446289B (en) | Information query method and device based on Pinpoint | |
| CN111401684A (en) | Task processing method and device | |
| JPH07160557A (en) | Data base access processing method | |
| CN103714144A (en) | Device and method for information retrieval | |
| Muddasir et al. | Study of methods to achieve near real time ETL | |
| CN113127568A (en) | Method and device for data routing and database and table division of distributed memory database | |
| CN103902614B (en) | A kind of data processing method, equipment and system | |
| CN110399397A (en) | A kind of data query method and system | |
| CN112699183A (en) | Data processing method, system, readable storage medium and computer equipment | |
| CN105991331A (en) | Forum review method, device and log management device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |