Exception determination method and apparatus

A technology for determining methods and devices, which is applied in the computer field, can solve problems such as processing process errors, and achieve the effect of improving efficiency

Inactive Publication Date: 2016-08-17
LETV INFORMATION TECH BEIJING
View PDF7 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In practical applications, because ETL (Extract Transform Load, data warehouse technology) process often has some abnormal behaviors, it may cause some abnormal data to be stored in the data warehouse, which may lead to all operations based on these abnormal data Errors occur in the processing flow, in order to avoid this situation, an efficient and high-quality analysis and monitoring mechanism is required

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
  • Exception determination method and apparatus
  • Exception determination method and apparatus
  • Exception determination method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary examples do not represent all implementations consistent with the present invention. Rather, they are merely examples of apparatuses and methods consistent with aspects of the invention as recited in the appended claims.

[0057] Such as figure 1 As shown, in one embodiment of the present disclosure, a method for determining an abnormality is provided, including the following steps.

[0058] In step S101, the original reporting data stored in the data warehouse and the URL address corresponding to each original reporting data are obtained.

[0059] In the embodiment of the present disclosure, the original report...

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

Embodiments of the invention provide an exception determination method and apparatus. The method comprises the steps of obtaining original reported data stored in a data warehouse and URL addresses corresponding to the original reported data; making statistics on the number of the original reported data corresponding to the URL addresses; searching for URL addresses with a data number beyond a preset threshold range; and determining original reported data corresponding to the found URL addresses as exceptional data. According to the method and apparatus, whether the original reported data corresponding to the URL addresses are exceptional or not is determined by searching for the original reported data corresponding to the URL addresses with the data number beyond the preset threshold range, so that the data exception can be detected from the source and the efficiency of locating data exception reasons can be improved.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and in particular to a method and device for determining abnormality. Background technique [0002] The data warehouse is a subject-oriented and integrated data collection in enterprise management and decision-making, that is to say, for all application systems, such as customer relationship management systems, financial systems, etc., it is integrated according to the subject and records the entire historical change. It is a single data store created for analytical reporting and decision support purposes, providing business intelligence to guide business process improvement, monitor time, cost, quality, and control for businesses that require business intelligence. [0003] In practical applications, because ETL (Extract Transform Load, data warehouse technology) process often has some abnormal behaviors, it may cause some abnormal data to be stored in the data warehouse, which may le...

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): G06F11/07G06F17/30
CPCG06F11/0772G06F16/254
Inventor 许鹭清
Owner LETV INFORMATION TECH BEIJING
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