Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method, system and database terminal for mining approximate dictionary rules in database

A database and rule technology, applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as low efficiency, poor performance, and inability to meet the needs of big data analysis and processing.

Active Publication Date: 2016-08-31
SHENZHEN AUDAQUE DATA TECH
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The purpose of the present invention is to provide a mining method for approximate dictionary rules in a database, aiming to solve the problem that the previous mining methods have poor performance and low efficiency, so that they cannot meet the needs of big data analysis and processing

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
  • Method, system and database terminal for mining approximate dictionary rules in database
  • Method, system and database terminal for mining approximate dictionary rules in database
  • Method, system and database terminal for mining approximate dictionary rules in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0111] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0112] Related concepts

[0113] Consider the database r, define the set of all columns in r as R, and the different values ​​in each column are called items (item), and the set of all items is defined as item set I; each row of r is called transaction t (transaction),

[0114] (1) Support: For a given itemset Define its support degree supp(X) as the number of transactions containing item set X in r, which satisfies number of transactions.

[0115] (2) Superset, subset: For two itemsets X, Y, if satisfy Then it is said that Y is a superset of X, X is a subset of Y, and there is supp(Y)<=su...

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 is applicable to the field of approximate dictionary rule excavation, and provides a method and a system for excavating an approximate dictionary rule of a database, and a database terminal. The method for excavating the approximate dictionary rule comprises the following steps: scanning and analyzing a database r, getting rid of single value columns, and columns in which all values are unique, and marking a remaining candidate column set as R; counting the support degree of each item in each column in the candidate column set R, and ending an item of which the support degree is greater than a given minimum support degree with an integer; numbering events in each row in the database r sequentially, recording the row event number of each item with a list, and caching; excavating the approximate dictionary rule of the database r by an LCfd (large Chinese face database) method; outputting the approximate dictionary rule. By applying the approximate dictionary rule excavating method of the LCfd to the database and through a reversely increasing search strategy, a search tree is pruned by a pruning method and a rule which has been found is cached, so that the computing amount of the whole excavating method can be reduced and the approximate dictionary rule in the database can be automatically and efficiently found out.

Description

technical field [0001] The invention relates to the field of mining approximate dictionary rules, in particular to a method, system and database terminal for mining approximate dictionary rules in a database. Background technique [0002] With the rapid development of the Internet and the improvement of informatization in various fields of society, the amount of data is blowing out at an unprecedented rate, and human beings are entering the era of big data. The era of big data is characterized by a larger amount of data, more complex data sources, faster data updates, and uneven data quality. It is almost impossible to manage data quality only by manual means. The field of data management is undergoing major changes and breakthroughs. The technologies that have been commercialized basically stay in the second-generation data quality management stage that is manual and based on experience. didn't show up. An important part of the automated management system is the automated...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 王明兴贾西贝
Owner SHENZHEN AUDAQUE DATA TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products