Hierarchical Data Change Log Consolidation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Hierarchical database structures face challenges in efficiently managing and visualizing change logs due to the accumulation of intermediate action records, which increases processing burdens and complicates the approval of user changes.
Innovation Solution
A record consolidation algorithm is implemented to group and sort change records based on timestamps, canceling out offsetting changes and merging successive records, resulting in a reduced and approved view of the hierarchy change log, displayed on an electronic visual display.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If change records are stored individually for each modification in hierarchical database structures, then complete tracking of all changes is achieved, but processing burden and data volume increase significantly
Solution Approach 1:
The patent merges multiple change records that represent intermediate actions into a single consolidated change record. This consolidation combines the information from individual modification records while eliminating redundant intermediate steps, thereby reducing the total number of records that need to be processed while preserving the complete change trajectory.
Solution Approach 2:
The patent extracts and eliminates intermediate action records from the change log, keeping only the essential net changes. This extraction process removes unnecessary intermediate steps while retaining the core information about what actually changed in the hierarchical data structure.
2Loss of information
If all intermediate action records are retained in the change log, then complete change history is preserved, but visualization and approval processes become complicated
Solution Approach 1:
The patent merges intermediate action records into consolidated change records that represent the net effect of multiple modifications. This merging reduces the number of visual elements in the change log while preserving the complete change history through the consolidated records, thereby simplifying visualization without losing information.
Solution Approach 2:
Instead of displaying all intermediate records and expecting users to filter them, the patent inverts the approach by pre-consolidating the records into their net changes before display. This inversion simplifies the visualization task by presenting only the essential information in a clear, approved format.
3Manufacturing precision
If multiple consolidation steps are performed on change records, then detailed processing is achieved, but processing time and computational resources increase
Solution Approach 1:
The patent performs consolidation of change records as a preliminary action when changes are first logged, rather than performing multiple consolidation steps later. This preliminary consolidation reduces the number of records that need to be processed in subsequent operations, thereby reducing processing time while maintaining accuracy through the initial consolidation logic.
Data Source
AI summary
Methods and systems are described for receiving data including a hierarchy change log comprising change records specifying changes made to hierarchical data. The hierarchical data includes hierarchically arranged nodes. Change records are grouped according to a key corresponding to each record. Using a record consolidation algorithm, a consolidated view of the hierarchy change log is generated. A consolidated view can be generated by sorting, for each group, the change records into an ascending temporal order based on their respective timestamps to form a sequence of change records. The consolidated view is then displayed on an electronic visual display. Related apparatus, systems, techniques and articles are also described.