Hierarchical construction method and device of data warehouse, electronic equipment and storage medium
A technology of data warehouse and construction method, applied in the direction of database model, hierarchical database, multi-dimensional database, etc., can solve the logical model of government data warehouse that cannot well support data processing at different levels, cannot uniformly meet the needs of each layer, and Problems such as confusion in the construction process
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0030] figure 1 The first schematic flow diagram of a layered construction method of a data warehouse provided by Embodiment 1 of the present application. This embodiment can be applied to the modeling of data warehouses, and can also be applied to the processing of government affairs by functional departments. when dealing with business. A data warehouse hierarchical construction method provided in this embodiment can be executed by the data warehouse hierarchical construction device provided in the embodiment of the present application. The device can be realized by software and / or hardware, and integrated when executing this method in electronic equipment.
[0031] see figure 1 , the method of this embodiment includes but not limited to the following steps:
[0032] S110. Obtain the original data of each database to be collected, and use relational modeling on the original data to obtain a collection database.
[0033] Wherein, the database to be collected refers to the...
Embodiment 2
[0047] Figure 2A It is a second schematic flowchart of a hierarchical construction method for a data warehouse provided in Embodiment 2 of the present application; Figure 2B A schematic diagram of adding system fields in a layered construction method of a data warehouse provided in Embodiment 2 of the present application; Figure 2C It is a schematic diagram of associated data in a hierarchical construction method of a data warehouse provided in Embodiment 2 of the present application. The embodiment of the present application is optimized on the basis of the above embodiments, and the specific optimization is as follows: a detailed explanation of the construction process of the collection library and the standard library is added.
[0048] see Figure 2A , the method of this embodiment includes but not limited to the following steps:
[0049] S210. Acquire raw data of each database to be collected.
[0050] S220. Using the method of adding from the source table, add sys...
Embodiment 3
[0064] image 3 A schematic structural diagram of a hierarchical construction device for a data warehouse provided in the embodiment of this application, as shown in image 3 As shown, the device 300 may include:
[0065] The imputation library construction module 310 is used to obtain the original data of each database to be collected, and use relational modeling on the original data to obtain the imputation library; wherein, the data table structure in the imputation library is consistent with the original data The data table structure is the same;
[0066] A standard library construction module 320, used for standardizing the data in the collection library, and performing relational modeling on the processed data to obtain a standard library;
[0067] The target library construction module 330 is used to perform labeling processing on the data in the standard library to obtain the attribute label table, statistical label table and algorithm label table, and construct base...
PUM
Login to View More Abstract
Description
Claims
Application Information
Login to View More