Data relationship mining method and device based on Mysql database logs

A data relationship and mining device technology, applied in relational databases, database models, structured data retrieval, etc., can solve problems such as dependence on personnel, difficulty in data value, and large labor costs, so as to reduce costs, increase objectivity, and correctness Effect

Pending Publication Date: 2020-12-25
南京数云信息科技有限公司
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the reality is that how to mine data value is a difficult problem
Especially in the automatic data relationship discovery, data quality assessment is often implemented by manual intervention, which results in a lot of labor costs and relies heavily on the basic skills of personnel

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data relationship mining method and device based on Mysql database logs
  • Data relationship mining method and device based on Mysql database logs

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0022] see figure 1 and figure 2 , the present invention provides a technical solution:

[0023] A data relationship mining method based on Mysql database logs, such as figure 1 shown, including the following steps:

[0024] S1: Obtain and store the relational data of the Mysql database.

[0025] S2: Obtain and cache data operation logs based on relational data. Among them, it is necessary to ensure that the data source Mysql enables the data log functio...

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

No PUM Login to view more

Abstract

The invention discloses a data relationship mining method and device based on a Mysql database log. The method comprises the following steps: obtaining and storing relational data of a Mysql database;acquiring and caching a data operation log according to the relational data; reading the data operation log, and constructing a data knowledge network graph; establishing a data topic map according to the data knowledge network map; and displaying the data topic map and mining a data relationship. According to the invention, the learning model is established in an artificial intelligence mode byanalyzing the operation log of the Mysql data, and the data relationship is automatically analyzed and the data value is mined through the daily operation of the informatization system; the uncertainty caused by manual analysis is liberated to a certain extent, and the resource cost is reduced. In addition, the invention is non-inductive and transparent to business personnel; through automatic analysis of machine learning, the relationship of data subjects can be clearly analyzed for business personnel, and the business personnel can be helped to quickly construct a data knowledge graph.

Description

technical field [0001] The invention relates to the technical field of data relationship mining, in particular to a data relationship mining method and device based on Mysql database logs. Background technique [0002] After decades of informatization construction, all walks of life have accumulated a large amount of data base. With the rise of big data and artificial intelligence, more and more enterprises begin to pay attention to the value of data. However, the reality is that how to mine data value is a difficult problem. Especially in automatic data relationship discovery, data quality assessment is currently often implemented by manual intervention, which results in a large amount of labor costs and relies heavily on the basic skills of personnel. [0003] To this end, a data relationship mining method and device based on Mysql database logs are proposed. Contents of the invention [0004] The purpose of the present invention is to provide a data relationship mini...

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
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/2458G06F16/242G06F16/28G06F16/36G06F16/18
CPCG06F16/1815G06F16/2433G06F16/2465G06F16/284G06F16/367
Inventor 宋航成季帮国
Owner 南京数云信息科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap