File Wrapper Engine for CLOB Data Segmentation

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Large data objects exceeding size limits in front-end applications lead to inefficient access and retrieval due to physical separation, causing performance degradation and memory overflow issues.

Innovation Solution

A computing platform generates file wrappers for character large objects (CLOBs) by converting them into variable character fields (VARCHARs), allowing for dynamic SQL responses that prevent performance and memory overflow issues by handling data across multiple tables and embedding URLs for full data access.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Quantity of substance

If large data objects are stored in front end applications, then data storage capacity is improved, but data access efficiency deteriorates due to physical separation exceeding size limits

Engineering Contradiction:

Improvedata storage capacityVSAvoiddata access efficiency

Core Design Contradiction:

Quantity of substanceVSProductivity

Solution Approach 1:

The patent segments large CLOB data into smaller VARCHAR objects stored in file wrappers, with each wrapper containing a manageable portion of the original data. This segmentation allows the system to store large quantities of data while maintaining efficient access by processing smaller, divided units rather than monolithic large objects.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent introduces file wrappers as intermediary structures between the application and CLOB data. These wrappers contain VARCHAR objects that reference or contain portions of the original CLOB data, acting as a mediator that enables efficient access to large data objects without requiring the application to directly handle the entire large object at once.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Adaptability or versatility

If CLOB data is physically separated to exceed size limits, then storage flexibility is improved, but memory resources are overwhelmed causing overflow issues

Engineering Contradiction:

Improvestorage flexibilityVSAvoidmemory overflow

Core Design Contradiction:

Adaptability or versatilityVSObject-generated harmful factors

Solution Approach 1:

By dividing CLOB data into multiple VARCHAR objects within file wrappers, the system maintains storage flexibility for large data while preventing memory overflow. Each wrapper handles a manageable segment of data, ensuring that memory resources are not overwhelmed by attempting to load entire large objects into memory simultaneously.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent implements partial action by loading and processing only the necessary portions of CLOB data through VARCHAR objects in file wrappers, rather than loading entire large objects into memory. This approach provides storage flexibility for large datasets while avoiding memory overflow by processing data in controlled, partial increments.

Inventive Principle:

Principle #16Partial or excessive action

3Speed

If CLOB data is converted to VARCHAR objects in file wrappers, then data access speed is improved, but device complexity increases

Engineering Contradiction:

Improvedata access speedVSAvoidsystem complexity

Core Design Contradiction:

SpeedVSDevice complexity

Solution Approach 1:

The conversion of CLOB to VARCHAR objects in file wrappers segments data into accessible units, improving access speed by allowing direct querying of VARCHAR fields. The segmentation into wrappers provides a structured approach that manages the inherent complexity through organized, modular data units.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent creates VARCHAR object copies or representations of CLOB data within file wrappers. These VARCHAR copies enable fast SQL-based data access while the wrapper structure manages the complexity of the conversion process, allowing the system to benefit from speed improvements without directly managing the full complexity of CLOB manipulation.

Inventive Principle:

Principle #26Copying

Data Source

PatentUS11789947B2Independent object generator and wrapper engine

Publication Date: 2023.10.17 BANK OF AMERICA CORP

AI summary

Aspects of the disclosure relate to a data wrapper engine. A computing platform may receive a query comprising a request for data stored as a CLOB. The computing platform may obtain, from a data storage system, the data stored as a CLOB. The computing platform may generate a file wrapper for the data, wherein generating the file wrapper comprises converting the CLOB to a VARCHAR object and storing the VARCHAR object in the file wrapper. The computing platform may generate, using the VARCHAR object stored in the file wrapper, a SQL response to the query. The computing platform may execute the dynamic SQL response to generate a response to the query. The computing platform may send, to a user device, the response to the query and commands directing the user device to display the response to the query, which may cause the user device to display the response.