CN102663045B - Method and system for processing data information - Google Patents
Method and system for processing data information Download PDFInfo
- Publication number
- CN102663045B CN102663045B CN 201210087382 CN201210087382A CN102663045B CN 102663045 B CN102663045 B CN 102663045B CN 201210087382 CN201210087382 CN 201210087382 CN 201210087382 A CN201210087382 A CN 201210087382A CN 102663045 B CN102663045 B CN 102663045B
- Authority
- CN
- China
- Prior art keywords
- data
- data acquisition
- sequence number
- database
- acquisition
- 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.)
- Expired - Fee Related
Links
Images
Abstract
The invention provides a method and a system for finding data; the method comprises the following steps: counting the total number of data of a main database and an auxiliary database; when the total number of the data of the auxiliary database is larger than or equal to 2, dividing the data of the main database into a first data set and a second data set according to sequence numbers and dividing the data of the auxiliary database into a third data set and a fourth data set according to the sequence numbers; comparing a sequence number of the first data of the second data set of the main database with the sequence number of the first data of the fourth data set of the auxiliary database, or comparing the sequence number of the final data of the first data set of the main database with the sequence number of the final data of the third data set of the auxiliary database, and determining division of the main database according to a comparing result; when the total number of the data of the corresponding data set in a divided auxiliary database is equal to 1, determining deficit data in the auxiliary database, or else, continuously processing iterative division data sets corresponding to the main database and the auxiliary database.
Description
Technical field
The invention belongs to database technical field, relate in particular to a kind of data information processing method and system.
Background technology
Growing along with social informatization, database technology is generally used.For guaranteeing data integrity, usually set up from database to back up.In the prior art, when from database generation shortage of data, can learn the data total number of disappearance, but which bar data what can't determine concrete disappearance is.Therefore, if expect the data that lack, at present can be by rebuilding the mode of leader follower replication system.Yet aforesaid way need to expend huge workload, and brings bad use perception to the user.
Summary of the invention
The invention provides a kind of data information processing method and system to address the above problem.
The invention provides a kind of data information processing method, comprise the following steps.statistics master data base and the data total number from database, and definite master data base reaches the sequence number of every data from database, when described data total number from database is greater than or equal to two, according to the odd even of the data total number of described master data base, the data in described master data base are divided into the first data acquisition and the second data acquisition by sequence number, and according to the odd even of described data total number from database, described data from database are divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein, the first data acquisition is corresponding to the 3rd data acquisition, the second data acquisition is corresponding to the 4th data acquisition.The sequence number of the sequence number of article one data in the second data acquisition of more described master data base and described article one data from the 4th data acquisition of database, the perhaps sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database in the first data acquisition of more described master data base, and determine the division of master data base according to above-mentioned comparative result.Described master data base after relatively determining successively to cut apart and described from database mutual corresponding data acquisition, the data total number of corresponding data set from database after judgement is cut apart equals for the moment, determine the described data that lack by the data acquisition in more described master data base and described data acquisition corresponding from database from database, divide described master data base and described from the corresponding data acquisition of database otherwise continue iteration.
The invention provides a kind of processing data information system, comprise and divide module, comparison module, judge module, described division module connects described comparison module, and described comparison module connects described judge module, and described division module connects described judge module.described division module, be used for the statistics master data base and from the data total number of database, and definite master data base reaches the sequence number of every data from database, when described data total number from database is greater than or equal to two, according to the odd even of the data total number of described master data base, the data in described master data base are divided into the first data acquisition and the second data acquisition by sequence number, and according to the odd even of described data total number from database, described data from database are divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein, the first data acquisition is corresponding to the 3rd data acquisition, the second data acquisition is corresponding to the 4th data acquisition.Described comparison module, be used for the sequence number of article one data of the second data acquisition of more described master data base and the sequence number of described article one data from the 4th data acquisition of database, the perhaps sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database in the first data acquisition of more described master data base, and determine the division of master data base according to above-mentioned comparative result.Described judge module, described master data base after being used for relatively determining to cut apart successively and described from the mutual corresponding data acquisition of database, the data total number of corresponding data set from database after judgement is cut apart equals for the moment, determine the described data that lack by the data acquisition in more described master data base and described data acquisition corresponding from database from database, divide described master data base and described from the corresponding data acquisition of database otherwise continue iteration.
Compared to prior art, according to data information processing method provided by the invention and system, pre-determine master data base and from database every data sequence number and according to the even-odd partition master data base of data number and from database, first data or last the data based corresponding relation of dividing rear each several part compared, determine the division scope of master data base data according to comparative result.By the dividing data set, can reduce the workload that data are searched in comparison.When data number from the set of database corresponding data equals for the moment, determine the data that lack from database, otherwise, continue that iteration is divided master data base and from data acquisition corresponding to database.Search the data of disappearance by said method, can not only save a large amount of manpower and materials, but also can be by the data of disappearance, the problem that the analytic system operation occurs is so that timely repair system leak.
Description of drawings
Accompanying drawing described herein is used to provide a further understanding of the present invention, consists of the application's a part, and illustrative examples of the present invention and explanation thereof are used for explaining the present invention, do not consist of improper restriction of the present invention.In the accompanying drawings:
Figure 1 shows that the process flow diagram of the data information processing method that preferred embodiment according to the present invention provides;
The schematic diagram of the processing data information system that Figure 2 shows that preferred embodiment according to the present invention provides.
Embodiment
Hereinafter also describe in conjunction with the embodiments the present invention in detail with reference to accompanying drawing.Need to prove, in the situation that do not conflict, embodiment and the feature in embodiment in the application can make up mutually.
Figure 1 shows that the process flow diagram of the data information processing method that preferred embodiment according to the present invention provides.As shown in Figure 1, the data information processing method that provides of preferred embodiment of the present invention comprises step 101～103.
step 101: statistics master data base and the data total number from database, and definite master data base reaches the sequence number of every data from database, when described data total number from database is greater than or equal to two, according to the odd even of the data total number of described master data base, the data in described master data base are divided into the first data acquisition and the second data acquisition by sequence number, and according to the odd even of described data total number from database, described data from database are divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein, the first data acquisition is corresponding to the 3rd data acquisition, the second data acquisition is corresponding to the 4th data acquisition.
Particularly, when determining the sequence number of master data base and every data from database, master data base has identical sequence number with the data of identical content from database.
If the data total number from database is zero, all data in master data base are described data from the database disappearance.For example, if the data total number that statistics obtains master data base m is 100, be zero from the data total number of database n, because from database n being is copied by master data base m to get, the total data of master data base m is from the data of database n disappearance.
If be one from the data total number of database, search the data that have same sequence number with the data from database in master data base, in master data base, other all data according to this are from the data of database disappearance except this number.For example, be 10 if statistics obtains the data total number of master data base p, and each data sequence number is followed successively by 1～10.From database r the data total number be 1 and this data sequence number be 6.Search sequence number and be 6 data in master data base p, other all data except sequence number is 6 data in master data base p, that is, sequence number is 1～5,7～10 data, is the data from database r disappearance.
When if the data total number from database is greater than or equal to two, according to the odd even of the data total number of described master data base, the data in described master data base are divided into the first data acquisition and the second data acquisition by sequence number, and according to the odd even of described data total number from database, described data from database are divided into the 3rd data acquisition and the 4th data acquisition by sequence number.In this, if described master data base or the data total number from database are even number, the data number in described the first data acquisition and the second data acquisition is identical, data number in described the 3rd data acquisition and the 4th data acquisition is identical, if described master data base or the data total number from database are odd number, the data number in described the first data acquisition is larger one than the data number in described the second data acquisition, and the data number in described the 3rd data acquisition is than the data number large in described the 4th data acquisition.For example, if master data base c has 4 data, from database d, 3 data are arranged.Master data base c is divided into the first data acquisition that comprises sequence number 1 and 2 data and comprises sequence number 3 and the second data acquisition of 4 data, be divided into the 3rd data acquisition that comprises front 2 data and the 4th data acquisition that comprises rear 1 data from database d by sequence number.
Step 102: the sequence number of the sequence number of article one data in the second data acquisition of more described master data base and described article one data from the 4th data acquisition of database, the perhaps sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database in the first data acquisition of more described master data base, and determine the division of master data base according to above-mentioned comparative result.
wherein, in the ban relatively during the sequence number of the sequence number of article one data in the second data acquisition of master data base and article one data from the 4th data acquisition of database, if the sequence number of article one data in the second data acquisition is greater than the sequence number of article one data in the 4th data acquisition, the relatively sequence number of order and the sequence number of article one data in the 4th data acquisition from back to front in the first data acquisition successively, cut apart sequence number until obtain first in the first data acquisition, and cut apart sequence number by first and again cut apart master data base, wherein, first cuts apart the sequence number that sequence number is not more than article one data in described the 4th data acquisition, and first cuts apart the sequence number that sequence number is article one data in the second data acquisition after master data base is cut apart again.If the sequence number of article one data in the second data acquisition is less than the sequence number of article one data in the 4th data acquisition, the more relatively sequence number of the last item data and the sequence number of the last item data from the 3rd data acquisition of database in the first data acquisition of master data base.
If the sequence number of article one data in the second data acquisition equals the sequence number of article one data in described the 4th data acquisition, whether more described the first data acquisition and described the 3rd data acquisition be identical, whether described the second data acquisition and described the 4th data acquisition be identical, if not identical, continue the data acquisition that iteration is divided described not identical correspondence.
For example, if master data base a have 10 data (for example be expressed as a[1], a[2], a[3], a[4], a[5], a[6], a[7], a[8], a[9], a[10]), from database b have 8 data (for example be expressed as a[1], a[2], a[3], a[4], a[5] and, a[6], a[7] and, a[8]).In square bracket, numeral is data sequence numbers corresponding to these data, and the data sequence number marker method is identical therewith in other embodiments.In this, master data base a can be divided into the first data acquisition a[1], a[2], a[3], a[4], a[5] and the second data acquisition a[6], a[7], a[8], a[9], a[10] }, simultaneously can be divided into from database b the 3rd data acquisition a[1], a[2], a[3], a[4] and the 4th data acquisition a[5], a[6], a[7], a[8].The first a[6 in the second data acquisition relatively] sequence number and the 4th data acquisition in a[5] sequence number, due to the former greater than the latter, therefore, next the relatively sequence number of order and the a[5 in the 4th data acquisition from back to front in the first data acquisition successively] sequence number, until get the sequence number of article one data of being not more than in described the 4th data acquisition (for example obtain a[5 in the first data acquisition]) in the first data acquisition, and described sequence number is cut apart sequence number as first.In this, obtain first to cut apart sequence number be a[5 in the first data acquisition] corresponding sequence number.Accordingly, can repartition master data base a, and the first data acquisition that obtains upgrading a[1], and a[2], a[3] and, a[4] and the second data acquisition of upgrading a[5], and a[6], a[7] and, a[8], a[9] and, a[10].In this, the first data acquisition after renewal is identical with the 3rd data acquisition, and the second data acquisition after renewal is not identical with the 4th data acquisition, therefore, continues the second data acquisition and the 4th data acquisition after iteration is divided renewal.
on the other hand, in the ban relatively in the first data acquisition of master data base during the sequence number of the sequence number of the last item data and the last item data from the 3rd data acquisition of database, if in the first data acquisition, the sequence number of the last item data is less than the sequence number of the last item data in the 3rd data acquisition, the sequence number of the last item data in the sequence number of order and the 3rd data acquisition from front to back in the second data acquisition relatively successively, cut apart sequence number until obtain second in the second data acquisition, and cut apart sequence number according to second and again cut apart master data base, wherein, second cuts apart the sequence number that sequence number is not less than the last item data in the 3rd data acquisition, and second cuts apart the sequence number that sequence number is the last item data in the first data acquisition after master data base is cut apart again.If in the first data acquisition, the sequence number of the last item data is greater than the sequence number of the last item data in the 3rd data acquisition, the more relatively sequence number of article one data in the second data acquisition of master data base and the sequence number of article one data from the 4th data acquisition of database.
If in the first data acquisition, the sequence number of the last item data equals the sequence number of the last item data in the 3rd data acquisition, whether more described the first data acquisition and described the 3rd data acquisition be identical, whether described the second data acquisition and described the 4th data acquisition be identical, if not identical, continue iteration and divide described not identical data acquisition.
For example, if master data base c have 4 data (for example be expressed as c[1], c[2], c[3], c[4]), from database d have 3 data (for example be expressed as c[2], c[3], c[4] }).In this, master data base c can be divided into the first data acquisition { c[1], c[2] } and the second data acquisition { c[3], c[4] }, can will be divided into the 3rd data acquisition { c[2], c[3] } and the 4th data acquisition { c[4] } from database d simultaneously.In this, the first c[2 in the first data acquisition relatively] sequence number and the 3rd data acquisition in c[3] sequence number, due to the former less than the latter, therefore, next the relatively sequence number of order and the c[3 in the 3rd data acquisition from front to back in the second data acquisition successively] sequence number, until get the sequence number of the last item data of being not less than in the 3rd data acquisition (for example obtain c[3 in the second data acquisition]) in the second data acquisition, and described sequence number is cut apart sequence number as second.In this, obtain second to cut apart sequence number be c[3 in the second data acquisition] corresponding sequence number.Accordingly, can repartition master data base c, and the first data acquisition that obtains upgrading c[1], and c[2], c[3] and the second data acquisition of upgrading c[4] }.In this, the second data acquisition after renewal is identical with the 4th data acquisition, and the first data acquisition after renewal is not identical with the 3rd data acquisition, therefore, continues the first data acquisition and the 3rd data acquisition after iteration is divided renewal.
Step 103: the described master data base after relatively determining successively to cut apart and described from database mutual corresponding data acquisition, the data total number of corresponding data set from database after judgement is cut apart equals for the moment, determine the described data that lack by the data acquisition in more described master data base and described data acquisition corresponding from database from database, divide described master data base and described from the corresponding data acquisition of database otherwise continue iteration.
Particularly, divide master data base and from database the process of corresponding data acquisition in iteration, judge whether all data numbers that comprise after cutting apart are one from the database data set.When from data acquisition corresponding to database, data only being arranged, search in the method for missing data and step 101 exemplary method similar from master data base, therefore repeat no more in this.Otherwise, divide described master data base and described from the corresponding data acquisition of database if the data total number of the corresponding data set from database after judgement is cut apart greater than one, continues iteration.
The below is to illustrate the data search process from data instance of database disappearance.Master data base c in step 102 reaches the detailed description from database d as example, after master data base c is cut apart again, the second data acquisition { c[4] } and the 4th data acquisition c[4] } identical, and the first data acquisition c[1], c[2], c[3] and the 3rd data acquisition c[2], c[3] not identical, therefore, continue iteration and divide the first data acquisition and the 3rd data acquisition.Particularly, with the first data acquisition c[1], c[2], c[3] } be divided into the first new data acquisition c[1], c[2] } and new the second data acquisition { c[3] }, the 3rd data acquisition { c[2], c[3] } is divided into the 3rd new data acquisition { c[2] } and new the 4th data acquisition { c[3] }.By more as can be known, the second new data acquisition { c[3] } and new the 4th data acquisition c[3] } identical.In addition, only comprise a sequence number in the 3rd new data acquisition { c[2] } and be 2 data, therefore, in the first new data acquisition { c[1], c[2] } except c[2] other data (be c[1]) be the data from database d disappearance.
Next from two data instances of database disappearance, the data search processes to be described.Master data base a in step 102 reaches the detailed description from database b as example, after master data base a is cut apart again, the first data acquisition a[1], a[2], a[3], a[4] and the 3rd data acquisition a[1], and a[2], a[3], a[4] } identical, and the second data acquisition a[5], a[6], a[7], a[8], a[9], a[10] } and the 4th data acquisition a[5], and a[6], a[7], a[8] } not identical, therefore, continue iteration and divide the second data acquisition and the 4th data acquisition.Particularly, at first with the second data acquisition a[5], a[6], a[7], a[8], a[9], a[10] } be divided into the 5th data acquisition a[5], a[6], a[7] and the 6th data acquisition a[8], a[9], a[10] }, the 4th data acquisition is divided into the 7th data acquisition { a[5], a[6] } and the 8th data acquisition { a[7], a[8] }.Then, according to the comparative approach in step 102, again cut apart the second data acquisition, thereby the 5th data acquisition that obtains upgrading { a[5], a[6] } and the 6th data acquisition that upgrades a[7], and a[8], a[9] and, a[10].At this moment, the 5th data acquisition after renewal is identical with the 7th data acquisition, and the 6th data acquisition after renewal is not identical with the 8th data acquisition, therefore, continues the 6th data acquisition and the 8th data acquisition after iteration is divided renewal.
Still according to the comparison determination methods in step 102, the 6th data acquisition after can determining to upgrade be divided into the 9th data acquisition { a[7] } and the tenth data acquisition a[8], a[9], a[10] }, simultaneously the 8th data acquisition may be partitioned into the 11 data acquisition { a[7] } and the 12 data acquisition { a[8] }.Wherein, the 9th data acquisition after cutting apart is identical with the 11 data acquisition, and the 12 data acquisition only has a[8] data, therefore, search sequence number in the tenth data acquisition and be 8 data, in the tenth data acquisition except a[8] other data (be a[9] and a[10]) be two data from database b disappearance.
When from the data of database disappearance during greater than two, again the dividing method of master data base and master data base and the process of dividing from database corresponding data set iteration, similar with above-mentioned processing mode in two data situations of database disappearance, therefore repeat no more in this.
The schematic diagram of the processing data information system that Figure 2 shows that preferred embodiment according to the present invention provides.As shown in Figure 2, preferred embodiment of the present invention provides processing data information system comprises and divides module 201, comparison module 202, judge module 203, described division module 201 connects described comparison module 202, described comparison module 202 connects described judge module 203, and described division module 201 connects described judge module 203.described division module 201, be used for the statistics master data base and from the data total number of database, and definite master data base reaches the sequence number of every data from database, when described data total number from database is greater than or equal to two, according to the odd even of the data total number of described master data base, the data in described master data base are divided into the first data acquisition and the second data acquisition by sequence number, and according to the odd even of described data total number from database, described data from database are divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein, the first data acquisition is corresponding to the 3rd data acquisition, the second data acquisition is corresponding to the 4th data acquisition.Described comparison module 202, be used for the sequence number of article one data of the second data acquisition of more described master data base and the sequence number of described article one data from the 4th data acquisition of database, the perhaps sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database in the first data acquisition of more described master data base, and determine the division of master data base according to above-mentioned comparative result.Described judge module 203, described master data base after being used for relatively determining to cut apart successively and described from the mutual corresponding data acquisition of database, the data total number of corresponding data set from database after judgement is cut apart equals for the moment, determine the described data that lack by the data acquisition in more described master data base and described data acquisition corresponding from database from database, divide described master data base and described from the corresponding data acquisition of database otherwise continue iteration.The workflow of the present embodiment provides processing data information system is identical with the aforementioned data information processing method, therefore repeat no more in this.
In sum, the data information processing method that preferred embodiment provides according to the present invention and system, when from the data of database disappearance during more than or equal to two, determine master data base and from database every data sequence number and according to the even-odd partition master data base of data number and from database, first data or last the data based corresponding relation of dividing rear each several part compared, determine the division scope of master data base data according to comparative result.When data number from the set of database corresponding data equals for the moment, determine the data that lack from database, otherwise, continue that iteration is divided master data base and from data acquisition corresponding to database.Said method is divided master data base and from the corresponding data acquisition of database by iteration, finds the data of disappearance and is inserted into from database, has avoided rebuilding the harmful effect of leader follower replication system, and provides guarantee for the optimum operation of maintenance system.
The above is only the preferred embodiments of the present invention, is not limited to the present invention, and for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (7)
1. a data information processing method, is characterized in that, comprises the following steps:
statistics master data base and the data total number from database, and definite master data base reaches the sequence number of every data from database, when described data total number from database is greater than or equal to two, according to the odd even of the data total number of described master data base, the data in described master data base are divided into the first data acquisition and the second data acquisition by sequence number, and according to the odd even of described data total number from database, described data from database are divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein, the first data acquisition is corresponding to the 3rd data acquisition, the second data acquisition is corresponding to the 4th data acquisition,
The sequence number of the sequence number of article one data in the second data acquisition of more described master data base and described article one data from the 4th data acquisition of database, the perhaps sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database in the first data acquisition of more described master data base, and determine the division of master data base according to above-mentioned comparative result
wherein, in the ban during the sequence number of the sequence number of article one data in the second data acquisition of more described master data base and described article one data from the 4th data acquisition of database, if the sequence number of article one data in described the second data acquisition is greater than the sequence number of article one data in described the 4th data acquisition, the sequence number of order and the sequence number of article one data in described the 4th data acquisition from back to front in more described the first data acquisition successively, cut apart sequence number until obtain first in described the first data acquisition, and cut apart sequence number by described first and again cut apart described master data base, wherein, described first cuts apart the sequence number that sequence number is not more than article one data in described the 4th data acquisition, and described first cuts apart the sequence number that sequence number is article one data in the second data acquisition after described master data base is cut apart again,
If the sequence number of article one data in described the second data acquisition is less than the sequence number of article one data in described the 4th data acquisition, the sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database in the first data acquisition of more described master data base again
in the ban in the first data acquisition of more described master data base during the sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database, if in described the first data acquisition, the sequence number of the last item data is less than the sequence number of the last item data in described the 3rd data acquisition, the sequence number of the last item data in the sequence number of order and described the 3rd data acquisition from front to back in more described the second data acquisition successively, cut apart sequence number until obtain second in described the second data acquisition, and cut apart sequence number according to described second and again cut apart described master data base, wherein, described second cuts apart the sequence number that sequence number is not less than the last item data in described the 3rd data acquisition, and described second cuts apart the sequence number that sequence number is the last item data in the first data acquisition after described master data base is cut apart again,
If in described the first data acquisition, the sequence number of the last item data is greater than the sequence number of the last item data in described the 3rd data acquisition, then the sequence number of the sequence number of article one data in the second data acquisition of more described master data base and described article one data from the 4th data acquisition of database;
Described master data base after relatively determining successively to cut apart and described from database mutual corresponding data acquisition, the data total number of corresponding data set from database after judgement is cut apart equals for the moment, determine the described data that lack by the data acquisition in more described master data base and described data acquisition corresponding from database from database, divide described master data base and described from the corresponding data acquisition of database otherwise continue iteration.
2. method according to claim 1, it is characterized in that, if the sequence number of article one data in described the second data acquisition equals the sequence number of article one data in described the 4th data acquisition, whether more described the first data acquisition and described the 3rd data acquisition be identical, whether described the second data acquisition and described the 4th data acquisition be identical, if not identical, continue iteration and divide described not identical data acquisition.
3. method according to claim 1, it is characterized in that, if in described the first data acquisition, the sequence number of the last item data equals the sequence number of the last item data in described the 3rd data acquisition, whether more described the first data acquisition and described the 3rd data acquisition be identical, whether described the second data acquisition and described the 4th data acquisition be identical, if not identical, continue iteration and divide described not identical data acquisition.
4. method according to claim 1, is characterized in that, when statistics obtained described data total number from database and is zero, all data in described master data base were described data from the database disappearance.
5. method according to claim 1, it is characterized in that, when obtaining described data total number from database, statistics is a period of time, search the data that have same sequence number with described data from database in described master data base, in described master data base, other all data except above-mentioned data are described data from the database disappearance.
6. method according to claim 1, it is characterized in that, according to the odd even of the data total number of described master data base, the data in described master data base are divided into the first data acquisition and the second data acquisition by sequence number, and according to the odd even of described data total number from database, described data from database are divided into the 3rd data acquisition and the 4th data acquisition by sequence number, if described master data base or the data total number from database are even number, the data number in described the first data acquisition and the second data acquisition is identical, data number in described the 3rd data acquisition and the 4th data acquisition is identical, if described master data base or the data total number from database are odd number, the data number in described the first data acquisition is than the data number large in described the second data acquisition, data number in described the 3rd data acquisition is than the data number large in described the 4th data acquisition.
7. a processing data information system, is characterized in that, comprises dividing module, comparison module, judge module, and described division module connects described comparison module, and described comparison module connects described judge module, and described division module connects described judge module,
described division module, be used for the statistics master data base and from the data total number of database, and definite master data base reaches the sequence number of every data from database, when described data total number from database is greater than or equal to two, according to the odd even of the data total number of described master data base, the data in described master data base are divided into the first data acquisition and the second data acquisition by sequence number, and according to the odd even of described data total number from database, described data from database are divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein, the first data acquisition is corresponding to the 3rd data acquisition, the second data acquisition is corresponding to the 4th data acquisition,
Described comparison module, be used for the sequence number of article one data of the second data acquisition of more described master data base and the sequence number of described article one data from the 4th data acquisition of database, the perhaps sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database in the first data acquisition of more described master data base, and determine the division of master data base according to above-mentioned comparative result
wherein, in the ban during the sequence number of the sequence number of article one data in the second data acquisition of more described master data base and described article one data from the 4th data acquisition of database, if the sequence number of article one data in described the second data acquisition is greater than the sequence number of article one data in described the 4th data acquisition, the sequence number of order and the sequence number of article one data in described the 4th data acquisition from back to front in more described the first data acquisition successively, cut apart sequence number until obtain first in described the first data acquisition, and cut apart sequence number by described first and again cut apart described master data base, wherein, described first cuts apart the sequence number that sequence number is not more than article one data in described the 4th data acquisition, and described first cuts apart the sequence number that sequence number is article one data in the second data acquisition after described master data base is cut apart again,
If the sequence number of article one data in described the second data acquisition is less than the sequence number of article one data in described the 4th data acquisition, the sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database in the first data acquisition of more described master data base again
in the ban in the first data acquisition of more described master data base during the sequence number of the sequence number of the last item data and described the last item data from the 3rd data acquisition of database, if in described the first data acquisition, the sequence number of the last item data is less than the sequence number of the last item data in described the 3rd data acquisition, the sequence number of the last item data in the sequence number of order and described the 3rd data acquisition from front to back in more described the second data acquisition successively, cut apart sequence number until obtain second in described the second data acquisition, and cut apart sequence number according to described second and again cut apart described master data base, wherein, described second cuts apart the sequence number that sequence number is not less than the last item data in described the 3rd data acquisition, and described second cuts apart the sequence number that sequence number is the last item data in the first data acquisition after described master data base is cut apart again,
If in described the first data acquisition, the sequence number of the last item data is greater than the sequence number of the last item data in described the 3rd data acquisition, then the sequence number of the sequence number of article one data in the second data acquisition of more described master data base and described article one data from the 4th data acquisition of database;
Described judge module, described master data base after being used for relatively determining to cut apart successively and described from the mutual corresponding data acquisition of database, the data total number of corresponding data set from database after judgement is cut apart equals for the moment, determine the described data that lack by the data acquisition in more described master data base and described data acquisition corresponding from database from database, divide described master data base and described from the corresponding data acquisition of database otherwise continue iteration.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201210087382 CN102663045B (en) | 2012-03-29 | 2012-03-29 | Method and system for processing data information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201210087382 CN102663045B (en) | 2012-03-29 | 2012-03-29 | Method and system for processing data information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102663045A CN102663045A (en) | 2012-09-12 |
| CN102663045B true CN102663045B (en) | 2013-11-06 |
Family
ID=46772536
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201210087382 Expired - Fee Related CN102663045B (en) | 2012-03-29 | 2012-03-29 | Method and system for processing data information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102663045B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020243A (en) * | 2012-12-18 | 2013-04-03 | 新浪网技术(中国)有限公司 | Method and device for master-slave replication structure replacement of database |
| CN105045830B (en) * | 2015-06-30 | 2018-08-07 | 北京奇艺世纪科技有限公司 | A kind of data correlation method and device |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR100414052B1 (en) * | 2000-10-14 | 2004-01-07 | 엘지전자 주식회사 | Index data management method for main memory database |
| CN102110121B (en) * | 2009-12-24 | 2015-09-23 | 阿里巴巴集团控股有限公司 | A kind of data processing method and system thereof |
| CN102184192A (en) * | 2011-04-19 | 2011-09-14 | 中兴通讯股份有限公司 | Data timing synchronization method and system |
-
2012
- 2012-03-29 CN CN 201210087382 patent/CN102663045B/en not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CN102663045A (en) | 2012-09-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110292775B (en) | Method and device for acquiring difference data | |
| CN101446962B (en) | Data conversion method, device thereof and data processing system | |
| CN104331285A (en) | Automatic code generation method and system | |
| CN107748752B (en) | Data processing method and device | |
| WO2006052442A3 (en) | Audience targeting system with segment management | |
| CN105654201B (en) | Advertisement traffic prediction method and device | |
| CN107315657B (en) | Data backup method and device | |
| CN104299151A (en) | Online advertising flow distribution system and method | |
| GB2517885A (en) | Method and apparatus for processing database data in distributed database system | |
| CN104063361A (en) | Report design method and system | |
| JP6090850B2 (en) | Source program analysis system, source program analysis method and program | |
| CN103019728A (en) | Effective complex report parsing engine and parsing method thereof | |
| WO2012030853A3 (en) | User list identification | |
| CN110196758A (en) | Data processing method and device, storage medium and electronic device | |
| CN103714086A (en) | Method and device used for generating non-relational data base module | |
| CN102467525A (en) | Document associating method and system | |
| CN102693460A (en) | Tester management system and method thereof | |
| CN102929999A (en) | Method and device for comparing similarities and differences of data | |
| CN102521713B (en) | Data processing equipment and data processing method | |
| CN102663045B (en) | Method and system for processing data information | |
| CN104298761A (en) | Implementation method for master data matching between heterogeneous software systems | |
| CN110910054A (en) | Method and device for determining track and method and device for recommending time | |
| CN105488692A (en) | Method and device for computing number of online users | |
| CN102081644A (en) | Data storage method for storing data and data meanings separately | |
| CN106547584A (en) | A kind of backing method and device of application program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Suzhou City, Jiangsu province 215121 Fengting Avenue Suzhou Industrial Park No. 666 Weiting Intelligent Industrial Park Building 8 Patentee after: CODYY EDUCATION TECHNOLOGY Co.,Ltd. Address before: Suzhou City, Jiangsu province 215121 Fengting Avenue Suzhou Industrial Park No. 666 Weiting Intelligent Industrial Park Building 8 Patentee before: SUZHOU CODYY NETWORK SCIENCE & TECHNOLOGY Co.,Ltd. |
|
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20131106 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |