Shandong Mobile Uses OceanBase in All Core Systems, improving performance and reducing costs
Business Challenges
As the core business system of China Mobile Shandong, the billing system processes 13 billion entries of various CDR data every day. Therefore, data processing performance and accuracy are critical. The ever-increasing number of subscribers and concurrent requests in the Internet and 5G era pose a huge challenge to the capacity of standalone databases.
To implement application migration, Oracle database objects need to be sorted out from the complex business for adaptation. Therefore, a product that can automatically perform evaluation and conversion and support online database migration is required.
Solution
Multiple decentralized systems are consolidated and OceanBase Database is deployed across three IDCs, enabling high availability and disaster recovery by using technologies such as the Paxos protocol and partitioning.
Various technologies are used to improve the processing efficiency of online transaction processing (OLTP) transactions without performance loss, such as high compression ratio, partitioning, read/write splitting, and log-structured merge-tree (LSM-tree).
OceanBase Migration Service (OMS) is adopted to migrate applications from existing databases to OceanBase Database with zero data loss, and a transition plan is designed to ensure a smooth cutover without affecting the business. The QPS and TPS of core systems in CRM/BOSS domain are more than 20,000 and 100,000 respectively, with nearly 10TB of data.
Benefits
The efficiency of call bill processing is increased by 30%. The storage costs are reduced by 90%. The hardware and maintenance costs are also significantly reduced.
The cross-IDC distributed database achieves IDC-level disaster recovery capability with RPO=0, and no additional disaster recovery system is required.
During the application adaptation process, the data types, objects, and PL/SQL of the original Oracle system were only slightly modified, and the application cutover was completed within one hour, achieving a smooth migration of the application system.
The hardware costs are significantly reduced by using ordinary PC servers in place of the traditional "mid-range computers + centralized storage" architecture.
Explore more success stories
View all stories
Industrial and Commercial Bank of China (ICBC) was established on January 1, 1984, and was successfully listed on both the Shanghai Stock Exchange and the Hong Kong Stock Exchange on October 27, 2006. ICBC is the No.1 Bank for multiple consecutive years in The Banker's Top 1000 World Banks and Forbes Global 2000.
Based in Jiangsu Province, Jiangsu Mobile is a fully-owned branch of China Mobile Group. As one of the largest branches of the group, Jiangsu Mobile has exceeded 60 million mobile users in 2021, including nearly 25 million 5G users. The company also boasts 20 million broadband users and nearly 15 million OTT TV users. In a 2022 list, Jiangsu Mobile ranked second among 31 branches of China Mobile Group.
China Petrochemical Corporation (Sinopec) is the successor of the former China Petrochemical Corporation established in July 1983. Sinopec is now the largest supplier of refined oil and petrochemical products and the second-largest oil and gas producer in China. It is also the largest refining company and the third largest chemical engineering company in the world. Sinopec operates the second largest number of gas stations in the world and ranked second among the 2019 Fortune 500 companies across the globe.
Founded in 2005, PICC Health Insurance Co., Ltd. (PICC Health) is the first professional health insurance company in China. It was established jointly by PICC, one of the world’s top 500 companies, and DKV, the largest health insurance company in Europe. With a registered capital of CNY 8.568 billion, PICC Health is a professional health insurance company with the strongest financial strength in mainland China.