CN109213825A - A kind of data-base capacity-enlarging method and device - Google Patents
A kind of data-base capacity-enlarging method and device Download PDFInfo
- Publication number
- CN109213825A CN109213825A CN201710517146.7A CN201710517146A CN109213825A CN 109213825 A CN109213825 A CN 109213825A CN 201710517146 A CN201710517146 A CN 201710517146A CN 109213825 A CN109213825 A CN 109213825A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- tables
- target
- user identifier
- 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
Abstract
The embodiment of the present application provides a kind of data-base capacity-enlarging method and device, applied to the Database Systems including at least one first database, this method determines at least one target database in the case where Database Systems meet preset data-base capacity-enlarging condition from least one first database;The dilatation amount of each target database is determined respectively;Increase the second database corresponding with the dilatation amount of each target database respectively in Database Systems, and by target database the second database association corresponding with its dilatation amount (data list structure in data list structure target database associated with it in the second database is identical).It is the target database dilatation that this method, which is based on automatic increased and associated second database of target database in Database Systems, so that the second database is target database sharing data store tasks associated with it, so that meeting data storage requirement under the premise of guaranteeing that data orderly store.
Description
Technical field
This application involves technical field of data storage, more particularly to a kind of data-base capacity-enlarging method and device.
Background technique
Data informationization develops at any time, and requirement of the people to data storage technology requires higher and higher, data storage technology
The work and life of people are facilitated to a certain extent.
However, also exactly there is the case where data volume much to be stored explodes with the development of data information, this
When database for storing data tend not to the storage demand for meeting the data volume to explode.Therefore, how to guarantee data
Orderly under the premise of storage, meet data storage requirement, has become one of technical field of data storage and vital grind
Study carefully direction.
Summary of the invention
In view of this, the embodiment of the present application provides a kind of data-base capacity-enlarging method and device, orderly to deposit in guarantee data
Under the premise of storage, meet data storage requirement.
To achieve the goals above, technical solution provided by the embodiments of the present application is as follows:
A kind of data-base capacity-enlarging method, applied to the Database Systems including at least one first database, this method packet
It includes:
In the case where the Database Systems meet preset data-base capacity-enlarging condition, from least one described first number
According at least one target database determining in library;
The dilatation amount of each target database is determined respectively;
Increase the second data corresponding with the dilatation amount of each target database respectively in the Database Systems
Library, and the tables of data by the target database the second database association corresponding with its dilatation amount, in second database
Data list structure in structure target database associated with it is identical.
Preferably, further includes:
By the data backup stored in the target database into the second database associated with it.
Preferably, each of described Database Systems database is for storing and the user of the database association
The data information of mark, wherein the database is the first database or the second database.
Preferably, the data list structure in each database is identical, and the data list structure in the database includes
At least first tables of data, and at least second tables of data,
Every first tables of data is believed for storing with the order basis of the associated user identifier of the first tables of data
Breath, the order basic information includes order note identification;
Every second tables of data is believed for storing with the order of the associated order note identification of the second tables of data in detail
Breath;Wherein, the data information of the user identifier includes order basic information and the order basis of the user identifier
The order details of order note identification in information.
Preferably, each first database is determined as a target database respectively, in the Database Systems
Each of the database be provided with unique database accession number, database accession number size is adjacent in each database accession number
Any two database accession number between difference be 1, the smallest database accession number is 0 in each database accession number, described
Difference between the database accession number of first database and the associated second wide area information server number of the first database
It is identical as the number of at least one first database,
If the number in library carries out the modulus that Hash modulo operation obtains to the first content of user identifier based on the data
As a result identical as wide area information server number, determine the user identifier and the database association.
Preferably, every first tables of data at least first tables of data is provided with the first number, each institute
The difference stated between the number of any two first that the first number size is adjacent in the first number is 1, in each first number
The smallest first number is 0,
If the number based on first tables of data carries out what Hash modulo operation obtained to the second content of user identifier
Modulus result is identical as the first number of the first tables of data, determines that the user identifier is associated with first tables of data, described
Second content is different from the first content.
Preferably, every second tables of data at least second tables of data is provided with the second number, each institute
The difference stated between the number of any two second that the second number size is adjacent in the second number is 1, in each second number
The smallest second number is 0,
If the number based on second tables of data to order note identification carry out the obtained modulus result of Hash modulo operation with
Second number of the second tables of data is identical, determines that the user identifier is associated with second tables of data.
A kind of data-base capacity-enlarging device, applied to the Database Systems including at least one first database, the device packet
It includes:
Target database determination unit, for the case where the Database Systems meet preset data-base capacity-enlarging condition
Under, at least one target database is determined from least one described first database;
Dilatation amount determination unit, for determining the dilatation amount of each target database respectively;
Dilatation unit, for increasing the dilatation amount pair with each target database respectively in the Database Systems
The second database answered, and by the target database the second database association corresponding with its dilatation amount, second data
The data list structure in data list structure target database associated with it in library is identical.
Preferably, further includes:
Backup units, data backup for will be stored in the target database to the second database associated with it
In.
Preferably, each of described Database Systems database is for storing and the user of the database association
The data information of mark, wherein the database is the first database or the second database.
The embodiment of the present application provides a kind of data-base capacity-enlarging method and device, is applied to include at least one first database
Database Systems, this method in the case where Database Systems meet preset data-base capacity-enlarging condition, from least one
At least one target database is determined in one database;The dilatation amount of each target database is determined respectively;In Database Systems
Middle increase the second database corresponding with the dilatation amount of each target database respectively, and by target database and its dilatation amount pair
The the second database association (data list structure in data list structure target database associated with it in the second database answered
It is identical).It is the mesh that this method, which is based on automatic increased and associated second database of target database in Database Systems,
Data-base capacity-enlarging is marked, so that the second database is target database sharing data store tasks associated with it, so that
Under the premise of guaranteeing that data orderly store, data storage requirement is met.
Detailed description of the invention
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
The some embodiments recorded in application, for those of ordinary skill in the art, without creative efforts,
It is also possible to obtain other drawings based on these drawings.
Fig. 1 is a kind of data-base capacity-enlarging method flow diagram provided by the embodiments of the present application;
Fig. 2 is another data-base capacity-enlarging method flow diagram provided by the embodiments of the present application;
Fig. 3 is a kind of structural schematic diagram of data-base capacity-enlarging device provided by the embodiments of the present application.
Specific embodiment
In order to make those skilled in the art better understand the technical solutions in the application, below in conjunction with the application reality
The attached drawing in example is applied, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described implementation
Example is merely a part but not all of the embodiments of the present application.Based on the embodiment in the application, this field is common
The application protection all should belong in technical staff's every other embodiment obtained without making creative work
Range.
Embodiment:
Fig. 1 is a kind of data-base capacity-enlarging method flow diagram provided by the embodiments of the present application.
Data-base capacity-enlarging method as shown in Figure 1 is applied to the Database Systems including at least one first database.Tool
Body, data-base capacity-enlarging method as shown in Figure 1, comprising:
S101, in the case where the Database Systems meet preset data-base capacity-enlarging condition, from it is described at least one
At least one target database is determined in first database;
Optionally, it includes: in the Database Systems that the Database Systems, which meet preset data-base capacity-enlarging condition,
In at least one first database data summation (data stored in each first database in the Database Systems it is total
With) reach preset first data storage threshold value;Alternatively, the data that there is storage in the Database Systems reach preset the
The database of two data storage threshold value.
It is above only that the Database Systems provided by the embodiments of the present application meet preset data-base capacity-enlarging condition
The tool that Database Systems meet preset data-base capacity-enlarging condition can be arbitrarily arranged in preferred embodiment, inventor according to their own needs
Body mode, it is not limited here.
Optionally, from each target at least one target database determined at least one described first database
Database is the database of pending dilatation in the Database Systems.
S102, the dilatation amount for determining each target database respectively;
Optionally, for each target database at least one determining target database, the target is determined
The dilatation amount of database.Wherein, the dilatation amount of the target database determined to target database is target database needs
The capacity of expansion.
Optionally, the dilatation amount of target database can depending on target database history data store situation, and/or,
Depending on target database current residual database volume, it is not limited here.
S103, increase the dilatation amount corresponding second with each target database respectively in the Database Systems
Database, and the number by the target database the second database association corresponding with its dilatation amount, in second database
It is identical according to the data list structure in table structure target database associated with it.
Optionally, for each target database, the dilatation amount of the target database is determined, in Database Systems
Increase corresponding with the dilatation amount of the target database the second database, and by the target database and increased second data
Library association, also, the data list structure in increased second database is identical as the data list structure in the target database.
Wherein, increase the mode of the second database corresponding with the dilatation amount of the target database in Database Systems
Are as follows: database of the database volume not less than the dilatation amount of the target database is chosen from preset multiple databases,
As corresponding second database of dilatation amount with the target database, and second database is increased into the data automatically
In the system of library.
In the embodiment of the present application, it is preferred that the second database corresponding with the dilatation amount of target database can be 1
Database, can also be made of multiple databases (the total Database capacity of this multiple database be not less than the target database
Dilatation amount).
Optionally, the data list structure in increased second database and the data list structure phase in the target database
Together, indicate: each tables of data for storing data in increased second database is used to deposit with the target database
Each tables of data for storing up data is identical.
The embodiment of the present application passes through increased and associated second database of target database automatic in Database Systems
Think the target database dilatation, so that the second database is target database sharing data store tasks associated with it,
So that meeting data storage requirement under the premise of guaranteeing that data orderly store.
Fig. 2 is another data-base capacity-enlarging method flow diagram provided by the embodiments of the present application.
Data-base capacity-enlarging method as shown in Figure 2 is applied to the Database Systems including at least one first database.Tool
Body, data-base capacity-enlarging method as shown in Figure 2, comprising:
S201, in the case where the Database Systems meet preset data-base capacity-enlarging condition, from it is described at least one
At least one target database is determined in first database;
S202, the dilatation amount for determining each target database respectively;
S203, increase the dilatation amount corresponding second with each target database respectively in the Database Systems
Database, and the number by the target database the second database association corresponding with its dilatation amount, in second database
It is identical according to the data list structure in table structure target database associated with it;
The implementation procedure of step S201-S203 provided by the embodiments of the present application and step S101- provided by the above embodiment
The implementation procedure of S103 is identical, and the implementation procedure in relation to step S201-S203, which refers to, above-mentioned retouches step S101-S103
It states, this will not be repeated here.
S204, by the data backup stored in the target database into the second database associated with it.
Optionally, by the increase in Database Systems and associated second database of target database, although can reach
To for the target database dilatation, make the second database be target database sharing data store tasks associated with it,
So that meet the purpose of data storage requirement under the premise of guaranteeing that data orderly store, and still, in data query,
May exist directly goes the second data base querying before by second database association to target database, is stored in institute
The case where stating the data in target database.Therefore, caused in second database in order to avoid in this case
It inquires less than as a result, going to ask with the search efficiency that data are inquired, influenced in the target database of second data correlation again
Topic, the embodiment of the present application, can be further after executing completion step S203, extremely by the data backup stored in target database
In second database associated with it.
In the embodiment of the present application, it is preferred that each of described Database Systems database is for storage and institute
State the data information of the user identifier of database association, wherein the database is the first database or the second database.
Optionally, after Database Systems carry out data-base capacity-enlarging, each database (number herein in Database Systems
According to the first database or the second database that library is in the Database Systems) for storing and the user of the database association
The data information of mark.That is, for each database (whether first database or the second number that are located in Database Systems
According to library) for, which is only used for the data information of storage with the user identifier of the database association.
Optionally, the user identifier of each database association in the Database Systems is different, that is, in Database Systems
Each database association user identifier it is different from the user identifier of other database associations in the Database Systems.Base
In this, it is ensured that be stored in all data informations of Database Systems, all data informations for belonging to same user (have identical
All data informations of user identifier) it is located in same database, and then can facilitate when carrying out data query, quickly position number
According to inquiring position, data query result is obtained.
In the embodiment of the present application, it is preferred that the data list structure phase in each of Database Systems database
Together, the data list structure in the database includes at least first tables of data, and at least second tables of data.Its
In, every first tables of data is for storing and the order basic information of the associated user identifier of the first tables of data, institute
Stating order basic information includes order note identification;Every second tables of data is for storing and second tables of data is associated orders
The order details singly identified;Wherein, the data information of the user identifier includes the order basis letter of the user identifier
The order details of breath and the order note identification in the order basic information.
Optionally, the data list structure in each database in Database Systems is identical, for the Database Systems
In a database for, data list structure in the database includes at least first tables of data, and at least one
Second tables of data.
Wherein, for every first tables of data in the database, first tables of data for store with this
The order basic information of the associated user identifier of one tables of data (the order basic information includes order note identification);For the number
For the second tables of data of every in library, which is used to store and the associated order note identification of the second tables of data
Order details.
Optionally, for each database in Database Systems, every first tables of data in the database is closed
The user identifier of connection is different (that is, every associated user identifier of the first tables of data in the database, and in the database
The associated user identifier of other first tables of data is different), also, the associated order mark of every second tables of data in the database
Know it is different (that is, every associated order note identification of the second tables of data in the database, with other second numbers in the database
It is different according to the associated order note identification of table).Further, in conjunction with the user of each database association in Database Systems described above
Mark is different, in all data informations that not only can guarantee deposit Database Systems, belongs to all data informations of same user
(all data informations with same subscriber mark) are located in same database;And, it is also ensured that belong to same user's
All order basic informations (all order basic informations with same subscriber mark) are located at same the first of same database
In tables of data, further, it is also ensured that belong to all order details of same order (with all of same order mark
Order details) it is located in same second tables of data of same database, so that when carrying out data query, it can be more
Quick location data inquiring position, obtains data query result.
In the embodiment of the present application, it is preferred that each first database is determined as a target database respectively
(that is, described determine at least one target database from least one described first database, comprising: will it is described at least one
Each first database in first database is determined as a target database).
Optionally, " each first database is being determined as a target database respectively, for each number of targets
For library, corresponding second database of the dilatation amount of the target database is only made of a database, the data base set
Each of system database is provided with unique database accession number, database accession number size in each database accession number
Difference between adjacent any two database accession number is 1, and the smallest database accession number is 0 in each database accession number,
Between the database accession number of the first database and the associated second wide area information server number of the first database
Difference is identical as the number of at least one first database " under the premise of, if the number in library marks user based on the data
The modulus result that the first content progress Hash modulo operation of knowledge obtains is identical as wide area information server number, determines the use
Family mark and the database association.
In the embodiment of the present application, it is preferred that the first content of user identifier is whole/part in the user identifier
Content.
Optionally, the first content of user identifier is usually character string, therefore carries out Hash calculation to first content, is breathed out
It is uncommon as a result, and modulo operation is carried out to obtained Hash result, to obtain modulus result.Wherein, Hash result is taken
When modular arithmetic, using the Hash result as dividend, the number of the database in the Database Systems as divisor, with
To modulus result.
Optionally, " every first tables of data at least first tables of data in the database is provided with
First numbers, and the difference in each first number between the adjacent number of any two first of the first number size is 1, each institute
State in the first number it is the smallest first number be 0 " under the premise of, if the number based on first tables of data is to user identifier
The modulus result that second content progress Hash modulo operation obtains is identical as the first number of the first tables of data, determines the user
Mark is associated with first tables of data, and second content is different from the first content.
In the embodiment of the present application, it is preferred that the second content of user identifier is whole/part in the user identifier
Content.
Optionally, the second content of user identifier is usually character string, therefore carries out Hash calculation to the second content, is breathed out
It is uncommon as a result, and modulo operation is carried out to obtained Hash result, to obtain modulus result.Wherein, Hash result is taken
When modular arithmetic, using the Hash result as dividend, the number of at least one the first tables of data in the database is made
For divisor, to obtain modulus result.
Optionally, " every second tables of data at least second tables of data in the database is all provided with
It is equipped with the second number, the difference in each second number between the adjacent number of any two second of the second number size is 1,
Under the premise of the smallest second number is 0 " in each second number, if the number based on second tables of data is to order note identification
It is identical as the second number of the second tables of data to carry out the modulus result that Hash modulo operation obtains, determines the user identifier and institute
State the association of the second tables of data.
In the embodiment of the present application, it is preferred that Hash calculation is carried out to order note identification, obtains Hash result, and to gained
The Hash result arrived carries out modulo operation, to obtain modulus result.It wherein, will be described when carrying out modulo operation to Hash result
Hash result is as dividend, using the number of at least one the second tables of data in the database as divisor, to be taken
Mould result.
Optionally, if the order note identification is digital information, also modulo operation directly can be carried out to the order note identification, with
Obtain modulus result.That is, using order note identification as dividend, by the number of at least one the second tables of data in the database
As divisor, to obtain modulus result.
For the ease of it is specific now to pass through an example to a kind of understanding of data-base capacity-enlarging method provided by the embodiments of the present application
Illustrate:
A kind of data-base capacity-enlarging method provided by the embodiments of the present application is applied to the database including 16 first databases
System, the data list structure in each first database is identical, includes 16 the first tables of data (every the in the first database
One tables of data has one first number, and first number of this 16 the first tables of data is 0-15) and 16 the second tables of data are (often
Opening the second tables of data has one second number, and second number of this 16 the second tables of data is 0-15), wherein the first data
Table is used to store the order basic information (order basic information includes the order note identification for being used to indicate order) of user, the second data
Table is used to store the order details of order, also, the order basic information of user and, ordering in the order basic information
The order details of the order of single mark instruction constitute the data information of the user.
Optionally, the database accession number of each first database in the Database Systems is 0-15, in the database
In the case that system meets preset data-base capacity-enlarging condition, increase by 16 the second databases, institute in the Database Systems
The each first database stated in Database Systems is associated with unique second database, is each second data lab setting number
It is numbered according to library, the second wide area information server number is to add with the database accession number of the first database of second database association
The sum of the number of first database in the upper Database Systems, i.e., each second wide area information server number is 16-31, example
Such as, the associated second wide area information server number of the first database for being 0 with database accession number is 16, is with database accession number
The associated second wide area information server number of 1 first database is 17.
Also, the data list structure phase in the data list structure target database associated with it in second database
Together, that is, include that (every first tables of data has one first number to 16 the first tables of data, this 16 in each second database
First number of the first tables of data is 0-15) and 16 the second tables of data (there is every second tables of data one second to be numbered,
Second number of this 16 the second tables of data is 0-15).
Further, Database Systems are standby by the data stored in first database after completing above-mentioned data-base capacity-enlarging
Part is into the second database associated with it.
Correspondingly, by taking the data information for completing the storage user of the Database Systems after above-mentioned data-base capacity-enlarging as an example, this Shen
Please embodiment provide Database Systems data storage procedure can be accomplished by the following way:
Data storage request is received, the data storage request request stores the data letter of the corresponding user of user identifier
Breath, the data information includes the order basic information of the user and the order note identification that the order basic information includes
Order details.
Hash calculation is carried out to all information of user identifier, obtains Hash result, and to obtained Hash result into
Row modulo operation, to obtain modulus result.Wherein, when carrying out modulo operation to Hash result, using the Hash result as quilt
Divisor, 32 are used as divisor, to obtain modulus result.Database accession number in the Database Systems is identical as the modulus result
Database of the database (database A) as the data information for storing user.
Hash calculation is carried out to the partial information of user identifier, obtains Hash result, and to obtained Hash result into
Row modulo operation, to obtain modulus result.Wherein, when carrying out modulo operation to Hash result, using the Hash result as quilt
Divisor, 16 (numbers of the first tables of data in database) are used as divisor, to obtain modulus result.By the first number in database A
First data of the first tables of data (the first tables of data A) identical with the modulus result as the data information for storing user
Table stores the order basic information in the data information of user in this first tables of data A.
Hash calculation is carried out to the order note identification in order basic information, obtains Hash result, and to obtained Hash
As a result modulo operation is carried out, to obtain modulus result.Wherein, when carrying out modulo operation to Hash result, by the Hash result
As dividend, 16 (numbers of the second tables of data in database) are used as divisor, to obtain modulus result.By in database A
Two identical with the modulus result the second tables of data (the second tables of data A) of number as the data information for storing user the
Two tables of data store the order details in the data information of user in this second tables of data A.
The embodiment of the present application provides a kind of data-base capacity-enlarging method, applied to the data including at least one first database
Library system, this method is in the case where Database Systems meet preset data-base capacity-enlarging condition, from least one the first data
At least one target database is determined in library;The dilatation amount of each target database is determined respectively;Increase in Database Systems
The second database corresponding with the dilatation amount of each target database respectively, and by target database corresponding with its dilatation amount
Two database associations (data list structure in data list structure target database associated with it in the second database is identical).
It is the target data that this method, which is based on automatic increased and associated second database of target database in Database Systems,
Library dilatation, so that the second database is target database sharing data store tasks associated with it, so that guaranteeing number
Under the premise of according to orderly storage, data storage requirement is met.
Fig. 3 is a kind of structural schematic diagram of data-base capacity-enlarging device provided by the embodiments of the present application.
Data-base capacity-enlarging device as shown in Figure 3 is applied to the Database Systems including at least one first database.Tool
Body, data-base capacity-enlarging device as shown in Figure 3, comprising:
Target database determination unit 31, for meeting the feelings of preset data-base capacity-enlarging condition in the Database Systems
Under condition, at least one target database is determined from least one described first database;
Dilatation amount determination unit 32, for determining the dilatation amount of each target database respectively;
Dilatation unit 33, for increasing the dilatation amount with each target database respectively in the Database Systems
Corresponding second database, and the target database the second database association corresponding with its dilatation amount, described second is counted
It is identical according to the data list structure in the data list structure target database associated with it in library.
Further, a kind of data-base capacity-enlarging device provided by the embodiments of the present application further include: backup units are used for institute
The data backup stored in target database is stated into the second database associated with it.
In the embodiment of the present application, it is preferred that each of described Database Systems database is for storage and institute
State the data information of the user identifier of database association, wherein the database is the first database or the second database.
The embodiment of the present application provides a kind of data-base capacity-enlarging device, applied to the data including at least one first database
Library system, this method is in the case where Database Systems meet preset data-base capacity-enlarging condition, from least one the first data
At least one target database is determined in library;The dilatation amount of each target database is determined respectively;Increase in Database Systems
The second database corresponding with the dilatation amount of each target database respectively, and by target database corresponding with its dilatation amount
Two database associations (data list structure in data list structure target database associated with it in the second database is identical).
It is the target data that the device, which is based on automatic increased and associated second database of target database in Database Systems,
Library dilatation, so that the second database is target database sharing data store tasks associated with it, so that guaranteeing number
Under the premise of according to orderly storage, data storage requirement is met.
Each embodiment in this specification is described in a progressive manner, the highlights of each of the examples are with other
The difference of embodiment, the same or similar parts in each embodiment may refer to each other.For device disclosed in embodiment
For, since it is corresponded to the methods disclosed in the examples, so being described relatively simple, related place is said referring to method part
It is bright.
The above is only the preferred embodiment of the application, make skilled artisans appreciate that or realization the application.It is right
A variety of modifications of these embodiments will be apparent to one skilled in the art, general original as defined herein
Reason can be realized in other embodiments without departing from the spirit or scope of the application.Therefore, the application will not
Be intended to be limited to the embodiments shown herein, and be to fit to it is consistent with the principles and novel features disclosed in this article most
Wide range.
Claims (10)
1. a kind of data-base capacity-enlarging method, which is characterized in that applied to the Database Systems including at least one first database,
This method comprises:
In the case where the Database Systems meet preset data-base capacity-enlarging condition, from least one described first database
At least one target database of middle determination;
The dilatation amount of each target database is determined respectively;
Increase the second database corresponding with the dilatation amount of each target database respectively in the Database Systems, and
By the target database the second database association corresponding with its dilatation amount, data list structure in second database with
Data list structure in associated target database is identical.
2. the method according to claim 1, wherein further include:
By the data backup stored in the target database into the second database associated with it.
3. method described in -2 any one according to claim 1, which is characterized in that each of described Database Systems are described
Database is for storing and the data information of the user identifier of the database association, wherein the database is described first
Database or the second database.
4. according to the method described in claim 3, it is characterized in that, the data list structure in each database is identical, institute
The data list structure stated in database includes at least first tables of data, and at least second tables of data,
Every first tables of data is for storing and the order basic information of the associated user identifier of the first tables of data, institute
Stating order basic information includes order note identification;
Every second tables of data is for storing and the order details of the associated order note identification of the second tables of data;Its
In, the data information of the user identifier includes in the order basic information and the order basic information of the user identifier
Order note identification order details.
5. according to the method described in claim 4, it is characterized in that, each first database is determined as a mesh respectively
Database is marked, each of described Database Systems database is provided with unique database accession number, each data
Difference in the number of library between the adjacent any two database accession number of database accession number size is 1, each database accession number
In the smallest database accession number be 0, the database accession number of the first database and the first database it is associated second number
It is identical as the number of at least one first database according to the difference between the database accession number in library,
If the number in library carries out the modulus result that Hash modulo operation obtains to the first content of user identifier based on the data
It is identical as wide area information server number, determine the user identifier and the database association.
6. according to the method described in claim 5, it is characterized in that, every first number at least first tables of data
It is provided with the first number according to table, in each first number between the adjacent number of any two first of the first number size
Difference is 1, and the smallest first number is 0 in each first number,
If the number based on first tables of data carries out the modulus that Hash modulo operation obtains to the second content of user identifier
As a result identical as the first number of the first tables of data, determine that the user identifier is associated with first tables of data, described second
Content is different from the first content.
7. according to the method described in claim 6, it is characterized in that, every second number at least second tables of data
It is provided with the second number according to table, in each second number between the adjacent number of any two second of the second number size
Difference is 1, and the smallest second number is 0 in each second number,
If the number based on second tables of data carries out the modulus result and second that Hash modulo operation obtains to order note identification
Second number of tables of data is identical, determines that the user identifier is associated with second tables of data.
8. a kind of data-base capacity-enlarging device, which is characterized in that applied to the Database Systems including at least one first database,
The device includes:
Target database determination unit, in the case where the Database Systems meet preset data-base capacity-enlarging condition,
At least one target database is determined from least one described first database;
Dilatation amount determination unit, for determining the dilatation amount of each target database respectively;
Dilatation unit, it is corresponding with the dilatation amount of each target database respectively for increasing in the Database Systems
Second database, and by the target database the second database association corresponding with its dilatation amount, in second database
Data list structure target database associated with it in data list structure it is identical.
9. device according to claim 8, which is characterized in that further include:
Backup units, the data backup for will store in the target database is into the second database associated with it.
10. according to device described in claim 8-9 any one, which is characterized in that each institute in the Database Systems
Database is stated for store and the data information of the user identifier of the database association, wherein the database is described the
One database or the second database.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710517146.7A CN109213825A (en) | 2017-06-29 | 2017-06-29 | A kind of data-base capacity-enlarging method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710517146.7A CN109213825A (en) | 2017-06-29 | 2017-06-29 | A kind of data-base capacity-enlarging method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109213825A true CN109213825A (en) | 2019-01-15 |
Family
ID=64976760
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710517146.7A Pending CN109213825A (en) | 2017-06-29 | 2017-06-29 | A kind of data-base capacity-enlarging method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109213825A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112487222A (en) * | 2020-11-30 | 2021-03-12 | 江苏正赫通信息科技有限公司 | Method for quickly searching and effectively storing similar human faces |
Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102930062A (en) * | 2012-11-30 | 2013-02-13 | 南京富士通南大软件技术有限公司 | Rapid horizontal extending method for databases |
CN103838770A (en) * | 2012-11-26 | 2014-06-04 | 中国移动通信集团北京有限公司 | Logic data partition method and system |
CN104111924A (en) * | 2013-04-16 | 2014-10-22 | 中国移动通信集团广东有限公司 | Database system |
CN105069109A (en) * | 2015-08-07 | 2015-11-18 | 北京思特奇信息技术股份有限公司 | Dilatation method and system of distributed database |
CN105955662A (en) * | 2016-04-22 | 2016-09-21 | 浪潮(北京)电子信息产业有限公司 | Method and system for expansion of K-DB data table space |
CN105989015A (en) * | 2015-01-28 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Capacity expanding method of database and database accessing method and device |
CN106897409A (en) * | 2017-02-16 | 2017-06-27 | 北京致远互联软件股份有限公司 | Data point library storage method and device |
CN106897332A (en) * | 2016-06-14 | 2017-06-27 | 阿里巴巴集团控股有限公司 | Data-base capacity-enlarging method and device |
-
2017
- 2017-06-29 CN CN201710517146.7A patent/CN109213825A/en active Pending
Patent Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103838770A (en) * | 2012-11-26 | 2014-06-04 | 中国移动通信集团北京有限公司 | Logic data partition method and system |
CN102930062A (en) * | 2012-11-30 | 2013-02-13 | 南京富士通南大软件技术有限公司 | Rapid horizontal extending method for databases |
CN104111924A (en) * | 2013-04-16 | 2014-10-22 | 中国移动通信集团广东有限公司 | Database system |
CN105989015A (en) * | 2015-01-28 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Capacity expanding method of database and database accessing method and device |
CN105069109A (en) * | 2015-08-07 | 2015-11-18 | 北京思特奇信息技术股份有限公司 | Dilatation method and system of distributed database |
CN105955662A (en) * | 2016-04-22 | 2016-09-21 | 浪潮(北京)电子信息产业有限公司 | Method and system for expansion of K-DB data table space |
CN106897332A (en) * | 2016-06-14 | 2017-06-27 | 阿里巴巴集团控股有限公司 | Data-base capacity-enlarging method and device |
CN106897409A (en) * | 2017-02-16 | 2017-06-27 | 北京致远互联软件股份有限公司 | Data point library storage method and device |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112487222A (en) * | 2020-11-30 | 2021-03-12 | 江苏正赫通信息科技有限公司 | Method for quickly searching and effectively storing similar human faces |
CN112487222B (en) * | 2020-11-30 | 2021-11-30 | 江苏正赫通信息科技有限公司 | Method for quickly searching and effectively storing similar human faces |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110389836A (en) | A kind of more cluster management methods, device, server and storage medium | |
CN105630475B (en) | A kind of data label organization system and method for organizing | |
CN109271391A (en) | Date storage method, server, storage medium and device | |
CN110413611A (en) | Data storage, querying method and device | |
CN106982236A (en) | A kind of information processing method, device and system | |
CN105843956A (en) | Paging query method and system | |
CN103561148B (en) | Method and the terminal of contact person's grouping | |
WO2017076297A1 (en) | Finding method and device for equipment storage location | |
CN106095964A (en) | A kind of method that data are carried out visualization filing and search | |
CN107577787A (en) | The method and system of associated data information storage | |
CN109062936A (en) | A kind of data query method, computer readable storage medium and terminal device | |
CN109408522A (en) | A kind of update method and device of user characteristic data | |
CN103701653B (en) | The processing method of a kind of interface hot plug configuration data and network configuration server | |
CN106547870A (en) | Point table method and device of data base | |
CN102932416B (en) | A kind of intermediate data storage method of information flow task, processing method and device | |
CN106537388A (en) | Partitioning a database | |
CN109213825A (en) | A kind of data-base capacity-enlarging method and device | |
CN107679148A (en) | Session lookup method, device and the equipment of a kind of distributed file system | |
CN104899985A (en) | Self-service business processing method and system | |
CN107426610A (en) | Video information synchronous method and device | |
CN113742535A (en) | Generalized retrieval method, device, equipment and storage medium | |
CN111552546B (en) | Task implementation method and device based on multithreading and storage medium | |
CN110221778A (en) | Processing method, system, storage medium and the electronic equipment of hotel's data | |
CN110019863A (en) | A kind of object lookup method, device, terminal device and storage medium | |
CN101452486A (en) | System data management method for [inscriptions on bones or tortoise shells and apparatus thereof |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190115 |
|
RJ01 | Rejection of invention patent application after publication |