Database table-level comparison method and system based on data dictionary and variable rules
A data dictionary and comparison system technology, applied in the field of database processing, can solve the problems of relying on the professional level of users, prone to errors, slow processing speed, etc., to achieve the effect of fast processing speed, accurate comparison results, and improved work efficiency
Active Publication Date: 2016-09-28
CHINA UNIONPAY
View PDF3 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
When the amount of data is large, the processing speed of this method of manual comparison after obtaining data is too slow and error-prone
Moreover, this method depends to a large extent on the professional level of the user
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
[0020] The following introduces some of the possible embodiments of the present invention, which are intended to provide a basic understanding of the present invention, but are not intended to identify key or decisive elements of the present invention or limit the scope of protection. It is easy to understand that, according to the technical solution of the present invention, those skilled in the art may propose other alternative implementation manners without changing the essence and spirit of the present invention. Therefore, the following specific embodiments and drawings are only exemplary descriptions of the technical solution of the present invention, and should not be regarded as the entirety of the present invention or as a limitation or restriction on the technical solution of the present invention.
[0021] The database system is a complex system, which contains a lot of non-user data besides user data. For example, the contents of schemas and sub-schemas, the links ...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention provides a method used for comparing database table levels and based on a data dictionary and variable rules. The method includes the steps of determining comparison relations of the database table levels, determining a source table set and a target table set which are to be compared, analyzing the comparison relations of the database table levels through a mapping relation refactoring engine, and comparing the source table set and the target table set according to the analyzed comparison relations of the database table levels. In a specific implementation process, the method used for comparing the database table levels and based on the data dictionary and the variable rules further includes the step of normalizing comparison results, so that a corresponding comparison report can be generated and displayed. The invention further provides a system used for comparing the database table levels and based on the data dictionary and the variable rules.
Description
technical field [0001] This application relates to the field of database processing. More specifically, the present application relates to database table-level comparison methods and systems based on data dictionaries and variable rules. Background technique [0002] A database is a warehouse that organizes, stores and manages data according to its data structure. In the daily life of economic management, it is often necessary to put some relevant data into such a "warehouse" and perform corresponding processing according to the needs of management. For example, the personnel departments of enterprises and institutions often need to store the basic information of the employees of the unit (employee number, name, age, gender, place of origin, salary, resume, etc.) in a table, and this table can be regarded as a database. With this "data warehouse", people can query the basic situation of a certain employee at any time according to their needs, and can also query the number ...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 马军吴金坛吕苏尹祥龙李岭
Owner CHINA UNIONPAY