Call Data Management Using Single Dimensional Coordinate Indexing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database storage methods for call data in cellular communication networks are inefficient, leading to slow data access times and inability to handle large volumes of data in near real-time, especially when geolocation and spatial information are involved, resulting in delayed fault detection and analysis.
Innovation Solution
A method of managing call data using single dimensional coordinate indexing and spatial/temporal grouping of call data records, allowing for reduced search operations and optimized storage space, enabling faster data retrieval and analysis by storing data in large blocks and using high-speed memory for processing.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If conventional database storage methods are used to store call records, then each call record can be stored in full with identical space allocation, but data access time becomes prohibitively slow when accessing large volumes of records
Solution Approach 1:
The patent segments call data into multiple fields (first field, second field, third field) with different access frequencies. The first field contains frequently accessed data (e.g., geolocation, spatial coordinates) while the second and third fields contain less frequently accessed data. This segmentation allows the system to optimize storage and access patterns for different data types, significantly reducing access time for frequently needed information.
Solution Approach 2:
The patent introduces a new dimension to traditional database storage by implementing a two-level storage architecture. Instead of storing all call records uniformly in a single database table, the system creates a first storage structure for the first field data and a second storage structure for the second and third field data. This dimensional change enables parallel access paths and reduces the time required to retrieve frequently accessed geolocation information.
2Ease of manufacture
If traditional database storage is used where each record occupies identical space, then storage management is simplified, but storage space efficiency decreases when records have varying data volumes
Solution Approach 1:
The patent segments call data into multiple fields (first field, second field, third field) with different access frequencies. The first field contains frequently accessed data (e.g., geolocation, spatial coordinates) while the second and third fields contain less frequently accessed data. This segmentation allows the system to optimize storage and access patterns for different data types, significantly reducing access time for frequently needed information.
Solution Approach 2:
The patent introduces a new dimension to traditional database storage by implementing a two-level storage architecture. Instead of storing all call records uniformly in a single database table, the system creates a first storage structure for the first field data and a second storage structure for the second and third field data. This dimensional change enables parallel access paths and reduces the time required to retrieve frequently accessed geolocation information.
3Device complexity
If conventional storage methods store all call data uniformly, then data structure simplicity is maintained, but search operations become excessively slow when accessing billions of records
Solution Approach 1:
The patent segments call data into multiple fields (first field, second field, third field) with different access frequencies. The first field contains frequently accessed data (e.g., geolocation, spatial coordinates) while the second and third fields contain less frequently accessed data. This segmentation allows the system to optimize storage and access patterns for different data types, significantly reducing access time for frequently needed information.
Solution Approach 2:
The patent introduces a new dimension to traditional database storage by implementing a two-level storage architecture. Instead of storing all call records uniformly in a single database table, the system creates a first storage structure for the first field data and a second storage structure for the second and third field data. This dimensional change enables parallel access paths and reduces the time required to retrieve frequently accessed geolocation information.
Data Source
AI summary
A data management system and method of managing call data for at least one radio network element within a cellular communication network. The method comprises receiving geolocation associated call data for at least one call within the at least one cellular communication network, arranging the received geolocation associated call data for the call into at least one call data record, and writing the at least one call data record to at least one data storage device, The geolocation associated call data for the at least one call comprises at least two spatial coordinate values for an at least two dimensional spatial reference, and the method comprises indexing the at least one call data record within the at least one data storage device using a single dimensional coordinate value.