472,338 Members | 1,644 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes and contribute your articles to a community of 472,338 developers and data experts.

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

21 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.
2 Weeks Ago #1
0 3961

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

Similar topics

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...
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...
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...
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?
by: tamasuka | last post by:
?????I Dont kNow how to create A billing system Using MS Access
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...
by: VanL | last post by:
AC Perdon wrote: Look at Fivedash (fivedash.com), it may be what you need.
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...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

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.