Explore GBASE Outstanding Financial IT Innovation Solutions · Data Warehouse Migration Solution

To promote the efficient and orderly implementation of financial IT application innovation and continuously provide referenceable and replicable guidelines and demonstrations for the financial industry, the Financial IT Application Innovation Ecosystem Laboratory (hereinafter the "Lab") organized the first and second batches of financial IT innovation solution selection starting from November 2021. Several GBase solutions stood out and were recognized as "Outstanding Financial IT Application Innovation Solutions," garnering widespread attention and recognition.

For this purpose, the Lab has launched a dedicated column for Outstanding Financial IT Application Innovation Solutions to showcase the excellent results. Now, let's explore GBASE's outstanding solutions together!

Data Warehouse System Solution

Solution Overview

This solution uses the GBase 8a MPP Cluster database to build an active-active cluster (business-active) architecture, enabling simultaneous read/write operations in both centers with data synchronization between them. The cluster adopts a distributed flat architecture that can scale out dynamically, supporting massive data storage and large-scale parallel computing. The system data model includes: Data Source Layer, Data Exchange Layer, Data Processing Layer, Data Mart Layer, Data Service Interface Layer, Data Application Layer, and Unified Service Layer. It can provide unified data services such as multiple marts, branch marts, analysis and mining, externally.

Pain Points and Challenges Addressed

(1) Data Silos. In traditional data warehouses, due to the closed architecture, various business systems—such as core banking, personal loans, general ledger, credit, online banking, and risk systems—are stored separately, leading to data silos.

(2) Insufficient computing power to meet business needs. The original system's all-in-one database machine was not only expensive but also unfavorable for large-scale horizontal scaling, failing to meet the performance requirements for ultra-large-scale data computation and making it difficult to complete computation tasks within tight time windows.

(3) Resource contention between ad-hoc queries and batch jobs. Conflicts between ad-hoc queries and batch jobs, combined with the platform's insufficient computing capacity, lead to restricted ad-hoc query resources when back-end jobs are busy, resulting in low concurrency and poor user experience for business departments.

Typical Case: Data Warehouse Project of a State-owned Bank’s Head Office

This case built a new-generation data warehouse system based on Phytium CPUs, Kylin OS, and the GBase 8a MPP Cluster database. The new system comprehensively supports applications in external regulatory compliance, asset-liability management, business management, and risk management. It covers 8 major business domains, 33 business lines, and over 120 business scenarios, providing in-depth big data analytics and comprehensive applications to serve as an innovation engine for accelerated business growth.

Typical Case: Audit System Project of a Provincial Rural Credit Cooperative

This case built a data warehouse platform based on Kunpeng CPUs, Kylin OS, and the GBase 8a MPP Cluster database, achieving large-scale parallel processing of massive data with high performance, scalability, and availability, solving issues such as system performance degradation and the inability to linearly expand the database, supporting the rapid development of audit and data analysis.

Financial IT Application Innovation Ecosystem Laboratory

The Financial IT Application Innovation Ecosystem Laboratory (hereinafter the "Lab") is an important infrastructure and professional experimentation platform dedicated to financial IT application innovation. It is led by the People's Bank of China, spearheaded by China Financial Electronics Group Co., Ltd., in cooperation with key financial institutions and industry organizations, and follows the principles of "co-consultation, co-construction, win-win, and sharing."

Adhering to goal-oriented and problem-oriented approaches and pooling resources from multiple parties, the Lab addresses common issues in financial IT application innovation. Since the launch of solution selection, the Lab has collected over a thousand solutions, forming a case library that provides referenceable, replicable, and promotable guidelines and demonstrations for financial institutions.

The Lab will soon launch the third call for Financial IT Application Innovation solutions and welcomes more organizations to actively participate, presenting and disseminating more and better solutions to empower the financial industry's IT innovation and digital transformation, and contributing wisdom and strength to the high-quality development of the financial sector and technological self-reliance.

General Data Technology Co., Ltd.

General Data Technology Co., Ltd., founded in 2004, has always focused on the R&D and promotion of independently controllable databases, providing products and services to over 10,000 users in sectors such as Party and government, finance, telecommunications, public administration, energy, transportation, and national defense. Its financial industry clients include policy banks, large state-owned banks, joint-stock banks, city commercial banks and rural credit cooperatives, insurance, and securities firms.

The GBase series databases include centralized transactional databases, distributed transactional databases, distributed analytical databases, cloud data warehouses, and more. GBase databases have been deployed in over 110 banks, covering core banking, core trading systems, general trading systems, office systems, data warehouses, big data platforms, data middle platforms, data lakehouses, and various other applications. Specifically, the centralized transactional database GBase 8s has been deployed in core banking systems of city commercial banks; the distributed analytical database GBase 8a has been applied in data warehouse projects of multiple large state-owned banks and state-owned insurance companies.