Data warehouse information processing method, device, system, medium

Abstract

The present disclosure provides a data warehouse information processing method, the data warehouse includes a plurality of associatively stored history tables, the method includes: obtaining at leastone history query statement, the history query statement is used for querying related data of a plurality of history tables in the associatively stored history tables; the history query statement is used for querying related data of the history tables in the associatively stored history tables. Determining a plurality of history tables corresponding to the at least one history query statement; Generating a target table based on a particular one of the plurality of history tables, the target table including relevant data in the particular history table.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and more specifically, to a data warehouse information processing method, a data warehouse information processing device, a data warehouse information processing system, and a computer-readable storage medium. Background technique [0002] As the Internet enters the era of big data, data collection and storage are key research directions. For example, relevant data of various business scenarios are stored in data warehouses, and it is usually necessary to query relevant data from a large amount of data stored in data warehouses, and Perform integrated analysis to make business decisions. The data in the data warehouse is usually stored in the form of tables, and different tables store different data. For example, different tables store user data, product data, merchant data, etc., in When it is necessary to query related sales data, it is necessary to obtain relevant data from multiple...

AI Technical Summary

Problems solved by technology

[0002] As the Internet enters the era of big data, data collection and storage are key research directions. For example, relevant data of various business scenarios are stored in data warehouses, and it is usually necessary to query relevant data from a large amount of data stored in data warehouses, and Perform integrated analysis to make business decisions. The data in the data warehouse is usually stored in the form of tables, and different tables store different data. For example, different tables store user data, product data, merchant data, etc., in When it is necessary to query related sales data, it is necessary to obtain relevant data from multiple tables, which makes the query process cumbersome. Therefore, in the field of data warehouses, business personnel usually construct a database containing related data in multiple tables based on multiple tables. Wide tables, which can facilitate the query of required data, therefore, how to optimize the construction process of wide tables has become an urgent problem to be solved

[0003] In the process of realizing the concept of the present disclosure, the inventors found that there are at least the following problems in the prior art. The existing wide table construction process relies too much on the experience of business experts, so that the construction of wide tables requires a lot of manual participation, and due to excessive reliance on manual Participation makes the wide table construction process less objective

Images