Network Management Query Mechanism for Cross-Database Stitching
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing network management systems require manual stitching of data from multiple databases, leading to inefficient use of computing power, memory, and network bandwidth, and necessitate bespoke code for filtering, sorting, and joining data, complicating the response to queries.
Innovation Solution
A query mechanism that automatically stitches data from different databases together, providing turn-key solutions with reduced data transfer and optimized resource usage, and supports intent-based analytics.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If manual data stitching and bespoke code are used to query multiple databases, then data can be retrieved from geographically separated databases, but computing power, memory, and network bandwidth are used inefficiently
Solution Approach 1:
The patent introduces an intermediary processing layer between the client and multiple geographically distributed databases. This intermediary automatically stitches data from different databases together, performs filtering, sorting, and joining operations, thereby reducing the computational burden on client systems and optimizing the use of computing power, memory, and network bandwidth across the system.
Solution Approach 2:
The system performs preliminary data compilation and stitching operations in advance, before the actual query is fully processed. By pre-processing data from multiple databases and organizing it into a unified format, the system reduces the time and resources required for real-time query operations, thereby improving query response speed while optimizing resource utilization.
2Adaptability or versatility
If network administrators write bespoke code for each query to perform filtering, sorting, and data joins, then custom processing can be achieved, but device complexity and time to implement increase
Solution Approach 1:
The patent implements a self-service query mechanism where the system automatically performs filtering, sorting, and joining operations on data from multiple databases without requiring network administrators to write bespoke code. The system serves itself by having built-in capabilities to handle custom processing requirements, thereby maintaining adaptability while significantly reducing the complexity of implementation and maintenance.
3Loss of information
If data is transferred from multiple databases to perform manual stitching, then comprehensive data can be collected, but network bandwidth is consumed sub-optimally
Solution Approach 1:
The patent extracts only the necessary data elements from multiple databases that are required to answer the specific query, rather than transferring entire datasets. By selectively extracting relevant information and performing stitching operations on a minimized data set, the system maintains data completeness while significantly reducing network bandwidth consumption.
Data Source
AI summary
A system comprising one or more processors configured to receive a query indicating one or more of filtering information, sorting information, or joining information and retrieve, from a first datastore, an intent graph for a network, wherein the intent graph comprises nodes representing components of the network and edges representing connections between the components. The one or more processors being further configured to select a subset of a plurality of network devices of the network based on the query and the intent graph retrieved from the first datastore and retrieve, from a second datastore, data received from the plurality of network devices of the network. The one or more processors being further configured to determine a response to the query based on the selected subset of the plurality of network devices and the data retrieved from the second datastore and output the response to the query.