Jilin Bank Historical Database Project — High Performance, High Scalability
Key Benefits
l Massive Data Management: A single GBase 8a node manages and queries massive datasets, scaling to terabytes.
l High Performance: Dramatically accelerates historical queries and report generation.
l Standardization: Supports SQL92 and provides ODBC, JDBC, ADO.NET, and native C API interfaces compliant with international standards.
Solutions
Bank of Jilin’s historical data platform uses the GBase 8a standalone database, running on two servers in a primary-standby configuration. Each day, data from business systems—including the accounting, credit, and international settlement systems—is loaded into the database via data files. GBase 8a provides data services through standard database interfaces for historical data queries and reporting.
Requirements Analysis
Bank of Jilin's historical database currently holds 1TB of data, with a daily data increment of 200MB, and is projected to exceed 5TB within five years. The application system should handle 500 concurrent queries with a response time under 3 seconds, efficiently responding to historical data query applications.
Project Background
The existing data warehouse system at Bank of Jilin is a data platform built on a traditional database, with historical data synchronized to a separate historical database also running on a traditional database. Anticipating rapid data growth, Bank of Jilin plans to expand and upgrade its data warehouse in the future, which requires evaluating and selecting a distributed database. This project introduces a next-generation database into the historical database system to assess its complex analytical performance and scalability. By validating the new database through the historical system, the bank aims to gain hands-on experience and lay the technical foundation for future data warehouse upgrades.