Data storage method and device, computer equipment and storage medium

Abstract

The invention relates to a data storage method and device, computer equipment and a storage medium. The method comprises the steps of generating a date data item relationship list of each service identifier according to historical data, wherein the date data item relationship list records a corresponding relationship between data dates of data and data item identifiers; generating a data item content list of each service identifier according to the historical data, wherein the data item content list records a corresponding relationship between the data item identifier and the data content; andgenerating a data limit storage table, wherein the data limit storage table comprises each service identifier, and a date data item relationship list and a data item content list corresponding to each service identifier. The development difficulty can be reduced while storage resources are reduced.

Description

technical field

[0001] The present application relates to the technical field of data warehouses, in particular to a data storage method, device, computer equipment and storage medium. Background technique

[0002] A data warehouse is a subject-oriented, integrated, relatively stable data collection that reflects historical changes. In the data warehouse, there are some business data changes that account for a small proportion of the overall volume (such as members, organizations, employees, etc.), and each use in the data analysis process requires a full traversal of the current date or the full data status of the specified date. Usually, the data warehouse The methods used are periodic snapshot tables or slow-changing dimension solutions, but these two methods have the following disadvantages:

[0003] The first method is a periodic snapshot table, which stores a copy of the current full amount of data every cycle; the implementation is simple, and the small amount of dat...

Images