Agile data warehouse architecture and construction method and application thereof

Abstract

The invention relates to the technical field of data warehouses, in particular to an agile data warehouse architecture and a construction method and application thereof. The agile data warehouse architecture comprises a data source, a storage layer, a data warehouse, an analysis tool and an application layer, the data warehouse mainly comprises a data warehouse model and a data warehouse tool, the data warehouse model is used for solving the problem that data is available, and the data warehouse tool is used for solving the problem that data is easy to use. According to the architecture designed by the invention, data from different sources are reconciled, so that the data aperture consistency is realized, and the meaning and the correctness of the data are clarified; according to the construction method, concept analysis, logic design and physical implementation are closely combined, a data storage and management mode is reasonably designed, data are recombined, the process of data warehouse quality control is enhanced and optimized, and the practicability of the data warehouse is improved; the application can provide efficient and detailed data, is suitable for a large number of application scenes and users, meets data requirements of different levels, and can adapt to the continuous changing process of business and products of enterprises.

Description

technical field [0001] The invention relates to the technical field of data warehouses, in particular to an agile data warehouse architecture and its construction method and application. Background technique [0002] A data warehouse is a strategic collection that supports all types of data for decision-making processes at all levels of an enterprise. The data warehouse not only contains the data required for analysis, but also contains the applications required to process the data. These programs include applications that transfer data from external media to the data warehouse, and also analyze and present the data to users. s application. Data warehouse has five basic characteristics of subject-oriented, integrated, stable, changing with time and supporting management decision-making. With the rapid development of the Internet, the business and products of enterprises are also undergoing continuous rapid development. How the data warehouse adapts to changes has become on...

AI Technical Summary

Problems solved by technology

With the rapid development of the Internet, the business and products of enterprises are also undergoing continuous rapid development. How the data warehouse adapts to changes has become one of the problems restricting development; decision makers pursue refined operations and require the data warehouse to provide efficient details The ability of data, how to meet the data requirements of different levels in the data warehouse restricts the development of the second problem; after the data passes through ETL, it finally reaches the hands of the data users, and the requirements for extracting and proposing data often come from different departments and for different reasons. The purpose will lead to inconsistent data caliber, ambiguous data meaning, and even difficult to verify the correctness of data. How to ensure the consistency of data caliber and traceability of data paths in the data warehouse has become the third problem restricting development

However, there is no agile data warehouse architecture, construction method and application in the prior art that can solve the above problems

Images