Distributed Database Layer for Real-Time Network Test Data Reporting
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional data processing approaches fail to respond to data queries in real-time during network device testing, resulting in delayed collection and marshaling of test sample data, which is time-consuming and inefficient, especially when testing high-capacity routers and switches that simulate thousands or millions of data sessions.
Innovation Solution
Implementing a distributed database layer with multiple in-memory databases on each processing card, each with its own tables and database access software, allowing for real-time data collection and reporting by using embedded databases with SQL interfaces, such as eXtremeDB, to speed up data retrieval and reduce the time required to collect end-of-test results significantly.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If conventional data processing approaches are used to collect and marshal test sample data, then data collection is performed, but the response time to data queries is delayed and the process is time-consuming
Solution Approach 1:
The patent divides the monolithic database system into multiple distributed database instances, each running on separate processing cards. This segmentation allows parallel data collection and retrieval operations across multiple nodes, dramatically reducing the time required to collect and marshal test sample data from hours to minutes.
Solution Approach 2:
The patent introduces an intermediary layer consisting of database instances that act as buffers between the test data generation sources and the final data collection point. These intermediary databases pre-process and store data locally, enabling faster retrieval and reducing the bottleneck at the central collection point.
2Speed
If multiple database instances are implemented on each processing card, then data retrieval speed is improved, but device complexity increases
Solution Approach 1:
The patent creates universal database instances that can handle multiple types of test data and queries simultaneously. Each database instance is designed to be multi-functional, managing various test parameters and metrics within a unified structure, which reduces the overall complexity compared to having separate specialized databases for each function.
Solution Approach 2:
The patent uses identical copies of the database instance architecture across multiple processing cards. This replication strategy simplifies the system design by using a standardized template that can be uniformly deployed, reducing the complexity of integration and management despite the increased number of database instances.
3Ease of operation
If real-time data collection is implemented during testing, then reporting responsiveness is improved, but data processing load increases
Solution Approach 1:
The patent performs preliminary data processing and filtering at the source before data is transferred to central storage. Test sample data is pre-processed, validated, and organized into the distributed database instances during the test execution itself, reducing the processing load during post-test analysis and enabling real-time reporting without overwhelming the system.
Data Source
AI summary
The technology disclosed relates to real-time collection and flexible reporting of test data. In particular, it is useful when collecting packet counts during tests of network devices that simulate thousands or even millions of data sessions conducted through a device under test (“DUT”).