A method, device and equipment for evaluating the consistency of primary and foreign keys in big data
An evaluation method and primary and foreign key technology, applied in the field of computer data processing, can solve problems such as difficult data governance work effectiveness, quantitative evaluation, and difficult maintenance, and achieve the goals of improving detection efficiency and accuracy, wide applicability, and reducing workload Effect
Active Publication Date: 2021-07-30
沈阳京华博瑞科技有限公司
View PDF0 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Due to the absence of primary and foreign key relationships, data governance staff cannot obtain the association relationship between tables, and can only obtain the association relationship through communication with developers and business sorting
Such an approach is extremely inefficient, difficult to maintain as data grows, and difficult to quantify the effectiveness of data governance efforts
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
[0045] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.
[0046] In addition, the term "and / or" in this article is only an association relationship describing associated objects, which means that there may be three relationships, for example, A and / or B, which may mean: A exists alone, A and B exist at the same time, There are three cases of B alone. In addition, the character " / " in this article genera...
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 present invention provides a big data primary and foreign key consistency evaluation method, device and equipment. The method includes reading data table information and field information in the data table from the database, and judging the attributes of each field; selecting a target data table, and selecting a comparison data table from other data tables; The primary and foreign key relationship evaluation is performed on the target data table and the comparison data table. In this way, it is possible to predict the relationship between fields, filter out fields that obviously cannot have primary and foreign key relationships, greatly reduce the workload of content comparison between fields, and quickly and efficiently detect missing primary and foreign key relationships. Improve detection efficiency and accuracy, and has wide applicability.
Description
technical field [0001] Embodiments of the present invention generally relate to the field of computer data processing, and more specifically, relate to a method, device and equipment for evaluating the consistency of primary and foreign keys in big data Background technique [0002] With the continuous improvement of the informatization level of my country's power industry and the continuous popularization of Internet applications, the amount of data that needs to be stored and processed in the power business system is increasing exponentially. In order to improve system response speed and development efficiency, more and more developers choose to ignore primary and foreign key constraints in relational databases. This makes it impossible for the same data in different tables to be synchronized in a timely and accurate manner, and the data quality is significantly reduced, which cannot support enterprise-level big data analysis and application. Enterprises have to spend a l...
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): G06F16/22G06F16/28G06Q50/06
CPCG06Q50/06G06F16/2282G06F16/284
Inventor 许博
Owner 沈阳京华博瑞科技有限公司