Regular Expression Generator Using Longest Common Subsequence

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current data formatting and preprocessing methods for big data analytics are inefficient, especially for large-scale datasets, as they often rely on manual and ad hoc processes, leading to inaccurate results due to poor signal-to-noise ratios and handling of structured, semi-structured, and unstructured data.

Innovation Solution

A data processing system that generates regular expressions using a longest common subsequence algorithm to identify patterns in input data, allowing for automated data formatting and extraction, while also handling positive and negative examples to minimize false positives and negatives.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If manual and ad hoc processes are used for data formatting and preprocessing, then flexibility and adaptability are maintained, but efficiency and productivity deteriorate significantly for large-scale datasets

Engineering Contradiction:
Improvedata preprocessing efficiencyVSAvoidmanual process complexity
Core Design Contradiction:
ProductivityVSEase of operation

Solution Approach 1:

The system automatically generates regular expressions by analyzing sample data patterns without requiring manual intervention. The algorithm self-learns from provided examples and produces ready-to-use regex patterns, enabling the system to serve itself in the data formatting task.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

Manual mechanical processes of data formatting are replaced with an automated algorithmic system that uses longest common subsequence analysis to generate regular expressions, substituting human effort with computational automation.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Productivity

If automated regular expression generation is implemented, then productivity and speed are improved, but the complexity of the processing system increases

Engineering Contradiction:
Improvedata analysis speedVSAvoidsystem complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The system introduces an intermediary algorithm that bridges raw data and regular expressions. This longest common subsequence algorithm acts as a mediator that automatically translates sample data patterns into executable regex patterns, simplifying the overall system architecture.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The data preprocessing task is segmented into distinct phases: sample data collection, pattern analysis through LCS algorithm, and regular expression generation. This segmentation allows each component to be independently optimized and managed.

Inventive Principle:
Principle #1Segmentation

3Measurement precision

If manual data formatting processes are used, then system complexity remains low, but measurement precision and data accuracy deteriorate due to poor signal-to-noise ratios

Engineering Contradiction:
Improvedata extraction accuracyVSAvoidprocessing system complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The system uses feedback from sample data to continuously improve regular expression generation. By analyzing provided examples and their expected matches, the algorithm learns patterns and adjusts its output to achieve higher precision in data extraction.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The system performs preliminary analysis of sample data before actual data processing. By pre-generating regular expressions from representative samples, the system prepares accurate extraction patterns in advance, improving measurement precision during the main processing phase.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS11354305B2User interface commands for regular expression generation
Publication Date: 2022.06.07 ORACLE INT CORP
  • US11354305B2 patent drawing
  • US11354305B2 patent drawing
  • US11354305B2 patent drawing

AI summary

Techniques for generated regular expressions are disclosed. In some embodiments, a regular expression generator may receive input data comprising one or more character sequences. The regular expression generator may convert character sequences into a sets of regular expression codes and/or span data structures. The regular expression generator may identify a longest common subsequence shared by the sets of regular expression codes and/or spans, and may generate a regular expression based upon the longest common subsequence. Generation of the regular expressions can be implemented on an interactive user interface. Commands can be applied to the one or more character sequences and regular expressions are generated based on the applied commands.