Data query anomaly detection method, device, equipment and system

A data query and anomaly detection technology, applied in the Internet field, can solve problems such as large amount of data, failure to meet the query conditions, and reduce the efficiency of data anomaly detection, so as to achieve the effect of improving efficiency

Active Publication Date: 2018-03-09
CAINIAO SMART LOGISTICS HLDG LTD
View PDF6 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, when there is a problem with the SQL query statement itself, it will result in an abnormally large or small amount of queried data, and the queried results do not meet the query conditions. When this situation occurs, the existing technology can only Check the SQL code in a way, which reduces the efficiency of data volume anomaly detection

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 query anomaly detection method, device, equipment and system
  • Data query anomaly detection method, device, equipment and system
  • Data query anomaly detection method, device, equipment and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] Exemplary embodiments will be described in detail herein, examples of which are illustrated in the accompanying drawings. Where the following description refers to the drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the illustrative examples below are not intended to represent all implementations consistent with the present invention. Rather, they are merely examples of apparatus and methods consistent with some aspects of the invention as recited in the appended claims.

[0034] In the prior art, the select statement of SQL can be used to select data from a data table. It is assumed that the database of a certain shopping website stores a data table of member ID, member name, and registration time, and the data table is shown in Table 1 below:

[0035] Table 1

[0036]

[0037]

[0038] Through the corresponding select statement, the member ID and member name wh...

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 provides a data query anomaly detection method, device, equipment and system. The method comprises the steps of obtaining a data query instruction, wherein the data query instruction isused for inquiring a data table; determining whether a correlation condition exists in the data query instruction or not, wherein the correlation condition is used for being correlated to the data table; if the data query instruction comprises the correlation condition, determining whether a query result corresponding to the data query instruction is abnormal or not according to the correlation condition. By means of the data query anomaly detection method, device, equipment and system, by obtaining the data query instruction like the correlation condition in an SQL, according to the correlation condition, whether the query result of the SQL can possibly be abnormal or not is predicted, early warning is conducted for a data developer to modify the SQL in advance, and therefore the efficiency of data amount anomaly detection is improved.

Description

technical field [0001] The present application relates to Internet technology, and in particular, to a method, device, device and system for detecting abnormality in data query. Background technique [0002] Structured Query Language (SQL) is a database query and programming language used to access data and query, update and manage databases. [0003] A large number of data tables are stored in the database. Through SQL query statements, data tables with a certain relationship can be queried. Taking shopping web pages as an example, a large number of users log in to shopping web pages every day, browse the products in the shopping web pages, click to buy products, and then Commenting on the purchased products on the shopping page will generate a large number of data tables, and these large data tables are stored in the database. For example, the database stores the user ID number and user nickname. And the data table B of the user transaction amount, the data table C of the...

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): G06F17/30
CPCG06F16/2433
Inventor 蔡聪
Owner CAINIAO SMART LOGISTICS HLDG LTD
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