Jilin Bank Historical Database Project — High Performance, High Scalability

Jilin Bank's current data warehouse system is a data platform built using traditional databases, with historical data synchronized to a historical database also built on traditional databases. Jilin Bank has already anticipated the rapid growth trend

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.