CN102201010A - Distributed database system without sharing structure and realizing method thereof - Google Patents
Distributed database system without sharing structure and realizing method thereof Download PDFInfo
- Publication number
- CN102201010A CN102201010A CN2011101710324A CN201110171032A CN102201010A CN 102201010 A CN102201010 A CN 102201010A CN 2011101710324 A CN2011101710324 A CN 2011101710324A CN 201110171032 A CN201110171032 A CN 201110171032A CN 102201010 A CN102201010 A CN 102201010A
- Authority
- CN
- China
- Prior art keywords
- data
- serving node
- data serving
- sql statement
- acting server
- 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.)
- Pending
Links
Images
Abstract
The invention discloses a distributed database system without a sharing structure and a realizing method thereof, relating to the technical field of the database. The system comprises a client, a proxy server and a plurality of data service nodes, wherein the client is connected with the proxy server for transmitting data requests to the proxy server; the proxy server is connected with the data service nodes for forwarding the data requests to the data service nodes; and the data service nodes are used for receiving the data requests, performing corresponding database operation after structured query language (SQL) sentences in the data requests are optimized, and returning the arranged and summarized operation result to the client. The system and the realizing method thereof ensure that the processing work to the data requests is transferred from the proxy server to the data service nodes, so that the functions of the proxy server are simplified, and the bottleneck limit of the proxy server to the whole database system is relieved.
Description
Technical field
The present invention relates to database technical field, particularly a kind of distributed data base system and its implementation of not having shared framework.
Background technology
Distributed data base system comprises distributed data base management system (DDBMS) and distributed data base.In distributed data base system, an application program can be carried out transparent visit and operation to entire database, the DATA DISTRIBUTION in the entire database is stored in the different local data banks, by different data base management system (DBMS)s manage, operation on different servers, by different operating system supports, linked together by different communication networks.Distributed data base system mainly contains following characteristics: have architectural framework flexibly; Adapt to distributed management and control architecture; Economic performance is superior; Reliability height, the availability of system are good; The response speed of topical application is fast; Favorable expandability is easy to integrated existing systems.
Distributed data base system has two kinds of traditional frameworks, and a kind of is to share framework, and another kind is not have the framework of sharing.
Adopt and share the shared identical data of distributed data base system that framework is realized, all can regard local file as in use, therefore when a plurality of users of processing ask continuously, can carry out associative operation concurrently, shorten the Whole Response time, but single request can't be assigned on other data serving nodes and handle simultaneously, to improve response speed.
Fig. 1 is the structural drawing that traditional nothing is shared the distributed data base system of framework, in this distributed data base system, DATA DISTRIBUTION is stored on a plurality of data serving nodes and realizes partial redundance, single request can be assigned to according to the distribution of data on a plurality of data serving nodes and handle simultaneously, but because acting server is responsible for the optimization of SQL statement and the integration of all request results, it is the performance bottleneck of whole distributed data base system, when having the mass data request, can influence the response speed of entire system.
Summary of the invention
(1) technical matters that will solve
The technical problem to be solved in the present invention is: how a kind of distributed data base system and its implementation of not having shared framework is provided, becomes the problem of the performance bottleneck of whole distributed data base system to overcome acting server.
(2) technical scheme
For solving the problems of the technologies described above, the invention provides a kind of distributed data base system of not having shared framework, it comprises: client, acting server and a plurality of data serving node;
Described client, connect described acting server, be used for sending request of data to described acting server, perhaps be used to receive the link information of described data serving node, and send described request of data to described data serving node after setting up session according to described link information and described data serving node;
Described acting server connects described data serving node, is used for described request of data is transmitted to described data serving node, perhaps sends the link information of described data serving node to described client;
Described data serving node is used to receive described request of data, after the SQL statement optimization process in the described request of data, carries out corresponding database operation, and returns to described client after the operating result arrangement gathered.
Preferably, described system also comprises the data dictionary module of a plurality of storage identical information; Described acting server is connected a described data dictionary module respectively with data serving node, described data dictionary module is used for storing the address of the tables of data that described data serving node comprises at the address of network, described data serving node, and the address of the table subregion that comprises of described tables of data.
Preferably, described system also comprises backup server, and the described data dictionary module that is connected with described backup server; Described backup server also connects described acting server, is used for replacing when described acting server breaks down described acting server.
Preferably, described system also comprises switch, described acting server connects a plurality of described data serving nodes simultaneously by described switch, and described client is set up session by described switch and described data serving node after receiving the link information of described data serving node.
Preferably, described system also comprises a plurality of data memory modules, and described data memory module connects described data serving node, is used to store the tables of data that described data serving node comprises.
The present invention also provides a kind of described nothing to share the implementation method of the distributed data base system of framework, and it comprises step:
A: when the request of data of client transmission comprises the SQL statement of setting up table space, acting server is broadcasted the described SQL statement of setting up table space in comprising the network of a plurality of data serving nodes, described data serving node receives the described SQL statement of setting up table space, according to the address information of the described data serving node of appointment wherein, set up table space and upgrade the data dictionary module, perhaps only upgrade described data dictionary module;
B: when the request of data of described client transmission comprises the SQL statement of setting up tables of data, described acting server is broadcasted the described SQL statement of setting up tables of data in comprising the network of a plurality of described data serving nodes, described data serving node receives the described SQL statement of setting up tables of data, according to table subregion and table space information wherein, set up tables of data and upgrade described data dictionary module, perhaps just upgrade described data dictionary module;
C: when the request of data that sends when described client comprises the SQL statement of the write operation of data table, described acting server is broadcasted the SQL statement of described write operation in comprising the network of a plurality of described data serving nodes, described data serving node receives the SQL statement of described write operation, according to tables of data and table subregion wherein, return error message, perhaps do not respond described request of data, perhaps carry out write operation and return the write operation result;
D: when the request of data that sends when described client comprises the SQL statement of the read operation of data table, described acting server returns to the link information of a data service node of described client, according to described link information, described client and described data serving node send described request of data to described data serving node after setting up session; Perhaps, described acting server is transmitted to a data service node with described request of data; The data serving node that receives request of data according to the SQL statement of described read operation, is carried out inquiry as the mandatory administration node, and Query Result is returned to described client.
Preferably, described method also comprises step:
E: when the data serving node in the distributed data base system of adding the shared framework of described nothing, by the configuration file of revising described acting server the link information of newly-increased data serving node is set, and finishes the operation of the described data serving node of interpolation by described acting server.
Preferably, described acting server is finished the operation of adding described data serving node and specifically be may further comprise the steps:
S1: described acting server obtains described nothing by the data dictionary module and shares all data serving nodes and the loading condition of showing subregion in the distributed data base system of framework, selects overload data serving node and overload table subregion;
S2: the data in the described overload table subregion are derived, and the data that all data serving nodes in the distributed data base system of the shared framework of described nothing are total derive, and two parts are constituted data source to be imported by derived data;
S3: set up at least two new table subregions according to the rule of described overload table subregion, described new table subregion is distributed on described overload data serving node and the described newly-increased data serving node, described data source to be imported is imported in the described new table subregion, upgrade described data dictionary module.
Preferably, among the described step C, the treatment step that described data serving node receives after the SQL statement of described write operation is as follows:
If described data serving node can not find described tables of data or table subregion in the data dictionary module, described data serving node returns error message;
If described data serving node can find described tables of data in the data dictionary module, still described table subregion is not on described data serving node, and described data serving node does not respond described request of data;
If described data serving node can find described tables of data and described table subregion in the data dictionary module on described data serving node, described data serving node is carried out write operation and is returned the write operation result.
Preferably, among the described step D, described mandatory administration node is carried out inquiry according to the SQL statement of described read operation, and Query Result is returned to described client, specifically comprises step:
P1: resolve the SQL statement of described read operation, obtain tables of data to be checked, obtain the address of the table subregion that described tables of data to be checked comprises by the data dictionary module;
P2: dwindle Query Result set according to the SQL statement of described read operation, and the query requests of the SQL statement of the described read operation of correspondence is decomposed into a plurality of subqueries that can concurrent execution;
P3: the address of the table subregion that comprises according to described tables of data to be checked, assess the network overhead when data shift in the described table subregion, according to assessment result described subquery is sent on the suitable data service node;
P4: described suitable data service node is carried out described subquery respectively, and the subquery result is sent to described mandatory administration node;
P5: described mandatory administration node receives described subquery result, returns to described client after according to the SQL statement of described read operation described subquery result being integrated.
(3) beneficial effect
Nothing of the present invention is shared distributed data base system and its implementation of framework, to be transferred on the data serving node from acting server the work of data processing of request, proxy server functions is simplified, alleviated its bottleneck restriction the entire database system.Simultaneously, for query requests, arbitrary data serving node all can be used as the mandatory administration node and is in charge of work of treatment to described query requests, has improved search efficiency.And, by adopting database, saved storage space based on the row storage, improved processing speed.
Description of drawings
Fig. 1 is the structural drawing that traditional nothing is shared the distributed data base system of framework;
Fig. 2 is the structural drawing that the described nothing of the embodiment of the invention is shared the distributed data base system of framework.
Embodiment
Below in conjunction with drawings and Examples, the specific embodiment of the present invention is described in further detail.Following examples are used to illustrate the present invention, but are not used for limiting the scope of the invention.
Fig. 2 is the structural drawing that the described nothing of the embodiment of the invention is shared the distributed data base system of framework.As shown in Figure 2, described Database Systems comprise: client layer, Agent layer and response layer.
Described client layer comprises client, described client connects the acting server in the described Agent layer, be used for sending request of data to described acting server, perhaps be used to receive the link information of described data serving node, and send described request of data to described data serving node after setting up session according to described link information and described data serving node.
Described Agent layer comprises described acting server, described acting server connects described data serving node, be used for described request of data is transmitted to the data serving node of described response layer, perhaps, be used for sending the link information of described data serving node to described client; Described Agent layer also comprises: connect the data dictionary module and the backup server of described acting server, and the data dictionary module that connects described backup server.Described backup server is used in time replacing described acting server when described acting server breaks down, and avoids described Database Systems collapse.
Described response layer comprises: a plurality of described data serving nodes, switch, the data dictionary module and the data memory module that are connected with described data serving node.Described acting server connects a plurality of described data serving nodes simultaneously by described switch, after the described link information that obtains described acting server transmission, described client can be set up session connection with corresponding described data serving node by described switch, then described request of data is directly sent to described data serving node.Described data memory module is used for by being listed as the tables of data that the storage data serving node that it connected comprises.Described data serving node is used to receive described request of data, to (the Structured Query Language of the SQL in the described request of data, Structured Query Language (SQL)) after the statement optimization process, carry out corresponding database operation, and the operating result arrangement is gathered the back by described acting server or directly return to described client.
All data dictionary modules that comprise in the described system are all stored identical information, described identical information comprises: the address of the address of described data serving node in network, tables of data that described data serving node comprises, and the address of the table subregion that comprises of described tables of data.
A kind of described nothing is shared the distributed data base system implementation method of framework, and it comprises step:
A: when the request of data of client transmission comprises the SQL statement of setting up table space, acting server is broadcasted the described SQL statement of setting up table space in comprising the network of a plurality of data serving nodes, described data serving node receives the described SQL statement of setting up table space.Generally can specify the address of a data service node in the described SQL statement of setting up table space at least, all will set up described table space if omit then be illustrated on all data serving nodes.When a plurality of data serving nodes were designated, except that first data serving node, remaining data serving node can be used as the data redundancy node, caused loss of data to prevent individual data service node chance failure.The data serving node of appointment can be set up table space and upgrade the data dictionary module in the described SQL statement of setting up table space, and unspecified data serving node only upgrades described data dictionary module.
B: when the request of data of described client transmission comprises the SQL statement of setting up tables of data, described acting server is broadcasted the described SQL statement of setting up tables of data in comprising the network of a plurality of described data serving nodes, described data serving node receives the described SQL statement of setting up tables of data.The described SQL statement of setting up tables of data generally comprises table subregion and its table space information that is subordinate to of tables of data yet to be built, if described tables of data yet to be built is not shown the yet not designated table space that it is subordinate to of subregion, then all data serving nodes are all finished the operation of setting up described tables of data yet to be built in the default table space that it comprised after receiving the described SQL statement of setting up tables of data.For the table yet to be built that has the table subregion, the capital indicates its table space that is subordinate to, data serving node judges whether it comprises described table space after receiving the described SQL statement of setting up tables of data, if comprise, execution is built table handling and is upgraded described data dictionary module, otherwise, only upgrade described data dictionary module.
C: when the request of data that sends when client comprised the SQL statement of the write operation of data table, acting server was broadcasted the SQL statement of described write operation in comprising the network of a plurality of data serving nodes.The general table subregion that tables of data and described tables of data comprised of specifying pending write operation of the SQL statement of described write operation.Described data serving node receives the SQL statement of described write operation, and handles according to following steps:
If described data serving node can not find described tables of data or described table subregion in described data dictionary module, described data serving node returns error message;
If described data serving node can find described tables of data in described data dictionary module, still described table subregion is not on described data serving node, and described data serving node does not respond described request of data;
If described data serving node can find described tables of data and described table subregion in described data dictionary module on described data serving node, described data serving node is carried out write operation and is returned the write operation result.
D: when the request of data that sends when described client comprises the SQL statement of the read operation of data table, the link information of data serving node as described in one of the client as described in described acting server sends to according to default rule (as poll, response time etc.), according to described link information, described client and described data serving node are directly set up session, and directly send described request of data to described data serving node; Perhaps, described acting server is transmitted to described data serving node with described request of data, and described data serving node is carried out inquiry according to the SQL statement of described read operation, and Query Result is returned to described client as the mandatory administration node.
The key that data serving node is carried out the read operation of tables of data is query statement optimization, connects the situation of inquiring about at multilist, pushes away querying condition and conversion annexation under optimized Measures comprises.Push away querying condition down and mainly be that the querying condition in the WHERE clause (a kind of condition query statement in the sql like language) is directly associated with base table, make the scope that before doing attended operation, just can dwindle result set, thus the efficient that raising is inquired about.For distributed data base system, a plurality of table subregions of a plurality of tables of data are dispersed on the interior different pieces of information service node of network, can be converted to the full connection of respectively showing between the subregion when connecting between tables of data, be optimized for semi-connected operations then, according to the overhead assessment of implementation strategy, generate final executive plan.
Described mandatory administration node is carried out inquiry according to the SQL statement of described read operation, and Query Result is returned to described client, specifically comprises step:
P1: resolve the SQL statement of described read operation, obtain tables of data to be checked, obtain the address of the table subregion that described tables of data to be checked comprises by the data dictionary module.
P2: the SQL statement according to described read operation is dwindled the Query Result set by pushing away or remove useless partitioned mode under the querying condition, and according to described Database Systems to the characteristic of tables of data by row storages, with the query requests equivalence of the SQL statement of the described read operation of correspondence be decomposed into a plurality of at the different table subregion can concurrent execution subquery.
P3: the address of the table subregion that comprises according to described tables of data to be checked, assess the network overhead when data shift in the described table subregion, according to assessment result described subquery is sent on the suitable data service node.
P4: after described suitable data service node is received described subquery, judge that earlier the table subregion of doing connection is whether all on the local data service node, if the table subregion at the local data service node is arranged not, then from data dictionary, inquire about the address of described table subregion, and connect at data serving node with described table section post and to obtain data, finish described subquery operation then.If there is not the attended operation of a plurality of table subregions in the described subquery, then can directly finish described subquery operation at the local data service node.After described subquery operation was finished, described suitable data service node returned to the mandatory administration node with Query Result.
P5: described mandatory administration node is after receiving the result of all described subqueries, can carry out more integration work according to the requirement of original described query requests, such as Group by (packet command in the sql like language) and Order (the ordering order in the sql like language) operation, and net result directly returned to described client, perhaps return to described acting server earlier, described acting server returns to described client with net result.
E: when the data serving node in the distributed data base system of adding the shared framework of described nothing, by the configuration file of revising described acting server the link information of newly-increased data serving node is set, and finishes the operation of the described data serving node of interpolation by described acting server.
Described acting server is finished the operation of adding described data serving node and specifically be may further comprise the steps:
S1: described acting server obtains described nothing by the data dictionary module and shares all described data serving nodes and the loading condition of showing subregion in the distributed data base system of framework, selects overload data serving node and overload table subregion;
S2: the data in the described overload table subregion are derived, and the data that all data serving nodes in the distributed data base system of the shared framework of described nothing are total derive.Above-mentioned two parts derived data constitutes data source to be imported.
S3: set up at least two new table subregions according to the rule of described overload table subregion, described new table subregion is distributed on described overload data serving node and the described newly-increased data serving node, described data source to be imported is imported in the described new table subregion, upgrade described data dictionary module.
Need to prove that carry out synchronously in more new capital of all data dictionary modules in the described Database Systems, to guarantee that canned data is consistent constantly in all data dictionary modules.
The described nothing of the embodiment of the invention is shared distributed data base system and its implementation of framework, to be transferred on the data serving node from acting server the work of data processing of request, proxy server functions is simplified, alleviated its bottleneck restriction the entire database system.Simultaneously, for query requests, arbitrary data serving node all can be used as the mandatory administration node and is in charge of work of treatment to described query requests, has improved search efficiency.And, by adopting database, saved storage space based on the row storage, improved processing speed.
Above embodiment only is used to illustrate the present invention; and be not limitation of the present invention; the those of ordinary skill in relevant technologies field; under the situation that does not break away from the spirit and scope of the present invention; can also make various variations and modification; therefore all technical schemes that are equal to also belong to category of the present invention, and scope of patent protection of the present invention should be defined by the claims.
Claims (10)
1. one kind is not had the distributed data base system of sharing framework, it is characterized in that, comprising: client, acting server and a plurality of data serving node;
Described client, connect described acting server, be used for sending request of data to described acting server, perhaps be used to receive the link information of described data serving node, and send described request of data to described data serving node after setting up session according to described link information and described data serving node;
Described acting server connects described data serving node, is used for described request of data is transmitted to described data serving node, perhaps sends the link information of described data serving node to described client;
Described data serving node is used to receive described request of data, after the SQL statement optimization process in the described request of data, carries out corresponding database operation, and returns to described client after the operating result arrangement gathered.
2. the system as claimed in claim 1 is characterized in that, described system also comprises the data dictionary module of a plurality of storage identical information; Described acting server is connected a described data dictionary module respectively with data serving node, described data dictionary module is used for storing the address of the tables of data that described data serving node comprises at the address of network, described data serving node, and the address of the table subregion that comprises of described tables of data.
3. system as claimed in claim 2 is characterized in that described system also comprises backup server, and the described data dictionary module that is connected with described backup server; Described backup server also connects described acting server, is used for replacing when described acting server breaks down described acting server.
4. the system as claimed in claim 1, it is characterized in that, described system also comprises switch, described acting server connects a plurality of described data serving nodes simultaneously by described switch, and described client is set up session by described switch and described data serving node after receiving the link information of described data serving node.
5. the system as claimed in claim 1 is characterized in that, described system also comprises a plurality of data memory modules, and described data memory module connects described data serving node, is used to store the tables of data that described data serving node comprises.
6. the implementation method as the distributed data base system of the shared framework of the described nothing of one of claim 1 to 5 is characterized in that, comprises step:
A: when the request of data of client transmission comprises the SQL statement of setting up table space, acting server is broadcasted the described SQL statement of setting up table space in comprising the network of a plurality of data serving nodes, described data serving node receives the described SQL statement of setting up table space, according to the address information of the described data serving node of appointment wherein, set up table space and upgrade the data dictionary module, perhaps only upgrade described data dictionary module;
B: when the request of data of described client transmission comprises the SQL statement of setting up tables of data, described acting server is broadcasted the described SQL statement of setting up tables of data in comprising the network of a plurality of described data serving nodes, described data serving node receives the described SQL statement of setting up tables of data, according to table subregion and table space information wherein, set up tables of data and upgrade described data dictionary module, perhaps just upgrade described data dictionary module;
C: when the request of data that sends when described client comprises the SQL statement of the write operation of data table, described acting server is broadcasted the SQL statement of described write operation in comprising the network of a plurality of described data serving nodes, described data serving node receives the SQL statement of described write operation, according to tables of data and table subregion wherein, return error message, perhaps do not respond described request of data, perhaps carry out write operation and return the write operation result;
D: when the request of data that sends when described client comprises the SQL statement of the read operation of data table, described acting server returns to the link information of a data service node of described client, according to described link information, described client and described data serving node send described request of data to described data serving node after setting up session; Perhaps, described acting server is transmitted to a data service node with described request of data; The data serving node that receives request of data according to the SQL statement of described read operation, is carried out inquiry as the mandatory administration node, and Query Result is returned to described client.
7. method as claimed in claim 6 is characterized in that, also comprises step:
E: when the data serving node in the distributed data base system of adding the shared framework of described nothing, by the configuration file of revising described acting server the link information of newly-increased data serving node is set, and finishes the operation of the described data serving node of interpolation by described acting server.
8. method as claimed in claim 7 is characterized in that, described acting server is finished the operation of adding described data serving node and specifically be may further comprise the steps:
S1: described acting server obtains described nothing by the data dictionary module and shares all data serving nodes and the loading condition of showing subregion in the distributed data base system of framework, selects overload data serving node and overload table subregion;
S2: the data in the described overload table subregion are derived, and the data that all data serving nodes in the distributed data base system of the shared framework of described nothing are total derive, and two parts are constituted data source to be imported by derived data;
S3: set up at least two new table subregions according to the rule of described overload table subregion, described new table subregion is distributed on described overload data serving node and the described newly-increased data serving node, described data source to be imported is imported in the described new table subregion, upgrade described data dictionary module.
9. method as claimed in claim 6 is characterized in that, among the described step C, the treatment step that described data serving node receives after the SQL statement of described write operation is as follows:
If described data serving node can not find described tables of data or table subregion in the data dictionary module, described data serving node returns error message;
If described data serving node can find described tables of data in the data dictionary module, still described table subregion is not on described data serving node, and described data serving node does not respond described request of data;
If described data serving node can find described tables of data and described table subregion in the data dictionary module on described data serving node, described data serving node is carried out write operation and is returned the write operation result.
10. method as claimed in claim 6 is characterized in that, among the described step D, described mandatory administration node is carried out inquiry according to the SQL statement of described read operation, and Query Result is returned to described client, specifically comprises step:
P1: resolve the SQL statement of described read operation, obtain tables of data to be checked, obtain the address of the table subregion that described tables of data to be checked comprises by the data dictionary module;
P2: dwindle Query Result set according to the SQL statement of described read operation, and the query requests of the SQL statement of the described read operation of correspondence is decomposed into a plurality of subqueries that can concurrent execution;
P3: the address of the table subregion that comprises according to described tables of data to be checked, assess the network overhead when data shift in the described table subregion, according to assessment result described subquery is sent on the suitable data service node;
P4: described suitable data service node is carried out described subquery respectively, and the subquery result is sent to described mandatory administration node;
P5: described mandatory administration node receives described subquery result, returns to described client after according to the SQL statement of described read operation described subquery result being integrated.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2011101710324A CN102201010A (en) | 2011-06-23 | 2011-06-23 | Distributed database system without sharing structure and realizing method thereof |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2011101710324A CN102201010A (en) | 2011-06-23 | 2011-06-23 | Distributed database system without sharing structure and realizing method thereof |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102201010A true CN102201010A (en) | 2011-09-28 |
Family
ID=44661685
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2011101710324A Pending CN102201010A (en) | 2011-06-23 | 2011-06-23 | Distributed database system without sharing structure and realizing method thereof |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102201010A (en) |
Cited By (25)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103336782A (en) * | 2013-05-30 | 2013-10-02 | 莱诺斯科技(北京)有限公司 | Relational distributed database system |
CN103365923A (en) * | 2012-03-30 | 2013-10-23 | 伊姆西公司 | Method and device for assessing partition schemes of database |
CN103457980A (en) * | 2012-06-04 | 2013-12-18 | 联想(北京)有限公司 | Terminal device and data acquisition method |
CN103685436A (en) * | 2012-09-26 | 2014-03-26 | 联想(北京)有限公司 | Data acquisition method and terminal equipment |
CN104050250A (en) * | 2011-12-31 | 2014-09-17 | 北京奇虎科技有限公司 | Distributed key-value query method and query engine system |
WO2014139450A1 (en) * | 2013-03-13 | 2014-09-18 | Huawei Technologies Co., Ltd. | System and method for distributed sql join processing in shared-nothing relational database clusters using stationary tables |
CN104333512A (en) * | 2014-10-30 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Distributed memory database access system and method |
CN104598341A (en) * | 2013-10-30 | 2015-05-06 | 国际商业机器公司 | Approach and system for determining a location of failure between interconnects/controller |
CN105187503A (en) * | 2015-08-07 | 2015-12-23 | 北京思特奇信息技术股份有限公司 | Data partition supporting service connection method and system |
WO2016184175A1 (en) * | 2015-05-21 | 2016-11-24 | 中兴通讯股份有限公司 | Database processing method and apparatus |
CN106227799A (en) * | 2016-07-21 | 2016-12-14 | 江和慧 | A kind of sql statement processing method based on distributed data base |
CN106250567A (en) * | 2016-08-31 | 2016-12-21 | 天津南大通用数据技术股份有限公司 | In distributed data base system, table connects system of selection and the device of data distribution mode |
CN106569896A (en) * | 2016-10-25 | 2017-04-19 | 北京国电通网络技术有限公司 | Data distribution and parallel processing method and system |
CN107451220A (en) * | 2016-09-21 | 2017-12-08 | 广州特道信息科技有限公司 | A kind of distributed NewSQL Database Systems |
CN108989390A (en) * | 2018-06-19 | 2018-12-11 | 北京智明星通科技股份有限公司 | User requests retransmission method and device, Reverse Proxy and computer readable storage medium |
CN109344192A (en) * | 2018-10-24 | 2019-02-15 | 四川省气象探测数据中心 | A kind of optimization CIMISS Database Systems and its adaptation method |
CN109416683A (en) * | 2016-04-05 | 2019-03-01 | 华为技术有限公司 | The traffic operation method of data processing equipment, Database Systems and Database Systems |
CN110175069A (en) * | 2019-05-20 | 2019-08-27 | 广州南洋理工职业学院 | Distributing real time system system and method based on broadcast channel |
CN110502535A (en) * | 2019-08-28 | 2019-11-26 | 上海达梦数据库有限公司 | Data access method, device, equipment and storage medium |
WO2020015495A1 (en) * | 2018-07-16 | 2020-01-23 | 中兴通讯股份有限公司 | Method, device and apparatus for accessing heterogeneous database, plug-in and storage medium |
CN110866011A (en) * | 2019-11-04 | 2020-03-06 | 金蝶软件(中国)有限公司 | Data table synchronization method and device, computer equipment and storage medium |
CN110968615A (en) * | 2018-09-30 | 2020-04-07 | 北京国双科技有限公司 | Data query method and device |
WO2020125367A1 (en) * | 2018-12-18 | 2020-06-25 | 中兴通讯股份有限公司 | Data query method and database agent |
CN112182015A (en) * | 2020-09-28 | 2021-01-05 | 贵州云腾志远科技发展有限公司 | Self-adaptive global data rapid retrieval method |
CN114969110A (en) * | 2022-07-21 | 2022-08-30 | 阿里巴巴(中国)有限公司 | Query method and device |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1455347A (en) * | 2002-04-30 | 2003-11-12 | 电子科技大学 | Distributed parallel scheduling wide band network server system |
CN1578320A (en) * | 2003-06-30 | 2005-02-09 | 微软公司 | Network load balancing with main machine status information |
CN101567006A (en) * | 2009-05-25 | 2009-10-28 | 中兴通讯股份有限公司 | Database system and distributed SQL statement execution plan reuse method |
-
2011
- 2011-06-23 CN CN2011101710324A patent/CN102201010A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1455347A (en) * | 2002-04-30 | 2003-11-12 | 电子科技大学 | Distributed parallel scheduling wide band network server system |
CN1578320A (en) * | 2003-06-30 | 2005-02-09 | 微软公司 | Network load balancing with main machine status information |
CN101567006A (en) * | 2009-05-25 | 2009-10-28 | 中兴通讯股份有限公司 | Database system and distributed SQL statement execution plan reuse method |
Cited By (44)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104050250B (en) * | 2011-12-31 | 2018-06-05 | 北京奇虎科技有限公司 | A kind of distributed key-value querying method and query engine system |
CN104050250A (en) * | 2011-12-31 | 2014-09-17 | 北京奇虎科技有限公司 | Distributed key-value query method and query engine system |
CN103365923A (en) * | 2012-03-30 | 2013-10-23 | 伊姆西公司 | Method and device for assessing partition schemes of database |
CN103457980A (en) * | 2012-06-04 | 2013-12-18 | 联想(北京)有限公司 | Terminal device and data acquisition method |
CN103685436A (en) * | 2012-09-26 | 2014-03-26 | 联想(北京)有限公司 | Data acquisition method and terminal equipment |
CN105247513A (en) * | 2013-03-13 | 2016-01-13 | 华为技术有限公司 | System and method for distributed SQL join processing in shared-nothing relational database clusters using stationary tables |
US9152669B2 (en) | 2013-03-13 | 2015-10-06 | Futurewei Technologies, Inc. | System and method for distributed SQL join processing in shared-nothing relational database clusters using stationary tables |
WO2014139450A1 (en) * | 2013-03-13 | 2014-09-18 | Huawei Technologies Co., Ltd. | System and method for distributed sql join processing in shared-nothing relational database clusters using stationary tables |
CN103336782B (en) * | 2013-05-30 | 2016-09-21 | 莱诺斯科技(北京)股份有限公司 | A kind of relationship type distributed data base system |
CN103336782A (en) * | 2013-05-30 | 2013-10-02 | 莱诺斯科技(北京)有限公司 | Relational distributed database system |
CN104598341B (en) * | 2013-10-30 | 2018-01-09 | 国际商业机器公司 | For determining the method and system of the location of fault between interconnection/controller |
CN104598341A (en) * | 2013-10-30 | 2015-05-06 | 国际商业机器公司 | Approach and system for determining a location of failure between interconnects/controller |
CN104333512A (en) * | 2014-10-30 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Distributed memory database access system and method |
CN104333512B (en) * | 2014-10-30 | 2017-07-28 | 北京思特奇信息技术股份有限公司 | A kind of distributed memory database accesses system and method |
WO2016184175A1 (en) * | 2015-05-21 | 2016-11-24 | 中兴通讯股份有限公司 | Database processing method and apparatus |
CN105187503A (en) * | 2015-08-07 | 2015-12-23 | 北京思特奇信息技术股份有限公司 | Data partition supporting service connection method and system |
CN105187503B (en) * | 2015-08-07 | 2018-11-09 | 北京思特奇信息技术股份有限公司 | A kind of service connection method that supporting data partition and system |
CN109416683A (en) * | 2016-04-05 | 2019-03-01 | 华为技术有限公司 | The traffic operation method of data processing equipment, Database Systems and Database Systems |
CN106227799B (en) * | 2016-07-21 | 2019-06-25 | 江和慧 | A kind of sql sentence processing method based on distributed data base |
CN106227799A (en) * | 2016-07-21 | 2016-12-14 | 江和慧 | A kind of sql statement processing method based on distributed data base |
CN106250567A (en) * | 2016-08-31 | 2016-12-21 | 天津南大通用数据技术股份有限公司 | In distributed data base system, table connects system of selection and the device of data distribution mode |
CN107451220A (en) * | 2016-09-21 | 2017-12-08 | 广州特道信息科技有限公司 | A kind of distributed NewSQL Database Systems |
CN107451220B (en) * | 2016-09-21 | 2020-06-09 | 云润大数据服务有限公司 | Distributed NewSQL database system |
CN106569896B (en) * | 2016-10-25 | 2019-02-05 | 北京国电通网络技术有限公司 | A kind of data distribution and method for parallel processing and system |
CN106569896A (en) * | 2016-10-25 | 2017-04-19 | 北京国电通网络技术有限公司 | Data distribution and parallel processing method and system |
CN108989390A (en) * | 2018-06-19 | 2018-12-11 | 北京智明星通科技股份有限公司 | User requests retransmission method and device, Reverse Proxy and computer readable storage medium |
CN108989390B (en) * | 2018-06-19 | 2020-11-10 | 北京智明星通科技股份有限公司 | User request forwarding method and device, reverse proxy server and computer readable storage medium |
WO2020015495A1 (en) * | 2018-07-16 | 2020-01-23 | 中兴通讯股份有限公司 | Method, device and apparatus for accessing heterogeneous database, plug-in and storage medium |
CN110968615B (en) * | 2018-09-30 | 2023-05-23 | 北京国双科技有限公司 | Data query method and device |
CN110968615A (en) * | 2018-09-30 | 2020-04-07 | 北京国双科技有限公司 | Data query method and device |
CN109344192A (en) * | 2018-10-24 | 2019-02-15 | 四川省气象探测数据中心 | A kind of optimization CIMISS Database Systems and its adaptation method |
CN111339132A (en) * | 2018-12-18 | 2020-06-26 | 中兴通讯股份有限公司 | Data query method and database agent |
WO2020125367A1 (en) * | 2018-12-18 | 2020-06-25 | 中兴通讯股份有限公司 | Data query method and database agent |
CN111339132B (en) * | 2018-12-18 | 2023-05-26 | 金篆信科有限责任公司 | Data query method and database proxy |
CN110175069A (en) * | 2019-05-20 | 2019-08-27 | 广州南洋理工职业学院 | Distributing real time system system and method based on broadcast channel |
CN110175069B (en) * | 2019-05-20 | 2023-11-14 | 广州南洋理工职业学院 | Distributed transaction processing system and method based on broadcast channel |
CN110502535A (en) * | 2019-08-28 | 2019-11-26 | 上海达梦数据库有限公司 | Data access method, device, equipment and storage medium |
CN110502535B (en) * | 2019-08-28 | 2022-02-22 | 上海达梦数据库有限公司 | Data access method, device, equipment and storage medium |
CN110866011A (en) * | 2019-11-04 | 2020-03-06 | 金蝶软件(中国)有限公司 | Data table synchronization method and device, computer equipment and storage medium |
CN110866011B (en) * | 2019-11-04 | 2022-11-08 | 金蝶软件(中国)有限公司 | Data table synchronization method and device, computer equipment and storage medium |
CN112182015B (en) * | 2020-09-28 | 2023-07-21 | 贵州云腾志远科技发展有限公司 | Self-adaptive global data quick retrieval method |
CN112182015A (en) * | 2020-09-28 | 2021-01-05 | 贵州云腾志远科技发展有限公司 | Self-adaptive global data rapid retrieval method |
CN114969110B (en) * | 2022-07-21 | 2022-10-21 | 阿里巴巴(中国)有限公司 | Query method and device |
CN114969110A (en) * | 2022-07-21 | 2022-08-30 | 阿里巴巴(中国)有限公司 | Query method and device |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102201010A (en) | Distributed database system without sharing structure and realizing method thereof | |
EP3058690B1 (en) | System and method for creating a distributed transaction manager supporting repeatable read isolation level in a mpp database | |
JP6967615B2 (en) | Distributed search and index update methods, systems, servers and computer equipment | |
US20020035559A1 (en) | System and method for a decision engine and architecture for providing high-performance data querying operations | |
CN102163195B (en) | Query optimization method based on unified view of distributed heterogeneous database | |
US9576026B2 (en) | System and method for distributed SQL join processing in shared-nothing relational database clusters using self directed data streams | |
WO2010098034A1 (en) | Distributed database management system and distributed database management method | |
CN101751415B (en) | Metadata service system, metadata synchronized method and writing server updating method | |
CN109933631A (en) | Distributed parallel database system and data processing method based on Infiniband network | |
CN104885054A (en) | System and method for performing a transaction in a massively parallel processing database | |
CN105516284B (en) | A kind of method and apparatus of Cluster Database distributed storage | |
US20220035786A1 (en) | Distributed database management system with dynamically split b-tree indexes | |
CN103823846A (en) | Method for storing and querying big data on basis of graph theories | |
CN104468299A (en) | Enterprise service bus system based on user rule | |
CN110019231A (en) | A kind of method that parallel database dynamically associates and node | |
US11226986B2 (en) | Data table partitioning management method and apparatus | |
CN104008199A (en) | Data inquiring method | |
CN104750757A (en) | Data storage method and equipment based on HBase | |
CN103336782A (en) | Relational distributed database system | |
CN102654878A (en) | Data operation method for distributed database in embedded system and board card | |
CN102737061A (en) | Distributed ticket query management system and method | |
CN110597808B (en) | Distributed database table connection method, device, system, server and medium | |
KR20130038517A (en) | System and method for managing data using distributed containers | |
CN103577424B (en) | The realization method and system of distributed data base view | |
CN114338725B (en) | Distributed storage scheduling method for improving upper limit of large-scale cluster rendering |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C12 | Rejection of a patent application after its publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110928 |