GBase Smart Report Platform System — Recommended Solution from the Third Financial IT Application Innovation Lab
Recently, the Financial IT Application Innovation Lab officially released the “Outstanding Solutions of the Third Financial IT Application Innovation”. GBase, following selections in the first and second phases, has now been selected again with four solutions, and one was named a “Lab Recommended Solution”, once again earning recognition and affirmation from the authoritative institution and industry customers. Let’s take a look at the lab-recommended Smart Report Platform System solution, which leverages both GBase 8a MPP Cluster and GBase 8s databases.
Smart Report Platform System Solution
This solution provides data analysis tools such as ad-hoc query, 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 users. The system offers 24/7 data analysis and query capabilities, supporting scenarios with nearly ten thousand bank employees and hundreds of concurrent business data queries.
Application Scenarios
The application scenario of this solution is report development, which enables visualization large-screen displays, mobile cockpit applications, and self-service data analysis.
Visualization Screens: By using spreadsheets and self-service dashboards, customized visualization info boards can be built and displayed on PCs, commercial monitors, and video walls. Through charts and trends, you can quickly interpret the business information and development insights behind the data.
Mobile Apps: By custom-developing mobile reports and configuring mobile access, users can access information anytime, anywhere.
Self-Service Analysis: Business users can use data within the system or local data, define data metrics on their own, and perform data analysis and queries, quickly enabling both scheduled and ad-hoc data analysis.
Technology Stack
GBase Databases (GBase 8a MPP Cluster & GBase 8s) + Hygon chip + Kylin OS + Zhongchuang Middleware + Smart BI reporting system.
Pain Points Solved
Ø High Compatibility Between Self-Controlled Databases and BI Software
GBase database is compatible with multiple versions of Smart BI and has been widely adopted in the financial industry. In this project, both sides built on-site business needs and, through on-site service support, actively collaborated on environment setup, table structure data migration, and other related tasks, enabling rapid project rollout.
Ø Providing Proven Best Practices for Large-Scale MPP Clusters
Pioneering the large-scale use of domestically developed and controllable chip servers within MPP clusters, this solution provides replicable experience in cluster deployment, performance optimization, and O&M management. During implementation, it formed a complete innovative application platform implementation plan, server configuration and deployment recommendations, and clarified hardware requirements such as disks and network cards, delivering tangible experience and practice.
Ø Multi-Level High Availability Design Boosts Overall System Availability
From the perspectives of data security and computing environment high availability, strategies for node innovation upgrade, data backup and recovery, and data reprocessing were formulated. During project construction, GBase database's three-copy data storage and active-active cluster disaster recovery capabilities were employed.
Innovative Demonstration Results
This solution combines GBase databases for both OLAP and OLTP scenarios, fully leveraging the massive data analysis capabilities of the analytical database and the strong consistency and security of the transactional database. In the project, GBase database, integrated with the report platform's data analysis needs, fully harnesses its federated architecture, massively parallel processing, large-scale data compression, efficient storage structures, smart indexing, flexible data distribution, resource management, high concurrency, high availability, high security, ease of maintenance, and efficient loading capabilities. The system supports multiple innovative application scenarios for the bank, maximizing the platform's data analysis capabilities and enhancing data value. The Smart Report Platform provides advanced technical support for visual data presentation in the bank's big data applications.