Use of temporary tables in development

1. In terms of data storage, we all use databases to store tables and data.

Scenario:

Some very complex calculations are implemented in the stored procedure. Some temporary data can be stored in the temporary table, and finally the summarized data is stored in the formal table.

Example:

Data Exchange Platform:

Import the raw data to the temporary table.

Verify the data in the temporary table according to the rules, and then enter the formal database.

Bi system:

After multidimensional modeling of the data analyzed by the topic, create a temporary table, summarize the data, create a temporary table, and store the summarized data.

The temporary tables in basic Bi can basically reach more than thousands of temporary tables.

The reason why Bi can perform multidimensional analysis is that it stores a set of metadata.

Use of temporary tables in development