Consolidated Database View for Distributed Storage Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing computer systems lack an efficient method to provide a consolidated logical view of data storage systems, which is essential for effective system management, as they often involve multiple processing nodes with disparate views that require merging and conflict resolution.
Innovation Solution
A method and system that utilize a plurality of database tables associated with processing nodes to provide individual views, which are then merged into a consolidated view using a merge database table, with notification mechanisms and configuration files to manage conflicts and resolve differences, ensuring a unified system perspective.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If multiple processing nodes maintain individual database tables to represent their local views of the data storage system, then each node can independently track and manage its own configuration information, but the system lacks a unified consolidated view that requires complex merging and conflict resolution processes
Solution Approach 1:
The patent merges individual database tables from multiple processing nodes into a single consolidated database table. This consolidation combines the local views from each node into one unified view, eliminating the need for complex merging operations and conflict resolution while maintaining data integrity across the distributed system.
Solution Approach 2:
The consolidated database table serves as a universal structure that fulfills multiple functions: it maintains the local view information from each processing node, provides a unified system-wide view, and enables both individual node tracking and global system management within a single database structure.
2Ease of operation
If a consolidated view is created by merging individual node views, then a unified system perspective is achieved, but the process requires complex conflict resolution logic and increases processing overhead
Solution Approach 1:
The system performs preliminary actions by maintaining individual database tables at each processing node that are pre-configured with the correct structure and relationships. This preliminary organization of data at each node enables straightforward consolidation without requiring complex conflict resolution logic during the merging process, thus preserving processing efficiency.
Solution Approach 2:
The consolidated database table acts as an intermediary structure that receives and integrates information from individual node tables. This intermediary structure simplifies the merging process by providing a standardized target format, reducing the processing overhead required for conflict resolution and view consolidation.
3Measurement precision
If individual database tables are maintained at each processing node, then local view accuracy is preserved, but the lack of centralized coordination leads to view inconsistencies across the system
Solution Approach 1:
The patent combines individual database tables from multiple processing nodes into a single consolidated table that maintains the accuracy of local views while ensuring system-wide consistency. The merge process integrates data from each node without losing local view precision, while the unified structure eliminates inconsistencies between nodes.
Data Source
AI summary
Described are techniques for providing a consolidated logical view of a system. A plurality of database tables associated with a plurality of processing nodes of a data storage system is provided. The plurality of database tables provides a plurality of individual views of the data storage system and each of the individual views represents a view of the data storage system for a different processing node. A notification is received regarding a modification to one or more of the database tables. The notification identifies an operation performed causing the modification and providing data associated with the modification. A merge database table is modified that provides a consolidated view of said plurality of individual views. The modifying is performed in accordance with the notification and a configuration file including logic describing processing performed to merge the plurality of individual views.


