Bank of China Jiangsu Branch Big Data Platform — Driving Business Innovation, Delivering Efficient Service, and Giving Back to Society

lData Integration: GBase 8a MPP Cluster excels at massive storage and large-scale parallel computing, enabling seamless data consolidation and management. Its powerful data integration and processing capabilities deliver a consistent, reliable data view.

lAd Hoc Query: GBase 8a MPP Cluster provides high-performance ad hoc query capabilities on massive data volumes, enabling fast, row-by-row inquiries into transaction details.

lStandardization: SQL92 compliance, along with industry-standard ODBC, JDBC, and ADO.NET interfaces, plus a native C API.

lHigh Linear Scalability: GBase 8a MPP Cluster offers online, high-scalability expansion, ensuring the data platform can seamlessly integrate additional business systems and support higher-level complex analysis and strategic decision-making.

This project deployed a 2×3 node cluster, leveraging GBase 8a MPP Cluster, a massively parallel processing distributed database system, to establish the core data management layer of the data platform, creating a unified foundational data platform for all data. The current data volume is 14 TB, with a daily incremental growth of 20 GB, totaling over 1,300 tables. The largest table holds 4.7 billion rows, and daily batch processing runs for 4–5 hours. Aligned with business needs, the configuration includes 1 loading server and 6 computing nodes.

l  Powerful: Seamlessly integrates data migration, data processing, data querying, and application connectivity into one platform;

l  High Performance: Delivers rapid response for data loading, import/export, processing, splitting, and querying;

l  High Availability: Ensures 24/7 continuous operation and eliminates downtime caused by single points of failure or system maintenance;

l  Tooling & Interfaces: Monitors performance, storage usage, CPU utilization, memory usage, and SQL performance; supports the SQL-92 standard and provides ODBC, JDBC, ADO.NET, and native C API interfaces that comply with international specifications.

Amid the big data trend, Bank of China Limited, Jiangsu Branch proactively pursued business innovation and took the lead in building a big data platform based on MPP relational databases to support massive data storage, analysis, and statistics. The MPP database product is deployed in a marketing analytics platform, leveraging big data-driven precision marketing to serve customers and society efficiently while increasing revenue.