Detection device and detection method for data reference relationship
A data reference and detection device technology, applied in special data processing applications, electrical digital data processing, instruments, etc., can solve problems such as unrealizable filtering and unrealizable, and achieve the effect of ensuring consistency and integrity
Active Publication Date: 2013-06-19
YONYOU NETWORK TECH CO LTD
View PDF4 Cites 14 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
And the data foreign key cannot realize the filtering of some records in the same table when checking, for example, when historical data or some specific data do not want to check the reference relationship, it cannot be realized
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
[0034] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other.
[0035] In the following description, many specific details are set forth in order to fully understand the present invention. However, the present invention can also be implemented in other ways different from those described here. Therefore, the protection scope of the present invention is not limited by the specific details disclosed below. EXAMPLE LIMITATIONS.
[0036] figure 1 A block diagram of a device for detecting a data reference relationship according to an embodiment of the present invention is shown.
[0037] Such as figure 1 As shown, the data r...
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 detection device for a data reference relationship. The detection device comprises a setting unit, a major key reference unit, an associated storage unit, a query unit, a judging unit and a display unit. The setting unit sets a major key for a data table. When data are referenced, the major key reference controls the major key of the reference data. The associated storage unit stores names of reference tables, names of referenced tables, names of columns of the data in the reference tables and names of major key columns in the referenced tables in an associated mode. The query unit inquires the name of a current data table, a name of a target data table of reference target data, a name of a target column, and a name of a column containing the major key. The judging unit judges whether the major key of the target data exists in the target column. If the major key of the target data exists in the target column, the display unit displays prompting information, the name of the target data table and the name of the target column. The invention further provides a detection method of the data reference relationship. Through the technical scheme, when the data are deleted, consistency and integrity of use of the data are ensured, and the specific reference relationship of the data is displayed.
Description
technical field [0001] The present invention relates to the technical field of data detection, in particular to a data reference relationship detection device and a data reference relationship detection method. Background technique [0002] The functions of the current information system are becoming more and more complex. With the expansion of functions, various business objects are increasing, which makes the relationship between business objects more and more complicated. At present, most information systems use relational databases to manage data. With the increase of functions, the number of table relationships and data records in the database is increasing sharply. The performance of the database directly affects the operating efficiency of the system. In the above cases, a certain method needs to be adopted to ensure the consistency and integrity of the data records. [0003] In most systems, there are two problems when deleting data. One is how to quickly check th...
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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 姜军
Owner YONYOU NETWORK TECH CO LTD