Time-Series Featurization Using Star Schema and Temporal Patterns

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Traditional methods of featurization for time-series data face challenges in handling the complexity, volume, and dynamic nature of transaction data, failing to adequately capture temporal dependencies and relationships, leading to issues with high dimensionality, noise, and limited integration of domain-specific knowledge, which affects the accuracy and adaptability of machine learning models.

Innovation Solution

A systematic approach involving data mining techniques for categorization and tagging, using ML models and pattern recognition to preprocess time-series data, transforming it into a star schema format, and generating features that capture temporal and contextual nuances, thereby improving model accuracy and adaptability.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If traditional featurization methods are used for time-series data, then the process is simple, but the ability to capture temporal dependencies and relationships is insufficient

Engineering Contradiction:
Improveability to capture temporal dependenciesVSAvoidfeaturization process complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The featurization process is segmented into multiple specialized modules: temporal feature extraction module, contextual feature extraction module, statistical feature extraction module, and transformation module. Each module handles specific aspects of feature generation, allowing complex temporal dependencies to be captured through coordinated operation of specialized components rather than a single monolithic process

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system performs preliminary data preprocessing and exploration before formal featurization, including identifying temporal patterns, contextual relationships, and statistical properties. This preliminary analysis informs the subsequent feature generation process, enabling more accurate capture of temporal dependencies while avoiding redundant computations

Inventive Principle:
Principle #10Preliminary action

2Quantity of substance

If traditional featurization methods are used, then computational resources are conserved, but the handling of data complexity and volume is insufficient

Engineering Contradiction:
Improvedata volume handling capabilityVSAvoidcomputational resource consumption
Core Design Contradiction:
Quantity of substanceVSUse of energy by moving object

Solution Approach 1:

The system extracts only the most relevant features from large volumes of time-series data through selective feature generation based on data characteristics and model requirements. By extracting only essential temporal, contextual, and statistical features rather than processing all possible combinations, the system handles large data volumes efficiently while consuming reasonable computational resources

Inventive Principle:
Principle #2Taking out (Extraction)

Solution Approach 2:

The system dynamically adjusts feature generation parameters based on data characteristics, including selecting which feature types to generate, adjusting feature granularity, and modifying transformation operations. This adaptive parameter adjustment allows the system to scale feature extraction to match data volume and complexity while optimizing computational resource utilization

Inventive Principle:
Principle #35Parameter changes

3Adaptability or versatility

If traditional featurization methods are used, then processing speed is maintained, but the integration of domain-specific knowledge is limited

Engineering Contradiction:
Improveintegration of domain-specific knowledgeVSAvoidfeature generation efficiency
Core Design Contradiction:
Adaptability or versatilityVSProductivity

Solution Approach 1:

The system introduces domain knowledge as an intermediary layer between raw data and feature generation. Domain-specific rules, constraints, and expertise are encoded as preprocessing steps and feature transformation operations that guide the extraction process. This intermediary layer enables sophisticated integration of domain knowledge while maintaining efficient feature generation through automated processing pipelines

Inventive Principle:
Principle #24Intermediary (Mediator)

4Measurement precision

If traditional featurization methods are used, then the feature set is manageable in size, but the accuracy and adaptability of machine learning models is reduced

Engineering Contradiction:
Improvemachine learning model accuracyVSAvoidfeature set size
Core Design Contradiction:
Measurement precisionVSQuantity of substance

Solution Approach 1:

The system generates a comprehensive set of features including temporal, contextual, statistical, and transformed features that may exceed the minimum required for model training. This excessive feature generation ensures that all potentially useful information is available, allowing the machine learning model to select the most relevant features during training, thereby improving accuracy while managing feature set size through model-based selection

Inventive Principle:
Principle #16Partial or excessive action

Data Source

PatentUS12541719B1Time-series data featurization
Publication Date: 2026.02.03 INTUIT INC
  • US12541719B1 patent drawing
  • US12541719B1 patent drawing
  • US12541719B1 patent drawing

AI summary

The present disclosure relates to methods, systems, and apparatuses for featurizing time-series data to enhance machine learning model training. Time-series data, such as transaction records, is preprocessed to identify fields including descriptive and categorical information. Categories are assigned using a first machine learning model, and tags are applied based on domain-specific patterns or large language models. The processed data is organized into a star schema data structure comprising a fact structure and associated dimension structures. Features are generated from the data structure based on time windows, incorporating statistical metrics and identified patterns. These features are provided to a machine learning module to train a second machine learning model, improving accuracy and adaptability for applications such as customer behavior prediction and financial analysis. The disclosed approach addresses challenges of high dimensionality, noise, and temporal dependencies in time-series data, enabling robust and contextually relevant feature generation.