Database Service Nodes for Telecommunication Group Messaging
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The increasing user load on telecommunication capability group sending services causes database access bottlenecks, leading to resource shortages and slowed message sending during peak times, especially when multiple applications read subscription relationships simultaneously, affecting the overall performance of the service.
Innovation Solution
A system comprising an application cluster with a master control node and child nodes connected to database service nodes, which access storage equipment to read user quantity information and subscription relationships, and implement load balancing or switching in case of exceptions, ensuring efficient database access and resource distribution.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple applications read subscription relationships from the database simultaneously, then the database can serve multiple applications, but the database access bottleneck and resource shortage occur during peak times
Solution Approach 1:
The patent segments the database service into multiple independent database service nodes (first database service node, second database service node, etc.). Each application cluster is assigned to a specific database service node, preventing concurrent access conflicts. The master control node reads subscription relationships from the first database service node while child nodes read from the second database service node, dividing the database resources to eliminate access bottlenecks and ensure high message sending speed during peak times.
2Stress or pressure
If subscription relationships are stored as system files in disk of each application, then the database pressure is released, but the data management becomes inconvenient and physical I/O cost increases
Solution Approach 1:
The patent introduces database service nodes as intermediary layers between applications and the database. These service nodes manage subscription relationship data centrally, allowing applications to access data through the service nodes without storing local copies. This maintains centralized data management for ease of operation while the service nodes handle database pressure by distributing read requests across multiple nodes, preventing bottlenecks.
3Productivity
If multiple application clusters are used to improve processing capability, then the processing capacity increases, but the database access bottleneck worsens due to simultaneous reads
Solution Approach 1:
The patent segments both the application layer and database service layer into multiple independent units. Multiple application clusters are assigned to different database service nodes, with each cluster reading from its designated node. This segmentation ensures that increased processing capability from multiple clusters does not lead to concurrent access conflicts, as each cluster has dedicated database access paths, maintaining high reading speed during peak times.
4Reliability
If database service nodes implement load balancing, then the system reliability improves during exceptions, but the system complexity increases
Solution Approach 1:
The patent merges the load balancing and failover functionality into the database service node architecture itself. Database service nodes are designed to work in pairs or groups with built-in redundancy, where nodes can take over each other's responsibilities automatically upon failure. This integration of reliability mechanisms into the core service structure provides service continuity without adding separate complex load balancing systems, managing system complexity while ensuring reliability.
Data Source
Figure 1
Figure 2
Figure 3
AI summary
A method, device and system for carrying out telecommunication capability group sending is provided, the method includes: a master control node determining a telecommunication capability product of a scheduled telecommunication capability group sending service, and reading, through a corresponding database service node, user quantity information of scheduled telecommunication capability product from the storage equipment, and assigning group sending tasks to the master control node and each child node according to the user quantity information; the master control node and each child node interacting, through the corresponding database service node respectively, with storage equipments according to the group sending task of the master control node and each child node respectively, and reading subscription relationships and content/content set of the scheduled telecommunication capability product; the master control node and each child node sending the read subscription relationships and content/content set to a message center, and send the content/content set to users through the message center. The above technical solution increases the database access speed and avoids the problem of database's resources shortage and improves service performance of the telecommunication capability group sending.