Guangdong Provincial Tax Service Mobile Tax Inquiry Database Project — Tax Services at Your Fingertips, Efficient and Convenient

The Guangdong Provincial Tax Service has always attached great importance to tax informatization, having completed the development of a comprehensive data application platform, enabling the integrated application of provincial tax big data. The core data

Value Delivered

l GBase 8aClear Advantages:GBase 8a has been successfully deployed in the mobile tax service platform project. Based on test results and live operation data, GBase 8a demonstrates significant advantages over traditional Oracle databases in capacity, availability, scalability, and concurrency, making it more suitable for high-concurrency and massive data processing.

l Professional Products and Services:From a product perspective, we have enhanced functions and performance to meet the specific needs of the tax industry. On-site support from our technical team has effectively assisted customers with development and deployment, showcasing the service capabilities of a Chinese database vendor and raising satisfaction and confidence among tax industry customers.

l Building a Benchmark for Mobile Tax Inquiry Platforms:Taxpayers can now access tax services on their mobile devices. This project establishes a high-performance, high-concurrency public database query platform benchmark in the tax industry, laying a solid foundation for the deployment of similar projects.

Solution

Separate data processing for the integrated data application platform from mobile tax service queries. Once data processing is complete, the data mart layer from the data repository is distributed to the mobile tax query database as needed. For systems that are used 24 hours a day, data services are provided by connecting to the query repository.

The query database selection tested the performance of GBase 8a and Oracle.

Below are the TPS stress test results comparing GBase 8a and Oracle at sub-second response times under different concurrency levels. The query SQL simulates a property deed tax query (8.1 million rows of data) and a social insurance query (130 million rows of data).

Database Product	TPS at 100 Concurrent Users	TPS at 500 Concurrent Users
GBase 8a	2638.65	3161.83
Oracle	23.2	109.2

The test results above show that the TPS ratio between GBase 8a and Oracle at the same concurrency levels ranges from 100:1 to 300:1, demonstrating GBase 8a's significant advantage in concurrent processing capabilities.

Based on the test results and comparative advantages, GBase 8a was selected as the data repository for the mobile tax service platform and went live at the end of July 2018.

Project Background

Guangdong Provincial Tax Service has always prioritized tax digitalization. It has already built a comprehensive data application platform that integrates and leverages provincial-level tax big data. The core data warehouse of this project runs on a 48+7-node GBase 8a MPP Cluster. Building on this foundation, this project delivers a dedicated mobile tax service query database to provide high-performance support for mobile tax operations.