The data warehouse is the foundation of the bank management system, which bears the data sharing and exchange at the database level between the banking system and the management application system. According to different data modeling methods and data integration methods, the basic data platform can be divided into two parts: the post source data platform and the integrated computing platform. The integrated computing platform focuses on the platform with high degree of data integration, and the post source data platform focuses on the post source data integration platform.

Data warehouse carries the function of one-time storage and multiple reuses of business data in enterprises. It integrates business data from a business perspective and stores long-term business historical data. It is an important data source for subsequent enterprises to carry out data analysis and business decision-making.

The overall solution of GienTech Data Warehouse is based on the hybrid architecture, and combines with big data technology on the basis of making full use of the experience of traditional data platform construction, which can create one-stop data collection and access, data integration and analysis, data application and services, and assist in digital transformation for enterprises.

• data warehouse specifications and processes are inconsistent, and cross-departmental cooperation is difficult (modeling specifications and development specifications).
• Inconsistent indicator caliber leads to the decrease of data reliability (data dictionary).
• data expansion leads to the shortage of computing resources, and the timing cannot be guaranteed (modeling specifications and development specifications, data products and services).
• Long troubleshooting and repair time (metadata and data quality management).
• untimely response to business requirements (self-service data retrieval +OLAP system, data products and services).

• ODS platform is responsible for supporting the data storage of post source storage layer and providing external data services.
• The data warehouse platform is responsible for supporting the model storage and data service of theme model layer, common processing layer and business capability layer. Meet the data storage and services required by active data exploration and model laboratory;
• The real-time decision-making area meets the function construction of acquiring data based on bus and making real-time decision analysis based on memory database.
• The big data processing area meets the construction of semi-structured and unstructured data processing functions based on batch and real-time streaming data.
• The historical data storage area satisfies data archiving and supports historical data access.
• The report query platform satisfies the construction of unified report platform, management cockpit and other application functions mainly based on report query.
• The application service platform meets the application tool product deployment platform of proprietary computing and display engines.
• The active exploration platform meets the functional construction of active data exploration service for business users based on data warehouse.
• The data mining platform meets the requirements of mining model construction, verification, monitoring and model management to support in-depth decision-making.
• The unified acquisition/exchange/scheduling platform meets the unified non-real-time data acquisition and data exchange functions of the whole bank; meets the unified job scheduling processing.
• Data management of data warehouse relies on the data management platform to deploy data management functions related to data warehouse.
• The security management of the data warehouse relies on the unified operation and maintenance monitoring platform within the bank and the software and hardware functions related to the data warehouse to realize the warehouse security management.
• The data warehouse portal meets the integration of multiple application modes and functions for various users based on the integrated data area.