A distributed database extension method and system based on a relational database
An expansion method and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as affecting the normal operation of distributed database systems, occupying too much disk IO and CPU resources, etc.
Active Publication Date: 2017-01-25
GUANGZHOU SUNRISE ELECTRONICS DEV
View PDF4 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0005] In order to solve the above-mentioned technical problems, this application provides a distributed database expansion method based on a relational database to achieve the purpose of solving the problem of occupying too many disk IO and CPU resources in the prior art and affecting the normal operation of the distributed database system , the technical scheme is as follows:
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0056] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.
[0057] The present application provides a distributed database expansion method based on a relational database. First, when the node server is full of data, it is determined that the node server is a node server to be expanded; secondly, a node server is allocated to the node server to be expanded. A preset node server with the same partition rules and mapping values as the node server to be expanded, wherein the current storage capacity of the preset node server is zero or not ful...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention provides a distributed database extension method based on a relational database. The distributed database extension method comprises the following steps: determining a node server as a to-be-extended node server in the case that the node server is fully stored with data; distributing a preset node server having the same partition rule and mapping value with the to-be-extended node server for the to-be-extended node server, wherein the present storage capacity of the preset node server is zero or low; sending same database operation requests to the to-be-extended node server and the preset node server, and receiving and processing the same database operation requests by the to-be-extended node server and the preset node server, wherein the database operation requests are associated with the partition rule and the mapping value. Therefore, the problem of influence on the normal running of a distributed database due to relatively large occupation of IO (input / output) resources and CPU (central processing unit) resources of a disk in the prior art is solved.
Description
technical field [0001] The present application relates to the field of database expansion, in particular to a distributed database expansion method and system based on a relational database. Background technique [0002] A distributed database is a database in which data is stored on each computer in a computer network. At present, the distributed database based on the relational database is mainly commonly used. The distributed database adopts the table partition technology to store the records in a large database table on each node server (computer) according to certain partition rules. [0003] When the data flow stored on a node server is too large and the distributed database based on the relational database needs to be expanded, the partition rules need to be readjusted. However, after readjusting the partition rules, it is necessary to migrate part of the mapping values on the corresponding node server to the corresponding new node server, and at the same time, the...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 陈百平袁晓鹏
Owner GUANGZHOU SUNRISE ELECTRONICS DEV