Method and system for comparing structural data
A structured data and data technology, applied in the computer field, can solve the problems of high resource occupancy, database server downtime, database server pressure, etc., to achieve low resource occupancy, reduce computing pressure, and simple and clear judgment methods Effect
Active Publication Date: 2014-03-26
BEIJING TEAMSUN TECH +1
View PDF5 Cites 19 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
The comparison results are accurate, but the sorting of data is handed over to the database, which puts a lot of pressure on the database server and high resource usage. When the amount of data to be compared is large, there is a risk of database server downtime.
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0047]In order to make the object, technical solution and advantages of the present invention more clear, the specific implementation manners of the method and system for comparing structured data in the embodiments of the present invention will be described below with reference to the accompanying drawings. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.
[0048] The method for comparing structured data in the embodiment of the present invention, such as figure 1 shown, including the following steps:
[0049] S100, using a sequenced hash distribution algorithm, using the row hash value of the data row of the database as the node value, and using the hash value of the row keyword of the data row as the node keyword, respectively constructing a standard database and a comparison database Standard-ordered hash tables and comparison-ordered hash tables. The standard database...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses a method and system for comparing structural data. The method for comparing the structural data comprises the following steps that the sequencing Hash distribution algorithm is adopted, line Hash values of data lines of databases are used as node values, the Hash value of a line keyword of each data line is used as a keyword of each node, and a standard sequencing Hash table of a standard database and a comparison sequencing Hash table of a comparison database are established respectively; the keywords of the nodes with data and the node values in the standard sequencing Hash table are connected into standard characters, the keywords of the nodes with data and the node values in the comparison sequencing Hash table are connected into comparison characters, and the standard Hash value of each standard character and the comparison Hash value of each comparison character are worked out; whether each standard Hash value is identical to the corresponding comparison Hash value or not is judged; if yes, the data in the standard database are identical to the data in the comparison database; if not, the data in the standard database are different from the data in the comparison database. By the adoption of the method and system for comparing the structural data, sorting work through a database server is not needed, the calculation pressure of the database server is reduced, the resource occupancy rate is low, efficiency is high, and the risk of breakdown of the server is avoided.
Description
technical field [0001] The invention relates to the field of computers, in particular to a method and system for comparing structured data. Background technique [0002] With the continuous improvement of IT construction in various industries in recent years, the gradual popularization of computer software and hardware integration solutions such as disaster recovery systems that guarantee user data integrity, and business continuity disaster recovery systems, the industry has gradually produced and clarified such a demand: for The data of the main and standby databases are compared daily and after synchronization to get a conclusion on whether they are consistent. If there are differences, accurately locate the data with differences. Therefore, whether data comparison is included in the disaster recovery solution has become one of the indicators of the maturity of the disaster recovery solution, and whether the data comparison can realize the precise location of difference d...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More IPC IPC(8): G06F17/30
CPCG06F16/2255
Inventor 蒋剑云王斌
Owner BEIJING TEAMSUN TECH