XBRL Evaluation Program Normalizes Financial Data Strings

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

The processing load for evaluating records in input-completed sheets is increased when the character strings in financial statements submitted in XBRL format are changed, leading to inconsistencies and errors during conversion to XBRL instances.

Innovation Solution

An evaluation program that normalizes and compares character strings in input-completed sheets with those defined in the mapping definition, determining whether item values satisfy conditions to evaluate records efficiently, thereby reducing processing time and load.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If character strings in financial statements are changed, then adaptability to different descriptions is improved, but processing load increases and errors occur

Engineering Contradiction:
Improveadaptability to description changesVSAvoidprocessing load
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent applies preliminary action by pre-defining mapping definitions that associate XBRL items with multiple possible character string variations. Before actual conversion occurs, the system prepares a mapping framework that anticipates different description forms, allowing it to handle character string changes without increasing processing load during conversion. The mapping definition is created in advance to include various acceptable descriptions for each XBRL item.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent applies parameter changes by transforming character strings into a normalized form through the mapping definition. Instead of processing raw character strings directly, the system converts them into standardized XBRL item references, changing the parameter from variable text descriptions to fixed structured data. This parameter transformation reduces processing complexity while maintaining adaptability to different original descriptions.

Inventive Principle:
Principle #35Parameter changes

2Loss of time

If character strings are normalized and compared, then processing time is reduced, but measurement precision of original descriptions may be lost

Engineering Contradiction:
Improveprocessing timeVSAvoiddescription variability
Core Design Contradiction:
Loss of timeVSLoss of information

Solution Approach 1:

The patent applies copying by creating a mapping definition that preserves the relationship between original character strings and XBRL items. Instead of losing original description information, the system creates a reference copy that maps various character string forms to their corresponding XBRL items. This copying mechanism allows fast processing through normalization while retaining the ability to trace back to original descriptions if needed.

Inventive Principle:
Principle #26Copying

Solution Approach 2:

The patent applies intermediary by introducing the mapping definition as a mediating layer between original character strings and XBRL items. The mapping definition serves as an intermediary structure that enables efficient comparison and processing through normalization, while simultaneously preserving the connection to original descriptions. This intermediary layer resolves the conflict between processing speed and information retention.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Reliability

If evaluation is performed on all records, then reliability of conversion is improved, but productivity decreases

Engineering Contradiction:
Improveconversion accuracyVSAvoidconversion speed
Core Design Contradiction:
ReliabilityVSProductivity

Solution Approach 1:

The patent applies segmentation by dividing the evaluation process into two distinct phases: a comprehensive evaluation phase during mapping definition creation, and a streamlined evaluation phase during actual conversion. The mapping definition is created with complete evaluation rules in advance, then reused during conversion without repeating full evaluation. This segmentation allows thorough reliability checking when creating the mapping while maintaining high productivity during subsequent conversions.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent applies preliminary action by performing complete evaluation and creating the mapping definition before actual conversion operations. All complex evaluation logic is executed in advance when building the mapping definition, so that subsequent conversions can rely on the pre-established mapping without repeating intensive evaluation. This preliminary action ensures conversion reliability while enabling fast processing during actual use.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS11687867B2Computer-readable recording medium recording evaluation program, information processing apparatus, and evaluation method
Publication Date: 2023.06.27 FUJITSU LTD
  • US11687867B2 patent drawing
  • US11687867B2 patent drawing
  • US11687867B2 patent drawing

AI summary

A non-transitory computer-readable recording medium records an evaluation program for causing a computer to execute processing including: acquiring a record group that includes a plurality of ordered records and includes a plurality of item values in which each record is associated with each of a plurality of items; specifying a first record and a second record associated with order having a predetermined relationship with order associated with the first record from among records included in the acquired record group; determining whether or not an item value associated with a second item included in the first record satisfies a condition in a case where an item value associated with the first item among item values included in the first record is different from an item value associated with the first item among item values included in the second record; and evaluating the first record on the basis of the determination result.