As the largest policy bank in China, xx state-owned commercial bank provides financial guarantee to key national construction projects, and undertakes important functions of macroeconomic regulation and control. Its business is quite different from that of commercial banks. How to design the model to suit the characteristics of xx state-owned commercial bank is a great challenge. And this is also the first enterprise-level data warehouse data model of xx state-owned commercial bank. Without reference and comparison, it is necessary to consider more possibilities and dig deep into the existing business of xx state-owned commercial bank.

In 2012, the first phase of the Data Warehouse of xx state-owned commercial bank was launched, and the first phase of the construction project completed the investigation of 12 source systems, including core, full-process credit, small and medium-sized credit, national settlement and general ledger, and designed the first enterprise-level data warehouse model of xx state-owned commercial bank, including the basic layer and summary layer, in which the basic layer includes eight topics: parties, agreements, internal institutions, events, addresses, assets, finance and products. The summary layer includes ten business themes such as deposit, loan and capital transaction, and supports the theme applications such as unified report, risk management, regulatory submission and executive cockpit. The first phase completes the addition of key points in 2010, 2011 and 2012, and ensures the centralized sharing and effective connection of warehouse data in time series through data migration and cleaning, thus forming comprehensive, authoritative and standardized data assets. The first phase of the data warehouse was successfully launched in October 2012. There are 12 warehousing source systems and 696 warehousing source tables in Phase I, involving 8 basic layer topics, 347 entities and 4791 fields, 12 summary layer topics, 28 entities and 1033 fields. Specific solutions are as follows.
Overall system architecture design:
According to the actual situation of data warehouse system construction of xx state-owned commercial bank, the whole system is designed as a multi-layer and extensible framework. The core of the architecture includes data source, integrated data area (post source model layer, theme model layer, common processing layer and business capability layer), and application service area (service layer, application layer and user access layer). In addition, data warehouse data management (data warehouse data quality management, data warehouse metadata management, data warehouse data life cycle management) and data warehouse security management are also essential parts of the system, which will involve all core levels.
The following figure include in this solution

1. Data management of data warehouse
Definition: Relying on the data management platform, deploy data warehouse related data management functions;
Job description: The data quality management of the data warehouse is engaged in the pre, in-process and post process of checking the data quality of various business and technical dimensions for each data level in the data warehouse. Track and analyze the verification results, track and solve the data quality problems found in the data warehouse, and form the data quality report in the data warehouse; Metadata management of data warehouse, with the support of metadata management tools of xx state-owned commercial bank, regularly collects and maintains business and technical metadata in the data warehouse platform and its external interfaces, etc., to ensure the accuracy and consistency of metadata of each node in the data flow direction, ensure smooth data veins in the data warehouse platform, and support the influence and blood relationship analysis functions of the data warehouse platform; Data warehouse life cycle management, analyze each platform, define the principles of its data life cycle, and put forward requirements.
2. Safety management of data warehouse
Definition: Realize warehouse safety management by relying on the unified operation and maintenance monitoring platform in the bank and related software and hardware functions of data warehouse;
Job description: Data warehouse security management includes data security, data storage security, database operation authority management, data backup strategy, desensitization of information content, data encryption, data integrity, non-repudiation, etc. ;application security, user identity authentication, authorization, key security, etc; system security, operating system security, software legitimacy authorization, anti-virus, program and application backup, etc.; network security, access control, vulnerability monitoring, intrusion detection, content filtering, etc.; link security, physical layer security control of network transmission, etc. ; physical security, hardware equipment, environmental security, disaster recovery and backup, etc.; scientific safety management system and regulations.
3. Data source area.
The data source system includes the main business systems of xx state-owned commercial bank at present, and needs to meet the data requirements of the theme application of data warehouse in this phase, mainly including but not limited to the following systems:
•Core system
•Fund system
•General ledger system
•Financial sharing system
• Rater system
•Full process credit system
• Customer relationship management system
• Hong Kong core system
• Domestic factoring system
• Student Loan System (University)
• Student loan system (place of origin)
• Unified authorization system
• Small and medium-sized enterprise system
• Online banking system
• Management accounting system
• RMB guarantee system.
• Hong Kong International Settlement system
• Hong Kong capital system.
4. ODS platform
Definition: Support the data storage of post source storage layer and provide external data services;
Job description: The ODS platform supports the requirement of quasi-real-time data, including quasi-real-time data, recent incremental data, recent snapshot data and short-term historical data.
5. Data warehouse platform
Definition: responsible for supporting 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;
Job description: for the theme model level, referring to the banking integration model system, the theme design is carried out from several dimensions of domestic banks, overseas banks, rural banks and holding companies, and the ideas and principles of a set of conceptual models and two or more sets of logical models can be referred; the common processing layer refers to the use of the calculation rule engine to summarize and process the data according to the dimensions of domestic, overseas, villages and towns and holding companies, and process the group's comprehensive summary data on this basis; the business capability layer is divided into eight business capabilities according to the characteristics of xx state-owned commercial bank, including customer marketing and channel management, product and service management, asset and liability management, risk management, financial and performance management, operation management, compliance management and strategic decision management; data service, which provides data services through various interface forms according to the actual application requirements.
6. Application service area.
Technical services provided by service layer include intermediate service applications such as report query service, application service, active exploration service and data mining service. This layer provides various services to users to access the data platform, thus realizing diversification of access methods and transparency of information access.
The application layer provides application services including CRM application, performance appraisal application, assets and liabilities, management cockpit, credit risk, management accounting, unified report and data warehouse portal.
The user access layer includes various end users. According to the ways and characteristics of users using this system, they can be divided into head office and branch users, overseas branch users, subsidiary users and external users, etc.
Design ideas
According to the requirements of semantic layer, this part is designed to be open to business personnel in view. All tables and fields in the view are marked with business terms or indicator names familiar to business personnel, and the business terms or indicator names are designed with reference to data standard definitions.

By 2021, after years of construction and development, the data warehouse of xx state-owned commercial bank has well supported various key applications such as unified report, regulatory submission, risk management, financial supervision and executive cockpit, which laid a solid information foundation for the bank's good operation and subsequent development. Data warehouse is divided into two dimensions: data warehouse basic platform and each marketplace. The basic platform includes five aspects: temporary layer, basic layer, summary layer, service layer and semantic layer, which are stored in various modes, such as data buffer, theme model data, summary data, view service data and semantic information data, so as to meet the requirements of data warehouse stability, sub-theme, storage history and so on.

Up to now, the systems that have been warehoused by xx state-owned commercial bank mainly include 26 systems such as core system S01, grass-roots business system-student loans from places of origin S03, grass-roots business system-college student loan S04, evaluator system S05, workflow system S06, commercial bill system S07, general ledger system S08, financial sharing system S09, human resources system S10, capital business system S11, SME credit management system S12, full-process credit system S13, international settlement system S15, CRM system S16 and asset classification system S17, covering the main business information of the whole bank.