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

A data warehouse counting table processing method and device

A table processing and processor technology, applied in the field of data warehouse table processing methods and devices, can solve problems such as slow execution speed and small resources, and achieve the effects of improving connection query efficiency and saving connection query time.

Pending Publication Date: 2019-04-09
ADVANCED NEW TECH CO LTD
View PDF7 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In this case, the connection query process consumes a lot of resources and executes slowly

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
  • A data warehouse counting table processing method and device
  • A data warehouse counting table processing method and device
  • A data warehouse counting table processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] 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 this specification. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present specification as recited in the appended claims.

[0025] The terms used in this specification are for the purpose of describing particular embodiments only, and are not intended to limit the specification. As used in this specification and the appended claims, the singular forms "a", "the", and "the" are intended to include the plural forms as well, unless the context clearly dictates otherwise. It should also be understood that the t...

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 embodiment of the invention provides a data warehouse counting table processing method and device. The method includes: filtering a second table segment corresponding to the first table segment inthe second data warehouse table by adopting the Bloom index of the first table segment in the first data warehouse table. The table data which are not matched with the table data in the first warehouse counting table can be effectively filtered out from the second warehouse counting table before the connection query is carried out, so that the connection query efficiency of the first warehouse counting table and the second warehouse counting table is improved, and the connection query time is saved.

Description

technical field [0001] This specification relates to the technical field of data processing, and in particular to a data warehouse table processing method and device. Background technique [0002] In the process of offline data cleaning, it is often faced with the situation that one data warehouse table is connected to query another data warehouse table. For ease of representation, the data warehouse table serving as the basis of the connection query may be called the first data warehouse table, and the data warehouse table to be queried by the connection may be called the second data warehouse table. In many cases, there are many table data in the data warehouse table, and the table data in a data warehouse table can often reach hundreds of millions, or even billions of data. In this case, the connection query process consumes a lot of resources and executes slowly. Therefore, it is necessary to improve the connection query process of the data warehouse table. Contents ...

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): G06F16/22G06F16/2455
Inventor 杨浩
Owner ADVANCED NEW TECH CO LTD