RAM Database Allocator for Mobile Operator Data Distribution

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Large-scale mobile operator databases face challenges in managing vast amounts of data in real-time, particularly in providing services and analyzing subscriber behavior, as existing database systems based on clusters have reached their limits in terms of performance and fault tolerance.

Innovation Solution

A database system is proposed that distributes data across multiple computing devices with random access memory, using an allocator to organize data into chunks and define sequences for master and slave spaces, ensuring data replication and fault tolerance, allowing for high performance and load distribution.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If database systems use increasingly powerful clusters to manage large-scale data, then data processing capacity is improved, but system complexity and cost increase beyond sustainable limits

Engineering Contradiction:
Improvedata processing capacityVSAvoidsystem complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The database system is segmented into multiple independent computing devices, each handling a specific portion of the data. The allocator divides the database into chunks and distributes them across devices, allowing parallel processing without centralized complexity. Each device operates independently with its own RAM, eliminating the need for complex inter-device communication protocols while maintaining high throughput.

Inventive Principle:
Principle #1Segmentation

2Quantity of substance

If database systems increase cluster size to handle more data, then storage capacity is improved, but fault tolerance reaches diminishing returns

Engineering Contradiction:
Improvestorage capacityVSAvoidfault tolerance
Core Design Contradiction:
Quantity of substanceVSReliability

Solution Approach 1:

Each computing device is designed with local quality characteristics - sufficient RAM to hold its assigned database chunks in memory for fast access. The allocator ensures that critical data is replicated across multiple devices, but each device maintains optimal local resources rather than requiring uniform high capacity across the entire cluster. This localized resource allocation achieves fault tolerance without requiring excessive total capacity.

Inventive Principle:
Principle #3Local quality

3Speed

If database operations require real-time access to all subscriber data, then service responsiveness is improved, but data access complexity increases

Engineering Contradiction:
Improveservice responsivenessVSAvoiddata access complexity
Core Design Contradiction:
SpeedVSDevice complexity

Solution Approach 1:

The allocator pre-organizes database data into chunks and distributes them to computing devices before operations begin. Each device loads its assigned chunks into RAM in advance, so when real-time operations occur, data is already available in memory without requiring complex lookup or transfer operations. This preliminary organization enables fast real-time access while keeping the access mechanism simple - devices only need to access their local RAM.

Inventive Principle:
Principle #10Preliminary action

4Productivity

If the database is stored entirely in RAM across multiple devices, then access performance is improved, but data distribution and consistency management becomes complex

Engineering Contradiction:
Improveaccess performanceVSAvoiddata distribution complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The allocator acts as an intermediary that manages data distribution and consistency across devices. It organizes chunks, assigns them to devices, and handles replication to critical and tolerance slave spaces. This centralized coordination layer simplifies the overall system by providing a single point of control for data management, while individual devices maintain simple local RAM storage without needing complex distributed data structure management.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentEP3449394B1Database system
Publication Date: 2021.12.15 INTERSEC
  • EP3449394B1 patent drawingFigure 1~2
  • EP3449394B1 patent drawingFigure 3

AI summary

A database system (2) stores a database in the random-access memory of a plurality of computer devices (4) by organizing an efficient and robust distribution.