Qilu Bank Intelligent Reporting Platform System Replacement and Upgrade Project

1 Project Overview

• Project Background

The intelligent reporting platform is an important information system of Qilu Bank. Under the guidance of China's financial IT innovation policy and the dual requirements of industry digital transformation, Qilu Bank has proactively completed the full-stack domestic replacement of the intelligent reporting platform. Full-stack domestic replacement has been achieved across servers, chips, operating systems, databases, applications, and other aspects. The upgraded reporting platform operates on a single-track basis, and the platform system has been running stably for several months since its launch in November 2022.

The original data of Qilu Bank's intelligent reporting platform used an Oracle database，Smart BI reporting system. With the growth of business data volume, typical requirements for analytical scenarios, domestic replacement requirements, users expect a domestic database that can effectively support analytical scenarios and is compatible with Smart BI applications.

• Business Requirements

Qilu Bank's intelligent reporting platform requires powerful data analysis and presentation capabilities to provide the bank with one-stop, platform-based business intelligence services. The platform can connect to business databases and big data platforms for data processing, analysis and mining, and visual presentation；meeting various data analysis application requirements.

The main application scenario of this system is report development, enabling visual large-screen displays, mobile cockpit applications, and self-service data analysis through report development.

Visual large screen：By using spreadsheets and self-service dashboards, visual large-screen information dashboards can be custom-developed for display on PCs, commercial displays, and video walls, enabling rapid interpretation of the business information and development trends behind the data through charts and trend information.

Mobile applications：By custom-developing mobile reports and configuring mobile access, access anytime and anywhere is enabled.

Self-service analysis：Business personnel can use data within the system or local data, define data indicators through the system, and perform data analysis queries and analysis, quickly enabling regular and ad hoc data analysis.

• Implementation Requirements

1，Compatibility of upstream and downstream domestic software and hardware products

The application system needs to be migrated and transformed for domestic-platform databases, and upstream and downstream adaptation work needs to be completed. With the advancement of domestic replacement, vendors of applications, chips, servers, operating systems，databases, and other components have established comprehensive ecosystem systems. Through extensive mutually certified adaptation work and continuous upgrades and optimization through product iterations after production launch, compatibility between platforms is ensured.

2，Data stability and security

The product has no single-node bottleneck, data replicas, and built-in disaster recovery and backup capabilities；it complies with national mandatory security requirements.

3，Performance requirements for domestic platforms

Supported scenarios：data querying, statistics, analysis, mining, and backup, among others.

4，Ease of platform maintenance

The product can provide Chinese graphical management tools, such as：management tools, O&M tools, monitoring tools, migration tools, etc.

5，Requirements for rapid product learning and use

The vendor should provide comprehensive training and service mechanisms.

2 Solution

The database implementation for Qilu Bank's intelligent reporting platform uses two database products, GBase 8a MPP Cluster and GBase 8s, completing a comprehensive replacement of the original Oracle database. This meets users' dual OLTP+OLAP scenario requirements.

GBase 8a MPP Cluster is a high-performance domestic database product independently developed by GBase for massive data query and analysis applications. It is used to meet the growing data storage, management, and processing requirements for data querying, statistics, analysis, mining, backup, and more in data-intensive industries, and can serve as the underlying database for data warehouse systems, BI systems, and decision support systems.

GBase 8s is a transaction-oriented database independently developed by GBase. It offers high security and complies with the national Level 4 security database standard；it provides strong consistency and meets financial-grade ACID transaction strong consistency requirements；it delivers financial-grade high availability, supporting shared storage in the same data center （SSC）, primary-standby high-availability disaster recovery （HAC）, remote disaster recovery high availability （RHAC）, failover within seconds, and 99.999% availability.

Through on-site service assurance, GBase actively supported relevant work including environment setup, table structure and data migration, and business system go-live and cutover assurance, promoting the stable and rapid launch of the system.

Qilu Bank Intelligent Reporting Platform System Architecture Diagram

3 Application Results and Value

The construction of the intelligent reporting platform integrates GBase's dual OLAP and OLTP scenarios, fully leveraging the massive data analysis capabilities of analytical databases and the strong consistency and security capabilities of transactional databases. The full-stack domestic replacement of the intelligent reporting platform achieved the expected implementation objectives, delivering both technical and business value, mainly reflected in the following aspects：

Comprehensive platform domestic replacement：Based on a fully domestic platform, it perfectly supports customers' Smart bi applications and, together with the advanced design architecture and high-performance data processing capabilities of GBase databases, fully replaces foreign database products.

Superior performance：Supports multi-instance deployment on a single node, fully utilizing the computing capabilities of NUMA architecture servers to deliver exceptional query performance. Supports a vectorized engine and vectorized computing capabilities, effectively improving data processing efficiency and query performance.

Enhanced data stability and security：GBase 8a MPP Cluster adopts an MPP distributed architecture, with no single-node bottleneck, data replicas, and built-in disaster recovery and backup capabilities. The product supports national cryptographic algorithms and complies with national mandatory security requirements.

Secure and controllable：Core systems all use domestic database products with fully independent intellectual property rights, featuring independent R&D and security and controllability, comprehensively improving the data security and business security of the bank's existing data.

Ease of platform maintenance：GBase databases meet requirements for ease of maintenance and usability. The products provide Chinese graphical management tools, such as：management tools, O&M tools, monitoring tools, migration tools, etc. This provides significant convenience for O&M management and reduces the cost of using and learning databases.

High-quality service assurance：GBase provides original vendor technical support services, with a comprehensive training mechanism and certified technical training.

Meets user scenarios：The reporting platform provides data analysis tools such as ad hoc queries, pivot analysis, spreadsheets, self-service dashboards, mobile cockpits, multidimensional analysis, and self-service ETL. It meets the statistical analysis and data query needs of different business users. The system provides 7*24-hour data analysis and query capabilities, meeting the business data query scenario requirements of thousands of bank employees and hundreds of concurrent users.