Network Topology Historical Data Management
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems face challenges in efficiently storing and retrieving historical topology information for network analysis, as current methods are cumbersome and time-consuming, especially when dealing with changes in node attributes and relationships over time.
Innovation Solution
A dual-database approach is implemented, where a graph database stores current topology identities and a relational database stores historical topology information, allowing for efficient retrieval and analysis of historical data based on filtering criteria.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If historical topology information is stored in a single database structure, then data integrity is maintained, but retrieval efficiency deteriorates and becomes time-consuming
Solution Approach 1:
The patent divides the database into two separate schemas: a graph database schema for storing current topology identities and a relational database schema for storing historical topology information. This segmentation allows each schema to be optimized for its specific purpose, enabling efficient retrieval of historical data without compromising the integrity of the overall topology information.
2Adaptability or versatility
If detailed historical topology information is stored, then analysis capability is improved, but device complexity increases
Solution Approach 1:
The patent introduces a temporal dimension by storing historical topology information with timestamps and version identifiers in the relational database schema. This allows the system to retrieve and analyze topology states at different points in time without adding complex temporal query mechanisms to the underlying database structure, thus improving analysis capability while maintaining manageable complexity.
3Measurement precision
If topology changes are tracked individually for each node, then measurement precision is improved, but productivity deteriorates due to cumbersome operations
Solution Approach 1:
The patent merges the tracking of individual node changes with relationship changes into a unified historical topology information structure. By storing changes in the context of the overall topology state rather than tracking each node independently, the system maintains precise change tracking while simplifying data management operations and improving productivity.
Data Source
Figure 1~2
Figure 3~4
Figure 5~7
AI summary
An apparatus, method, and computer program is provided, comprising: storing a plurality of topology identities of a network in a first database, wherein the network comprises a plurality of nodes; storing a plurality of topology definitions corresponding to the plurality of topology identities in a first schema of a second database; storing a plurality of topology information corresponding to the plurality of topology identities in a second schema of the second database, wherein the plurality of topology information comprises historical topology information related to identity of one or more of the plurality of nodes and relationship between one or more of the plurality of nodes; and providing one or more of the plurality of topology information in response to one or more requests, wherein the one or more requests specify one or more of the plurality of topology identities and/or one or more filtering criteria for selection of the one or more of the plurality of topology information, wherein the one or more of the plurality of topology information is provided for representation according to relations between one or more nodes.