Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and device for filtering data table

A filtering method and data table technology, applied in the field of data processing, can solve problems such as low processing efficiency, achieve the effects of improving processing efficiency, solving low processing efficiency, and reducing the amount of data processing

Active Publication Date: 2019-11-12
BEIJING GRIDSUM TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present application provides a data table filtering method and device, so as to at least solve the technical problem that the data table is processed multiple times in the same dimension and the processing efficiency is low when filtering

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 and device for filtering data table
  • Method and device for filtering data table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0022] According to an embodiment of the present application, an embodiment of a data table filtering method is provided. It should be noted that the steps shown in the flow chart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and , although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0023] figure 1 is a flow chart of a data table filtering method according to an embodiment of the application, such as figure 1 As shown, the method includes the following steps:

[0024] Step S102, adding the obtained filter conditions to multiple sub-tables in the data table.

[0025] Step S104, find out the first sub-table that needs to be split among the multiple sub-tables, wherein the filter condition of the first sub-table is a filter condition for logic and operation on a dimension with multiple in...

Embodiment 2

[0075] According to another aspect of the embodiment of the present application, a data table filtering device is also provided, figure 2 It is a schematic diagram of a data table filtering device according to an embodiment of the application, and the device includes: an adding unit 10 , a searching unit 20 , a splitting unit 30 , a table connecting unit 40 and an acquiring unit 50 .

[0076] Wherein, the device includes: an adding unit 10, configured to add the acquired filter condition to multiple sub-tables in the data table.

[0077] The search unit 20 is used to find out the first sub-table that needs to be split among the multiple sub-tables, wherein the filter condition of the first sub-table is a filter condition for logically and operating the dimension with multiple indicators, and the multiple indexes of the same dimension There is a logic and relationship between indicators.

[0078] The splitting unit 30 is configured to split the first subtable into multiple sp...

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 present application discloses a data table filtering method and apparatus. The method comprises: adding obtained filtering conditions to a plurality of sub-tables in a data table; searching first to-be-divided sub-tables in the plurality of sub-tables; dividing the first sub-tables into a plurality of split tables; based on the filtering conditions of each split table, carrying out table connection on each split table corresponding to the same first sub-table to obtain a connection result of each first sub-table; and based on the connection result of each first sub-table, obtaining a first filtering result of the data table corresponding to the obtained filtering conditions. The method and the apparatus disclosed by the present application solve the technical problems that multiple filtering in the same dimension is carried out on the data table and processing efficiency is low during filtering.

Description

technical field [0001] The present application relates to the field of data processing, in particular, to a data table filtering method and device. Background technique [0002] The data in the data table is generally a many-to-many relationship. Among them, the many-to-one relationship is the more common one. Since e-commerce and sessions are many-to-one relationships, multiple orders may be purchased in one session. An order contains a variety of products, so there will be a dimension chain that is performed multiple times for the same product dimension and filtered. In the existing technology, if the same dimension is filtered multiple times, the data table is generally filtered directly using the filter condition, which will result in a large amount of filtered data in the data table, which makes the table filtering costly. , the efficiency is low. [0003] No effective solution has been proposed yet for the above-mentioned problem of low processing efficiency in filte...

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/242G06F16/2455
CPCG06F16/2428G06F16/24568
Inventor 洪超何恺铎黄健
Owner BEIJING GRIDSUM TECH CO LTD