CN102663045A - Method and system for processing data information - Google Patents
Method and system for processing data information Download PDFInfo
- Publication number
- CN102663045A CN102663045A CN2012100873827A CN201210087382A CN102663045A CN 102663045 A CN102663045 A CN 102663045A CN 2012100873827 A CN2012100873827 A CN 2012100873827A CN 201210087382 A CN201210087382 A CN 201210087382A CN 102663045 A CN102663045 A CN 102663045A
- Authority
- CN
- China
- Prior art keywords
- data
- data acquisition
- sequence number
- database
- mdl
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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 by widespread usage.For guaranteeing data integrity, set up from database to back up usually.In the prior art,, can learn the data total number of disappearance, but which bar data what can't confirm concrete disappearance is when when database generation data lack.Therefore, if expect the data that lack, at present can be through rebuilding the mode of leader follower replication system.Yet aforesaid way need expend huge workload, and brings bad use perception to the user.
Summary of the invention
The present invention provides a kind of data information processing method and system to address the above problem.
The present invention provides a kind of data information processing method, may further comprise the steps.Statistics MDL and the data total number from database; And definite MDL reaches the sequence number of every data from database; When said data total number from database is greater than or equal to two; Odd even according to the data total number of said MDL is divided into first data acquisition and second data acquisition with the data in the said MDL by sequence number, and according to said odd even from the data of database total number said data from database is divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein; First data acquisition is corresponding to the 3rd data acquisition, and second data acquisition is corresponding to the 4th data acquisition.The sequence number of the sequence number of article one data in second data acquisition of more said MDL and said article one data from the 4th data acquisition of database; The perhaps sequence number of the sequence number of the last item data and said the last item data from the 3rd data acquisition of database in first data acquisition of more said MDL, and confirm the division of MDL according to above-mentioned comparative result.Said MDL after relatively confirming successively to cut apart and said data acquisition corresponding each other from database; The data total number of the set of corresponding data from database after judgement obtains cutting apart equals for the moment; Confirm the said data that from database, lack through data acquisition in the more said MDL and said data acquisition corresponding from database, divide said MDL and said from the corresponding data acquisition of database otherwise continue iteration.
The present invention provides a kind of processing data information system, comprises dividing module, comparison module, judge module, and said division module connects said comparison module, and said comparison module connects said judge module, and said division module connects said judge module.Said division module; Be used for adding up MDL and reach data total number from database; And definite MDL reaches the sequence number of every data from database; When said data total number from database is greater than or equal to two; Odd even according to the data total number of said MDL is divided into first data acquisition and second data acquisition with the data in the said MDL by sequence number, and according to said odd even from the data of database total number said data from database is divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein; First data acquisition is corresponding to the 3rd data acquisition, and second data acquisition is corresponding to the 4th data acquisition.Said comparison module; Sequence number and the sequence number of said article one data from the 4th data acquisition of database of article one data that is used for second data acquisition of more said MDL; The perhaps sequence number of the sequence number of the last item data and said the last item data from the 3rd data acquisition of database in first data acquisition of more said MDL, and confirm the division of MDL according to above-mentioned comparative result.Said judge module; Said MDL after being used for relatively confirming successively to cut apart and said from the corresponding each other data acquisition of database; The data total number of the set of corresponding data from database after judgement obtains cutting apart equals for the moment; Confirm the said data that from database, lack through data acquisition in the more said MDL and said data acquisition corresponding from database, divide said MDL and said 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; Definite in advance MDL reaches the sequence number of every data from database and divides MDL according to the odd even of data strip number and reaches from database; First data or last data based corresponding relation to dividing the back each several part compare, and confirm the division scope of MDL data according to comparative result.Through the dividing data set, can reduce the workload that data are searched in comparison.When data strip number from database corresponding data set equals for the moment, confirm the data that from database, lack, otherwise, continue that iteration is divided MDL and from the corresponding data acquisition of database.Search the data of disappearance through said method, can not only save lot of manpower and material resources, but also can be through the data of disappearance, the problem that the analytic system operation occurs be so that timely repair system leak.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part, and illustrative examples of the present invention and explanation thereof are used to explain the present invention, do not constitute improper qualification of the present invention.In the accompanying drawings:
The process flow diagram of the data information processing method that provides for preferred embodiment according to the present invention shown in Figure 1;
The synoptic diagram of the processing data information system that provides for preferred embodiment according to the present invention shown in Figure 2.
Embodiment
Hereinafter will and combine embodiment to specify the present invention with reference to accompanying drawing.Need to prove that under the situation of not conflicting, embodiment and the characteristic among the embodiment among the application can make up each other.
The process flow diagram of the data information processing method that provides for preferred embodiment according to the present invention shown in Figure 1.As shown in Figure 1, the data information processing method that preferred embodiment of the present invention provides comprises step 101～103.
Step 101: statistics MDL and the data total number from database; And definite MDL reaches the sequence number of every data from database; When said data total number from database is greater than or equal to two; Odd even according to the data total number of said MDL is divided into first data acquisition and second data acquisition with the data in the said MDL by sequence number, and according to said odd even from the data of database total number said data from database is divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein; First data acquisition is corresponding to the 3rd data acquisition, and second data acquisition is corresponding to the 4th data acquisition.
Particularly, when confirming the sequence number of MDL and every data from database, MDL has identical sequence number with the data of identical content from database.
If the data total number from database is zero, all data in the MDL are said data from the database disappearance.For example, if the data total number that statistics obtains MDL m is 100, be zero from the data total number of database n, owing to be to be duplicated by MDL m to get from database n, then the total data of MDL m is from the data of database n disappearance.
If from the data of database total number is one, in MDL, search the data that have same sequence number with the data from database, then be from the data of database disappearance except that these other all data data in the MDL.For example, be 10 if statistics obtains the data total number of MDL p, and each bar 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.In MDL p, search sequence number and be 6 data, other all data except that sequence number is 6 data among the MDL p then, 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; Odd even according to the data total number of said MDL is divided into first data acquisition and second data acquisition with the data in the said MDL by sequence number, and according to said odd even from the data of database total number said data from database is divided into the 3rd data acquisition and the 4th data acquisition by sequence number.In this; If said MDL or the data total number from database are even number; Data strip number in then said first data acquisition and second data acquisition is identical; Data strip number in said the 3rd data acquisition and the 4th data acquisition is identical; If said MDL or the data total number from database are odd number, the data strip number in then said first data acquisition is bigger by one than the data strip number in said second data acquisition, and the data strip number in said the 3rd data acquisition is bigger by one than the data strip number in said the 4th data acquisition.For example, if MDL c has 4 data, 3 data are arranged from database d.MDL c is divided into first data acquisition that comprises sequence number 1 and 2 data and comprises sequence number 3 and second data acquisition of 4 data, be divided into the 3rd data acquisition that comprises preceding 2 data and the 4th data acquisition that comprises back 1 data by sequence number from database d.
Step 102: the sequence number of the sequence number of article one data in second data acquisition of more said MDL and said article one data from the 4th data acquisition of database; The perhaps sequence number of the sequence number of the last item data and said the last item data from the 3rd data acquisition of database in first data acquisition of more said MDL, and confirm the division of MDL according to above-mentioned comparative result.
Wherein, In the ban relatively during the sequence number of the sequence number of article one data in second data acquisition of MDL and article one data from the 4th data acquisition of database; If the sequence number of article one data in second data acquisition is greater than the sequence number of article one data in the 4th data acquisition; The then relatively sequence number of order and the sequence number of article one data in the 4th data acquisition from back to front in first data acquisition successively; Cut apart sequence number until in first data acquisition, obtaining first, and cut apart sequence number by first and cut apart MDL again, wherein; First cuts apart the sequence number that sequence number is not more than article one data in said the 4th data acquisition, and first cuts apart the sequence number that sequence number is article one data in second data acquisition after MDL is cut apart again.If the sequence number of article one data in second data acquisition is less than the sequence number of article one data in the 4th data acquisition, the 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 first data acquisition of MDL again.
If the sequence number of article one data in second data acquisition equals the sequence number of article one data in said the 4th data acquisition; Whether more said first data acquisition and said the 3rd data acquisition be identical; Whether said second data acquisition and said the 4th data acquisition be identical; If inequality, continue the data acquisition that iteration is divided said correspondence inequality.
For example, if MDL a has 10 data (for example to be expressed as { a [1], a [2], a [3], a [4], a [5], a [6]; A [7], a [8], a [9], a [10] }), there are 8 data (for example to be expressed as { a [1], a [2] from database b; A [3], a [4], a [5], a [6], a [7], a [8] }).Numeral is the corresponding data sequence numbers of these data in the square bracket, and the data sequence number marker method is identical therewith in other embodiments.In this, can MDL a be divided into first data acquisition { a [1], a [2], a [3], a [4]; A [5] } and second data acquisition { a [6], a [7], a [8], a [9]; A [10] }, simultaneously can be be divided into the 3rd data acquisition { a [1], a [2], a [3] from database b; A [4] } and the 4th data acquisition { a [5], a [6], a [7], a [8] }.The sequence number of a [5] in the sequence number of a [6] in first relatively second data acquisition and the 4th data acquisition; Because the former is greater than the latter; Therefore; Next the relatively sequence number of order and the sequence number of a [5] in the 4th data acquisition from back to front in first data acquisition successively until the sequence number that in first data acquisition, gets access to article one data (for example in first data acquisition, obtaining a [5]) that are not more than in said the 4th data acquisition, and are cut apart sequence number with said sequence number as first.In this, obtain first to cut apart sequence number be a in first data acquisition [5] corresponding sequence number.In view of the above, can repartition MDL a, and second data acquisition { a [5], a [6], a [7], a [8], a [9], a [10] } of first data acquisition that obtains upgrading { a [1], a [2], a [3], a [4] } and renewal.In this, first data acquisition after the renewal is identical with the 3rd data acquisition, and second data acquisition and the 4th data acquisition after the renewal are inequality, therefore, continues iteration and divides second data acquisition and the 4th data acquisition after upgrading.
On the other hand; In the ban relatively in first data acquisition of MDL 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 the sequence number of the last item data is less than the sequence number of the last item data in the 3rd data acquisition in first 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 second data acquisition relatively successively then; Cut apart sequence number until in second data acquisition, obtaining second, and cut apart sequence number according to second and cut apart MDL again, 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 first data acquisition after MDL is cut apart again.If the sequence number of the last item data is greater than the sequence number of the last item data in the 3rd data acquisition in first data acquisition, the relatively sequence number of article one data in second data acquisition of MDL and the sequence number of article one data from the 4th data acquisition of database again.
If the sequence number of the last item data equals the sequence number of the last item data in the 3rd data acquisition in first data acquisition; Whether more said first data acquisition and said the 3rd data acquisition be identical; Whether said second data acquisition and said the 4th data acquisition be identical; If inequality, continue iteration and divide said data acquisition inequality.
For example, if MDL c has 4 data (for example being expressed as { c [1], c [2], c [3], c [4] }), 3 data (for example being expressed as { c [2], c [3], c [4] }) are arranged from database d.In this, can MDL c be divided into first data acquisition { c [1], c [2] } and second data acquisition { c [3], c [4] }, simultaneously can be be divided into the 3rd data acquisition { c [2], c [3] } and the 4th data acquisition { c [4] } from database d.In this; The sequence number of c [3] in the sequence number of c [2] in first relatively first data acquisition and the 3rd data acquisition; Because the former is less than the latter, therefore, the next relatively sequence number of order and the sequence number of the c [3] in the 3rd data acquisition from front to back in second data acquisition successively; Until the sequence number that in second data acquisition, gets access to the last item data (for example in second data acquisition, obtaining c [3]) that are not less than in the 3rd data acquisition, and said sequence number cut apart sequence number as second.In this, obtain second to cut apart sequence number be c in second data acquisition [3] corresponding sequence number.In view of the above, can repartition MDL c, and second data acquisition { c [4] } of first data acquisition that obtains upgrading { c [1], c [2], c [3] } and renewal.In this, second data acquisition after the renewal is identical with the 4th data acquisition, and first data acquisition and the 3rd data acquisition after the renewal are inequality, therefore, continues iteration and divides first data acquisition and the 3rd data acquisition after upgrading.
Step 103: said MDL after relatively confirming successively to cut apart and said data acquisition corresponding each other from database; The data total number of the set of corresponding data from database after judgement obtains cutting apart equals for the moment; Confirm the said data that from database, lack through data acquisition in the more said MDL and said data acquisition corresponding from database, divide said MDL and said from the corresponding data acquisition of database otherwise continue iteration.
Particularly, divide MDL and from the process of the corresponding data acquisition of database, judge whether all data strip numbers that from the database data set, comprise after cutting apart are one in iteration.When the corresponding data acquisition of database only has data, it is similar from MDL, to search in method and the step 101 of missing data exemplary method, so repeat no more in this.Otherwise, if the data total number of judging the set of corresponding data from database after obtaining cutting apart continues iteration and divides said MDL and said from the corresponding data acquisition of database greater than one.
Below to lack a data instance declarative data search procedure from database.With the MDL c in the step 102 and from database d is that example specifies, and after MDL c was cut apart again, second data acquisition { c [4] } was identical with the 4th data acquisition { c [4] }; And first data acquisition { c [1]; C [2], c [3] } inequality with the 3rd data acquisition { c [2], c [3] }; Therefore, continue iteration and divide first data acquisition and the 3rd data acquisition.Particularly, with first data acquisition { c [1], c [2]; C [3] } be divided into the first new data acquisition { c [1]; C [2] } and new 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] }.Through relatively knowing that the second new data acquisition { c [3] } is identical with new the 4th data acquisition { c [3] }.In addition, only comprise a sequence number in the 3rd new data acquisition { c [2] } and be 2 data, therefore, the other data (being c [1]) in the first new data acquisition { c [1], c [2] } except that c [2] are the data from database d disappearance.
Next to lack two data instance declarative data search procedures from database.With the MDL a in the step 102 and from database b is that example specifies, after MDL a is cut apart again, and first data acquisition { a [1], a [2], a [3]; A [4] } identical with the 3rd data acquisition { a [1], a [2], a [3], a [4] }, and second data acquisition { a [5]; A [6], a [7], a [8], a [9], a [10] } and the 4th data acquisition { a [5]; A [6], a [7], a [8] } inequality, therefore, continue iteration and divide second data acquisition and the 4th data acquisition.Particularly, at first with 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,, cut apart second data acquisition again according to the comparative approach in the step 102, thus the 6th data acquisition { a [7], a [8], a [9], a [10] } of the 5th data acquisition that obtains upgrading { a [5], a [6] } and renewal.At this moment, the 5th data acquisition after the renewal is identical with the 7th data acquisition, and the 6th data acquisition and the 8th data acquisition after the renewal are inequality, therefore, continues iteration and divides the 6th data acquisition and the 8th data acquisition after upgrading.
Still according to the comparison determination methods in the step 102; The 6th data acquisition after can confirming to upgrade is divided into the 9th data acquisition { a [7] } and the tenth data acquisition { a [8]; A [9]; A [10] }, the 8th data acquisition may be partitioned into the 11 data acquisition { a [7] } and the 12 data acquisition { a [8] } simultaneously.Wherein, The 9th data acquisition after cutting apart is identical with the 11 data acquisition; And the 12 data acquisition only has [8] data of a; Therefore, search sequence number in the tenth data acquisition and be 8 data, then other data except that a [8] (being a [9] and a [10]) are two data from database b disappearance in the tenth data acquisition.
When from the data of database disappearance during greater than two; Again the dividing method of MDL and MDL and the process of dividing from database corresponding data set iteration; Similar with the above-mentioned processing mode that lacks under two data cases from database, so repeat no more in this.
The synoptic diagram of the processing data information system that provides for preferred embodiment according to the present invention shown in Figure 2.As shown in Figure 2; The processing data information system that preferred embodiment of the present invention provides comprises division module 201, comparison module 202, judge module 203; Said division module 201 connects said comparison module 202; Said comparison module 202 connects said judge module 203, and said division module 201 connects said judge module 203.Said division module 201; Be used for adding up MDL and reach data total number from database; And definite MDL reaches the sequence number of every data from database; When said data total number from database is greater than or equal to two; Odd even according to the data total number of said MDL is divided into first data acquisition and second data acquisition with the data in the said MDL by sequence number, and according to said odd even from the data of database total number said data from database is divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein; First data acquisition is corresponding to the 3rd data acquisition, and second data acquisition is corresponding to the 4th data acquisition.Said comparison module 202; Sequence number and the sequence number of said article one data from the 4th data acquisition of database of article one data that is used for second data acquisition of more said MDL; The perhaps sequence number of the sequence number of the last item data and said the last item data from the 3rd data acquisition of database in first data acquisition of more said MDL, and confirm the division of MDL according to above-mentioned comparative result.Said judge module 203; Said MDL after being used for relatively confirming successively to cut apart and said from the corresponding each other data acquisition of database; The data total number of the set of corresponding data from database after judgement obtains cutting apart equals for the moment; Confirm the said data that from database, lack through data acquisition in the more said MDL and said data acquisition corresponding from database, divide said MDL and said from the corresponding data acquisition of database otherwise continue iteration.The workflow of the processing data information system that present embodiment provides is identical with the aforementioned data information processing method, so repeat no more in this.
In sum; 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; Confirm MDL and from database every data sequence number and divide MDL and from database according to the odd even of data strip number, to first data of dividing the back each several part or last data based corresponding relation relatively, confirm the division scope of MDL data according to comparative result.When data strip number from database corresponding data set equals for the moment, confirm the data that from database, lack, otherwise, continue that iteration is divided MDL and from the corresponding data acquisition of database.Said method is divided MDL through iteration and from the corresponding data acquisition of database, finds the data of disappearance and is inserted into from database, has avoided rebuilding the harmful effect of leader follower replication system, and for the optimum operation of maintenance system guarantee is provided.
The above is merely 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 changes and variation.All within spirit of the present invention and principle, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (9)
1. a data information processing method is characterized in that, may further comprise the steps:
Statistics MDL and the data total number from database; And definite MDL reaches the sequence number of every data from database; When said data total number from database is greater than or equal to two; Odd even according to the data total number of said MDL is divided into first data acquisition and second data acquisition with the data in the said MDL by sequence number, and according to said odd even from the data of database total number said data from database is divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein; First data acquisition is corresponding to the 3rd data acquisition, and second data acquisition is corresponding to the 4th data acquisition;
The sequence number of the sequence number of article one data in second data acquisition of more said MDL and said article one data from the 4th data acquisition of database; The perhaps sequence number of the sequence number of the last item data and said the last item data from the 3rd data acquisition of database in first data acquisition of more said MDL, and confirm the division of MDL according to above-mentioned comparative result;
Said MDL after relatively confirming successively to cut apart and said data acquisition corresponding each other from database; The data total number of the set of corresponding data from database after judgement obtains cutting apart equals for the moment; Confirm the said data that from database, lack through data acquisition in the more said MDL and said data acquisition corresponding from database, divide said MDL and said from the corresponding data acquisition of database otherwise continue iteration.
2. method according to claim 1; It is characterized in that; In the ban during the sequence number of the sequence number of article one data in second data acquisition of more said MDL and said article one data from the 4th data acquisition of database; If the sequence number of article one data in said second data acquisition is greater than the sequence number of article one data in said the 4th data acquisition; Sequence number and the sequence number of article one data in said the 4th data acquisition of order from back to front in then more said successively first data acquisition are cut apart sequence number until in said first data acquisition, obtaining first, and cut apart sequence number by said first and cut apart said MDL again; Wherein, Said first cuts apart the sequence number that sequence number is not more than article one data in said the 4th data acquisition, and said first cuts apart the sequence number that sequence number is article one data in second data acquisition after said MDL is cut apart again
If the sequence number of article one data in said second data acquisition is less than the sequence number of article one data in said the 4th data acquisition, the sequence number of the sequence number of the last item data and said the last item data from the 3rd data acquisition of database in first data acquisition of more said MDL again.
3. method according to claim 2; It is characterized in that; If the sequence number of article one data in said second data acquisition equals the sequence number of article one data in said the 4th data acquisition, whether more said first data acquisition and said the 3rd data acquisition be identical, and whether said second data acquisition and said the 4th data acquisition be identical; If inequality, continue iteration and divide said data acquisition inequality.
4. method according to claim 1; It is characterized in that; In the ban in first data acquisition of more said MDL during the sequence number of the sequence number of the last item data and said the last item data from the 3rd data acquisition of database; If the sequence number of the last item data is less than the sequence number of the last item data in said the 3rd data acquisition in said first data acquisition; The sequence number of the last item data in sequence number and said the 3rd data acquisition of order from front to back in then more said successively second data acquisition is cut apart sequence number until in said second data acquisition, obtaining second, and cuts apart sequence number according to said second and cut apart said MDL again; Wherein, Said second cuts apart the sequence number that sequence number is not less than the last item data in said the 3rd data acquisition, and said second cuts apart the sequence number that sequence number is the last item data in first data acquisition after said MDL is cut apart again
If the sequence number of the last item data is greater than the sequence number of the last item data in said the 3rd data acquisition, the sequence number of the sequence number of article one data in second data acquisition of more said MDL and said article one data from the 4th data acquisition of database again in said first data acquisition.
5. method according to claim 4; It is characterized in that; If the sequence number of the last item data equals the sequence number of the last item data in said the 3rd data acquisition in said first data acquisition, whether more said first data acquisition and said the 3rd data acquisition be identical, and whether said second data acquisition and said the 4th data acquisition be identical; If inequality, continue iteration and divide said data acquisition inequality.
6. method according to claim 1 is characterized in that, when statistics obtains saidly when the data of database total number is zero, all data in the said MDL are said data from the database disappearance.
7. method according to claim 1; It is characterized in that; Is for the moment when statistics obtains said from the data of database total number; In said MDL, search the data that have same sequence number with said data from database, other all data in the then said MDL except that above-mentioned data are said data from the database disappearance.
8. method according to claim 1; It is characterized in that; Odd even according to the data total number of said MDL is divided into first data acquisition and second data acquisition with the data in the said MDL by sequence number; And said data from database are divided into the 3rd data acquisition and the 4th data acquisition by sequence number according to said odd even from the data of database total number; If said MDL or the data total number from database are even number; Data strip number in then said first data acquisition and second data acquisition is identical, and the data strip number in said the 3rd data acquisition and the 4th data acquisition is identical, if said MDL or the data total number from database are odd number; Data strip number in then said first data acquisition is bigger by one than the data strip number in said second data acquisition, and the data strip number in said the 3rd data acquisition is bigger by one than the data strip number in said the 4th data acquisition.
9. a processing data information system is characterized in that, comprises dividing module, comparison module, judge module, and said division module connects said comparison module, and said comparison module connects said judge module, and said division module connects said judge module,
Said division module; Be used for adding up MDL and reach data total number from database; And definite MDL reaches the sequence number of every data from database; When said data total number from database is greater than or equal to two; Odd even according to the data total number of said MDL is divided into first data acquisition and second data acquisition with the data in the said MDL by sequence number, and according to said odd even from the data of database total number said data from database is divided into the 3rd data acquisition and the 4th data acquisition by sequence number, wherein; First data acquisition is corresponding to the 3rd data acquisition, and second data acquisition is corresponding to the 4th data acquisition;
Said comparison module; Sequence number and the sequence number of said article one data from the 4th data acquisition of database of article one data that is used for second data acquisition of more said MDL; The perhaps sequence number of the sequence number of the last item data and said the last item data from the 3rd data acquisition of database in first data acquisition of more said MDL, and confirm the division of MDL according to above-mentioned comparative result;
Said judge module; Said MDL after being used for relatively confirming successively to cut apart and said from the corresponding each other data acquisition of database; The data total number of the set of corresponding data from database after judgement obtains cutting apart equals for the moment; Confirm the said data that from database, lack through data acquisition in the more said MDL and said data acquisition corresponding from database, divide said MDL and said 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 true CN102663045A (en) | 2012-09-12 |
| CN102663045B 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) |
Cited By (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 |
| CN105045830A (en) * | 2015-06-30 | 2015-11-11 | 北京奇艺世纪科技有限公司 | Data association method and apparatus |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6847958B2 (en) * | 2000-10-14 | 2005-01-25 | Lg Electronics Inc. | Method of managing index data in main memory database |
| CN102110121A (en) * | 2009-12-24 | 2011-06-29 | 阿里巴巴集团控股有限公司 | Method and system for processing data |
| 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
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6847958B2 (en) * | 2000-10-14 | 2005-01-25 | Lg Electronics Inc. | Method of managing index data in main memory database |
| CN102110121A (en) * | 2009-12-24 | 2011-06-29 | 阿里巴巴集团控股有限公司 | Method and system for processing data |
| CN102184192A (en) * | 2011-04-19 | 2011-09-14 | 中兴通讯股份有限公司 | Data timing synchronization method and system |
Cited By (3)
| 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 |
| CN105045830A (en) * | 2015-06-30 | 2015-11-11 | 北京奇艺世纪科技有限公司 | Data association method and apparatus |
| CN105045830B (en) * | 2015-06-30 | 2018-08-07 | 北京奇艺世纪科技有限公司 | A kind of data correlation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102663045B (en) | 2013-11-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103699693B (en) | A kind of data quality management method based on metadata and system | |
| CN110292775B (en) | Method and device for acquiring difference data | |
| CN102479138A (en) | System and method for detecting error by utilizing image | |
| CN104820663A (en) | Method and device for discovering low performance structural query language (SQL) statements, and method and device for forecasting SQL statement performance | |
| CN105677332A (en) | Software developing requirement management system | |
| CN104268272A (en) | Method and device for checking uniqueness of data | |
| CN103984726A (en) | Local revision method for database execution plan | |
| CN102693460A (en) | Tester management system and method thereof | |
| JP2020057416A (en) | Method and device for processing data blocks in distributed database | |
| US20150227577A1 (en) | Method and device for guaranteeing consistency of planning data | |
| CN101673374A (en) | Bill processing method and device | |
| CN107464083B (en) | Method, device and equipment for generating bill of materials | |
| CN105488692A (en) | Method and device for computing number of online users | |
| CN102081644A (en) | Data storage method for storing data and data meanings separately | |
| CN103488695A (en) | Data synchronizing device and data synchronizing method | |
| CN106547584A (en) | A kind of backing method and device of application program | |
| CN102663045A (en) | Method and system for processing data information | |
| CN102393842A (en) | Command processing device and command processing method | |
| CN107071808B (en) | Neighbor cell checking method and device | |
| CN104462462A (en) | Service change frequency based data warehouse modeling method and device | |
| CN103838762A (en) | Uninterrupted data processing device and method based on data table rotation | |
| CN107451154B (en) | Data table processing method, device and system | |
| CN104750834A (en) | Rule storage method and matching method and device | |
| CN105373446B (en) | It is a kind of based on the system self-repairing method drilled automatically and device | |
| CN106776275A (en) | A kind of testing process automatic generation method based on Packet Multiplexing |
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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20131106 |