Categorical Data Encoding for IT Operational Records

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current systems face challenges in processing, storing, and analyzing vast amounts of data associated with information technology operational activities, particularly in evaluating interdependencies and technical language processing, leading to inefficiencies in data storage and retrieval.

Innovation Solution

A computerized system that performs operational data processing, technical language processing, categorical data encoding, and dynamic data decoding to evaluate interdependencies, reduce storage requirements, and enhance data retrieval efficiency by transforming descriptive data into binary values and encoding records for compression.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Quantity of substance

If existing systems store and process massive amounts of IT operational data using traditional methods, then data completeness is maintained, but memory requirements and processing time become excessively large

Engineering Contradiction:
Improvedata storage capacityVSAvoidmemory requirements
Core Design Contradiction:
Quantity of substanceVSDevice complexity

Solution Approach 1:

The patent applies parameter changes by transforming categorical data from descriptive text format into encoded numerical representations. The system identifies categorical fields in IT operational data, determines the number of unique categories for each field, and encodes categories as integers from 0 to n-1. This parameter transformation dramatically reduces memory requirements while preserving data integrity and enabling efficient processing.

Inventive Principle:
Principle #35Parameter changes

Solution Approach 2:

The patent creates simplified copies of the original data by generating encoded representations that capture the essential categorical information without storing the full descriptive text. The encoding process creates a compact copy of categorical data that can be stored and processed more efficiently while maintaining the ability to retrieve and interpret the original information when needed.

Inventive Principle:
Principle #26Copying

2Productivity

If existing systems process and analyze vast amounts of IT operational data, then comprehensive analysis is achieved, but processing time increases significantly

Engineering Contradiction:
Improvedata analysis capabilityVSAvoidprocessing time
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The patent reduces processing time by changing the parameter representation of categorical data from text strings to numerical codes. This transformation enables faster comparison, filtering, and aggregation operations during data analysis. The encoded numerical format allows for more efficient computational operations while maintaining the ability to perform comprehensive analysis of IT operational data.

Inventive Principle:
Principle #35Parameter changes

Solution Approach 2:

The patent segments the data processing task into distinct phases: identifying categorical fields, determining category counts, encoding categories as integers, and storing the encoded data. This segmentation allows each phase to be optimized independently and enables parallel processing of multiple categorical fields, thereby reducing overall processing time for comprehensive data analysis.

Inventive Principle:
Principle #1Segmentation

3Ease of operation

If traditional data storage methods are used for IT operational records, then data retrieval is straightforward, but storage efficiency is poor

Engineering Contradiction:
Improvedata retrieval simplicityVSAvoidstorage efficiency
Core Design Contradiction:
Ease of operationVSQuantity of substance

Solution Approach 1:

The patent improves storage efficiency by changing the parameter format of categorical data from verbose text descriptions to compact numerical encodings. The system stores the mapping between category names and encoded integers in a reference structure, allowing efficient retrieval by storing only the encoded values in the main dataset. This approach maintains ease of operation through the reference mapping while achieving significant storage efficiency improvements.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS10275182B2System for categorical data encoding
Publication Date: 2019.04.30 BANK OF AMERICA CORP
  • US10275182B2 patent drawing
  • US10275182B2 patent drawing
  • US10275182B2 patent drawing

AI summary

Embodiments of the present invention relate to apparatuses, systems, methods and computer program products for a technology configuration system. Specifically, the system typically provides operational data processing of a plurality of records associated with information technology operational activities, for dynamic transformation of data and evaluation of interdependencies of technology resources. In other aspects, the system typically provides technical language processing of the plurality of records for transforming technical and descriptive data, and constructing categorical activity records. The system may be configured to achieve significant reduction in memory storage and processing requirements by performing categorical data encoding of the plurality of records. The system may employ a dynamic categorical data decoding process, which delivers a reduction in processing time when the encoded records are decoded for evaluating the exposure of technology change events to technology incidents and modifying such technology change events.