473,320 Members | 1,979 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes and contribute your articles to a community of 473,320 developers and data experts.

AntDB helped China Mobile upgrade its billing system of the South China Center

26 16bit
In recent years, China Mobile has been strengthening the independent and controllable construction of IT support system for business operation. AntDB has been cultivated in the core system of carriers for 15 years, and has been put online in many fields of the communication industry and guaranteed continuous and smooth operation, which is fully equipped with the capability of foreign databases. Because of its leading technology and stability, Hunan Mobile(the branch of China Mobile in Hunan Province) has been actively promoting the localization of its core business database through AntDB.

Ⅰ. Construction Requirements
Distributed architecture for massive data
The South China Center is the key site of Hunan Mobile, and its detailed ticket database of billing system carries many types of business bills of mobile communication users, including traffic, voice, SMS, MMS and Monternet-type tickets, which are processed by the database after collection, billing, accounting and other business modules.

The number of communication users served by South China Center reaches tens of millions, and its detailed tickets database has very high requirements for data storage, analysis and calculation, and the data volume can reach billions of records added daily, and the designed capacity of the platform reaches hundreds of terabytes. The traditional centralized architecture cannot meet the business requirements in terms of concurrent performance, high availability and scalability, so the horizontal scalability of AntDB is needed to enhance the capacity of its system to carry the ticket volume and analyze and process the data.

The billing project team of South China Center adopted a gradual approach with reference to the scope of impact on business, starting from the Center’s billing system to gradually complete the replacement of multiple core databases.
The project team communicated in depth with the customer and analyzed the main needs of the customer as follows:
1.The domestic database needs to have a high degree of compatibility with the previous foreign commercial database, to minimize the upper-level business changes, accelerate the replacement cycle and reduce the cost.

2.High-load business bearing. The daily processing volume of the database reaches several billion.

3.Massive data processing. Hundreds of terabytes of data are generated per month according to the existing business model, requiring database processing.

4.The architecture of distributed database cluster is complex, involving many node types and nodes, it will greatly enhance the complexity of operation and maintenance, reduce system reliability if merely relying on human operation and maintenance. So introducing a intelligent operation and maintenance management platform of database is needed.
This project has the following requirements for database considering customer’s concerns:
  • High compatibility with the previous database in terms of stored procedures and syntax
  • Stable product functions, improved performance, and flexible expansion
  • Highly available and disaster-tolerant architecture
  • Full-lifecycle management and maintenance tools and related services

Ⅱ. AntDB Solution
Six advantages facilitate stable operation
AntDB meets all the requirements of the customer, and it leads the industry especially in syntax compatibility with Oracle. In addition, what AntDB provides is more than a product, but a complete set of service for data management system, including a set of core product, a set of toolkit, intelligent operation and maintenance system and so on, which are convenient for its customers to manage the digital assets of the corporation in a quick and efficient way.

Figure 1: product system of AntDB
AntDB has six advantages as follows:

Figure 2: advantages of AntDB
Highly compatible with foreign commercial databases
AntDB has the original multimodal SQL parsing engine: 1. customer can customize and expand the design of multi-syntax SQL parsing engine, which is compatible with the ecology, and one set of database can meet the requirements of localization and replacement of various databases including foreign commercial databases of this project, reducing the learning cost of customers. 2. The switch of SQL parsing engine takes effect dynamically without restarting the database. 3. It supports three access modes of session mode, service mode and statement mode, offering the ultimate experience of flexibility and ease of use.

The high compatibility with foreign database syntax: syntax compatibility, function compatibility, system table/view compatibility, stored procedure and trigger compatibility, data type compatibility, OCI and JDBC call interface compatibility, management package compatibility, rowid/rownum and dual dummy table, etc. Based on the feature of high compatibility, the heterogeneous database disaster recovery of AntDB and foreign databases can be realized, and two sets of databases running in parallel at the early stage of launch to reduce customer's doubts.
Cloud-native distributed architecture and elastic scalability
The horizontal scalability of database is required for detailed ticket library of settlement center to realize linear expansion. With cloud-native distributed design, AntDB is completely transparent to application and perfect in performance and scalability. In addition, AntDB has powerful scale up capacity, which holds no limits to CPU, memory and the number of connection. When the data is sliced and stored in each data node, the number of nodes can be expanded horizontally to enhance the database storage capacity by virtue of the distributed architecture when the data storage demand of detailed ticket library exceeds the limit of a single server.
Real-time analysis of data
The billing and detailed ticket database processes billions of tickets per day, and performs data analysis to generate reports. AntDB has real-time strong consistency of data and distributed transaction control, ensuring 0 data loss and transaction consistency, and guaranteeing the accuracy of bill data processing. AntDB has dynamic and efficient SQL execution engine, providing heterogeneous index and built-in reduce data processing engine, and data nodes can communicate with each other to improve data processing efficiency, especially for complex query scenarios (aggregation, correlation, etc.), and improve the processing efficiency of billing statement data and the generation speed of related report.

Figure 3: the architecture of AntDB
High availability and load balancing
The billing system requires high reliability. AntDB provides a complete cluster self-healing solution to ensure second-level automatic failover to achieve business continuity, and can guarantee data integrity and strong consistency to achieve the true sense of Auto-Failover, ensuring that the database system can obtain 99.999% SLA service guarantee.

AntDB adopted typical distributed architecture for the South China Center, which has dual-center disaster recovery mechanism with total 48 hosts in master and standby center. The data nodes DN1-DN12 are equipped with one host and two standby machines each, where the master center is configured with one host and one standby machine while the disaster recovery center with an asynchronous backup node, totaling 36 nodes. The GTM master-standby center has one host and one standby machine for each one, totaling 4 nodes. The master-standby center of compute node has 4 machines for each, amounting to 8 nodes, and the data between master and standby node is synchronized through stream replication. The data nodes from DN1 to DN2 are master nodes, and the rest of them are standby nodes. The nodes in standby data center synchronize the data by cascade replication. Switch operation is completed through the command of ADBMGR. The architecture is as follows as shown in Figure 2 below.
Dual-center disaster recovery ensures reliability
According to user’s requirements, the billing system is the core system, and to ensure the business continuity and data security, the database needs to build a main/backup disaster recovery system, so that another center can quickly take over when a global failure occurs in a single center, such as power failure or network disconnection, without affecting the data storage and processing of biling tickets. AntDB supports various disaster recovery methods, such as dual-center, two locations and three centers, etc. The dual-center disaster recovery mode is chosen for this project.

AntDB distributed deployment architecture naturally supports dual-center disaster recovery, and through AntDB cluster management tools, the cluster can be quickly built in the backup center, and can be quickly switched to the backup center to carry business when the global failure occurs in the main center.

Figure 4: the "dual-center" deployment architecture of AntDB’s distributed disaster recovery
Intelligent operation and maintenance control
The number of nodes of billing and detailed ticket database in the is extremely large, and the operation and maintenance platform needs unified management of database clusters. AntDB provides intelligent operation and maintenance control platform, which can realize management of database cluster. Automatic monitoring of database, including regular database server monitoring, database key indicator monitoring, and alarm notification, etc., can greatly improve the maintainability of database.

Figure 5: the intelligent operation and maintenance control platform for database AntDB Control Center(ACC)
Ⅲ. High Reliability and high performance
Both respects matter
The launch of AntDB has upgraded the database system architecture of billing system, met the growing business needs of users, and improved the processing efficiency of ticket data of billing center. At the same time, the high availability of the database and the "dual-center" disaster recovery architecture can ensure the business continuity and data security, guaranteeing the safety and reliability of processing ticket data.
Summary of architecture advantages
(1) Elastic expansion and deployment of normal PC: enterprises had to buy more expensive small machines and higher-end storage before if they needed to improve the processing performance of database and meet the requirement of foreground response. One of the main features of distributed database, as extensively used database system now, is the capability of horizontally distributed expansion. AntDB can use higher cost-performance domestic servers or normal PC to make up for the server performance gap through the horizontal scalability of distributed deployment. It can do more than just ensure the high reliability of the system though its high availability and dual-center disaster recovery, but also perform online capacity expansion without downtime or service interruption to meet the business requirement in time under the circumstance of fast business growth.

(2) Highly available and reliable business assurance: AntDB has the ability of highly available service. In the project, AntDB achieves automatic fail-over (failure self-healing) in seconds through cluster self-healing and dual-center disaster recovery architecture to ensure business continuity, while ensuring tne integrity and strong consistency of data. Even in the extreme risk of server room failure, it can quickly switch to the backup center to take over the business and ensure the upper-level business unaffected.
Summary of effect advantages
AntDB passed the integrity function test, and in the scenario of 10 million phone tickets, with the same hardware and configuration, the processing time of AntDB was only one quarter of the original database, and the processing efficiency was greatly improved. In order to reduce the migration risk, AntDB formally completed the replacement and went online after two weeks of parallel operation with the original database. AntDB fully supports the core billing system with smooth operation, and now the daily processing volume is over 5 billion. The comprehensive performance is improved by 25% compared with the original architecture, and the cost is saved by 70%.

The overall hardware and software cost of AntDB is significantly lower than that of foreign databases, which reduces the cost for the customer by about 70%. The intelligent operation and maintenance control platform of AntDB to be introduced in the project can reduce the annual maintenance cost of millions for the customer.
Ⅳ. Develop a domestic database with ease to use
The project for the South China Center is not only a replacement of one set of database of carrier’s core billing system, but also testified the reliability of AntDB in the scenario of multiple numbers of connection and high concurrency. It improved the performance on the premise of reducing remarkably the software and hardware cost for the customer. When the business data outgrows the capacity of the database, with AntDB’s distributed scalability, HashMap algorithm and self-developed data replication tool AntCDC, the user can expand the capacity efficiently and quickly, which brings no influence on upper-level business and increases the system scalability.
May 16 '23 #1
0 4551

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Scott | last post by:
Not sure if this is the right place to post this or not, but I am in the process of trying to find a Web Hosting/Isp Billing system that is reasonable in price and uses Access or SQL Server for a...
0
by: Denon | last post by:
Hello, Currently, I'm finding a way to build a system that is billing to any web access end-user. If they new a session to web server, then start to charge, and if they close the browser, then...
1
by: SRK | last post by:
I'm looking for a book on business modeling that is focused on designing billing systems and other cyclical business processes. I have experience in design and I have an architecture already but...
0
by: adinugroho | last post by:
Are Somebody know what's name of this web hosting billing system? http://dewahosting.com/whois Can I get this scripts for free?
2
by: tamasuka | last post by:
?????I Dont kNow how to create A billing system Using MS Access
1
by: qamarjawaid | last post by:
Hello I am having a China mobile Nokia O3 its got a problem keep saying searching and the screen blinking and when I try to go to blue tooth option its give me error says blue tooth initializing pls...
0
by: VanL | last post by:
AC Perdon wrote: Look at Fivedash (fivedash.com), it may be what you need.
1
by: whiteshadow | last post by:
Dear Bytes i am currently developing a Management system for a university which can be used on mobile. Currently the company already have a Management system but it is desktop based. I am just...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.