Check patentability & draft patents in minutes with Patsnap Eureka AI!

Data filtering method and device

A filtering method and filtering device technology, applied in the direction of electrical digital data processing, digital data information retrieval, special data processing applications, etc., can solve the problems of low filtering efficiency and high system performance overhead, and achieve the effect of improving filtering efficiency

Active Publication Date: 2020-11-06
BEIJING GRIDSUM TECH CO LTD
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The main purpose of this application is to provide a data filtering method and device to solve the problem of high system performance overhead and low filtering efficiency in related technologies when querying index data

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 filtering method and device
  • Data filtering method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] It should be noted that the embodiments in the present application and the features of the embodiments may be combined with each other in the case of no conflict. The present application will be described in detail below with reference to the accompanying drawings and in conjunction with the embodiments.

[0020] In order to make those skilled in the art better understand the solutions of the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only The embodiments are part of the present application, but not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the scope of protection of the present application.

[0021] It s...

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 filtering method and device. The method comprises the following steps that: receiving a filtering request, wherein the filtering request carries a filtering condition, wherein the filtering condition comprises a first filtering condition and a second filtering condition, the first filtering condition is used for carrying out filtering in an original data table, and the second filtering condition is used for carrying out filtering in a non-original data table; according to the filtering condition, filtering the original data table; carrying out duplication removalprocessing on the filtered original data table to obtain a temporary table; and according to the second filtering condition, filtering the temporary table. Through the method, the problem in the relevant art that filtering efficiency is low since system performance expenditures are high when index data is inquired can be solved.

Description

technical field [0001] The present application relates to the field of data filtering, and in particular, to a data filtering method and device. Background technique [0002] For data like the order table, there will be many changes in the order status, and each order status change will record a status data in the system, so an order has multiple records. When querying indicators such as order volume, the same order ID only needs to be calculated once, so multiple records of an order need to be deduplicated. In order to perform de-duplication processing, the method adopted in the related art is: add a de-duplication view to the order table, and perform query directly in the de-duplication view when querying. For example, when querying a view, first deduplicate all order data, and then use time to filter. With more and more historical data, the performance overhead of deduplication for the entire order volume data will also increase. Larger and larger, resulting in lower fi...

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): G06F16/215G06F16/2453
CPCG06F16/215G06F16/2453
Inventor 洪超
Owner BEIJING GRIDSUM TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More