Inspur Power Systems, Sunline, and GBase join forces to deliver a high-end data warehouse solution built on the domestically-developed GBase database.

Recently, Sunline’s data warehouse solution, Inspur K1 Power servers (domestically developed), and the GBase 8a domestic database have passed 24 basic functional and business scenario performance tests, demonstrating perfect compatibility, strong performance, and enabling smooth deployment, stable operation, and efficient service. This mutual certification provides a significant reference for an end-to-end domestically-developed data warehouse, covering hardware, software, and implementation.

Solution Overview

The joint solution fully leverages the performance of both software and hardware resources. The combined disk I/O performance of the server cluster remains stable at peak levels, and under high concurrency, the overall batch processing time meets the targeted requirements, achieving the optimal number of concurrent processes for batch execution. Preliminary estimates indicate a 40% improvement in batch processing efficiency in production environments. The joint solution helps financial customers improve resource utilization, reduce deployment time for IT departments, and enhance operational efficiency.

Previously, Sunline’s next-generation core banking system V8 was adapted to Inspur servers and successfully deployed at several financial institutions, including Liaoning Rural Credit Cooperative and various provincial and municipal rural commercial banks, with excellent operational results. The completion of this mutual certification between Sunline’s data warehouse solution and Inspur K1 Power servers further expands the scope of ecological collaboration, offering financial customers a more comprehensive joint solution.

Sunline’s data warehouse solution serves as a unified enterprise data resource center. It integrates mature data warehouse models with a scheduling and monitoring platform, a data exchange platform, and other supporting products, enabling the development of various analytical applications. This provides foundational support for the sustained development of financial businesses. Since its launch, it has gained widespread market recognition and has been implemented at dozens of financial and quasi-financial institutions.

Inspur K1 Power servers are built on the latest POWER9 processors, delivering a 40% performance improvement over the previous generation. Each processor core supports 4 to 8 threads, efficiently handling the threading demands of multiple service processes under a microservices architecture. The number of concurrent services that a single server can support far exceeds that of x86-based systems.

This joint certification thoroughly validates the compatibility and superiority of Sunline’s data warehouse solution with Inspur’s hardware servers. It lays a solid foundation for in-depth collaboration in big data while accelerating the deployment of innovative applications and the digital transformation of the financial industry.

Solution Advantages

Mature Model: Featuring a proven data model, data from source business systems is processed and stored hierarchically into various data layers according to proprietary data warehouse and data mart models. This fully unlocks the value of data backends and ensures standardized and orderly management and utilization of the data warehouse.

High Performance: Leveraging Inspur K1 Power high-performance servers, data is collected incrementally whenever possible. A non-full-field zipper algorithm is used to compress historical data, and data models are designed using wide, denormalized tables to balance performance and efficiency. Some data adopts source-aligned modeling to minimize dependencies between processing tasks, ensuring optimized storage and computing performance for the data backend.

Modular Products: A suite of modular supporting tools caters to the customized data backend requirements of various enterprises. A range of data application products also addresses diverse needs for extending data warehouse-based applications.

Automated ETL Development: Based on the self-developed SunJCM scheduling platform and using the Python programming language, ETL and data processing jobs are orchestrated in a unified, standardized, and streamlined automated process. This ensures scheduling accuracy and reduces risks associated with manual intervention.

Standardized Data Services: With standardized data models and high-quality data, the solution provides normalized data and service support for downstream systems, enabling efficient development and expansion of downstream applications.

Applicable Scenarios

Banking: Build a unified data warehouse based on internal and external banking data, supporting both demand-driven and data-driven data warehouse construction across different scenarios.

Securities: Build a unified data warehouse based on internal and external data from securities firms.

Finance Companies: Build a unified data warehouse based on finance company data, using a data model tailored to their needs.

Sunline

Sunline is a global financial technology solution provider founded in 2002. It primarily offers comprehensive financial IT solutions for financial institutions, covering core banking, digital banking, data services, and management business.

The data warehouse is positioned as a unified enterprise data resource center, relying on advanced data models, standardized batch data processing architecture, and efficient data supply. It supports construction on traditional relational databases, MPP databases, and Hadoop databases, enabling the development of various analytical applications and providing foundational support for sustained business development.

GBase

Tianjin General Data Technology Co., Ltd. (GBase), founded in 2004, is a key software enterprise in China’s national planning, dedicated to database software products and services. Committed to being the most trusted database provider, the company has focused on the R&D and promotion of domestic databases since its inception. It has served over 10,000 users across finance, telecom, government, defense, and various enterprises.

GBase 8a MPP Cluster is a distributed parallel database cluster built on a shared-nothing architecture, featuring federation, massively parallel processing, massive data compression, virtual clusters and mirroring, and fast online scaling. It delivers high performance, high availability, high scalability, and ease of expansion, providing a cost-effective general-purpose computing platform for managing data of any scale. It is widely used to support data warehouse systems, BI systems, and decision support systems, with large-scale deployments in finance and telecom. To date, it has been deployed on over 30,000 nodes and manages more than 200PB of data.

Inspur Power Commercial Systems

Inspur Power Commercial Systems Co., Ltd. is a China-based server manufacturer founded as a joint venture between Inspur Electronic Information Industry Co., Ltd. and International Business Machines (China) Co., Ltd., with Inspur holding a controlling stake. Inspur has long been a leader in China’s IT innovation, and its self-developed K1 mission-critical server was awarded the First Prize for National Science and Technology Progress.

Inspur Power Commercial Systems inherits Inspur’s technical expertise in high-end server system design. By leveraging the performance, functionality, and reliability advantages of Power processors, it develops, manufactures, and sells the Inspur K1 Power server series—offering both scale-up and scale-out capabilities—for the China and Belt & Road markets. It delivers customized, secure, and reliable end-to-end solutions, along with localized, professional, and agile software and technical support services.