XBRL to JSON Conversion ID Duplication Check
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The conversion of XBRL data to JSON format requires significant memory capacity for duplication checks of new IDs, which is also a problem in converting data to other formats like XML and CSV, leading to inefficient memory usage.
Innovation Solution
A method that generates and manages IDs by associating them with data in a conversion file using an algorithm, referencing relationship information to avoid duplications, thereby reducing the need for extensive memory checks.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If all data in XBRL format is loaded into memory as a model tree for conversion to JSON, then duplication check of IDs can be performed, but memory capacity requirement increases significantly (about five times the data size)
Solution Approach 1:
The patent extracts only the necessary information (ID values and their positions) from the complete data model, storing them in a simplified list structure. This allows duplication checking to be performed on extracted ID information without loading the entire data model into memory, significantly reducing memory requirements while maintaining duplication detection capability.
Solution Approach 2:
The patent creates a simplified copy of the data structure that contains only the essential elements needed for ID duplication checking. Instead of working with the complete model tree, it generates a lightweight representation that preserves ID information and positional relationships, enabling efficient memory usage during the conversion process.
2Reliability
If a new ID is generated and sequentially traced through the model tree to check for duplication, then ID uniqueness is ensured, but the conversion process time increases due to repeated tracing operations
Solution Approach 1:
The patent performs preliminary organization of ID information by creating a list that records all ID values and their positions before the actual conversion process. This pre-processing step enables rapid duplication checking during conversion without requiring repeated sequential tracing through the model tree, significantly reducing conversion time while ensuring ID uniqueness.
Solution Approach 2:
The patent implements a dynamic ID management approach where the system adaptively handles ID generation and duplication checking. When a new ID is generated, the system efficiently checks for duplication using the pre-prepared ID list and dynamically adjusts by modifying the new ID if duplication is detected, optimizing the balance between ID uniqueness and conversion speed.
Data Source
Figure 1
Figure 2
Figure 3~4
AI summary
A conversion apparatus 1 can suppress the memory capacity needed to perform duplication check on an id associated with format converted data, when converting a format of a plurality of pieces of data included in a pre-conversion file 21, by generating (S300) a post-conversion file 22 that includes a plurality of pieces of format converted data by associating, when an id is associated with pre-format-conversion data, the id with format converted data and associating, when the id is not associated, a newly generated id with the format converted data; by judging (S310), by referring to a conversion information list 23 between the id associated with each of the plurality of pieces of data included in the post-conversion file 22 and a position of each of the ids in the post-conversion file 22, whether one of the ids is associated with a plurality of positions in the post-conversion file 22; and by changing (S320), when one of the ids is associated with the plurality of positions in the post-conversion file 22, the id associated with one of the pieces of data at the plurality of positions.