Dimension data storing method, device and system

Abstract

The invention discloses a dimension data storing method. The method comprises the steps of acquiring new dimension data produced as a terminal runs; determining the new dimension data meet the storage condition according to the preset dimension strategy, wherein the dimension strategy is the strategy for determining whether the dimension data meet the storage condition; if so, adding the new dimension data to a dimension data sequence to store. According to the method, the data meeting the storage conditions can be stored only, so that the storage quantity of the time sequence data can be decreased, and the storage redundancy can be reduced.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a method, device and system for storing dimensional data. Background technique [0002] On-Line Analysis Processing (OLAP) services of databases often involve time-series operations for specific data, such as user behavior analysis based on user traffic summarization within a certain period of time in the telecommunications field. In order to support this type of operation, a large amount of time-series data needs to be stored. Time-series data is data that is strongly time-related, such as the user's remaining amount, consumed traffic or remaining traffic. In the telecommunications field, it involves more time-series data, and in other fields it may also involve spatial data, frequency data, etc. We refer to these time, space, count, frequency, or data in a certain field of the user table as dimensional data. [0003] In the database in the prior art, a special dimens...

AI Technical Summary

Problems solved by technology

The addition of dimension data is performed in units of rows in the Temporal table. Whether updating one column or multiple columns, a complete row of records needs to be added to the dimension table, resulting in the storage of a large amount of redundant data.

Images