Dynamic Attribute Table Runtime Hive Integration

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing systems lack efficient methods for generating attribute tables and aggregating customer profile data in real-time, especially during business plan approval processes, and for dynamically appending Hive record columnar variables, which hinders timely business decision-making and data utilization.

Innovation Solution

The system automates the generation of attribute tables and workflow for aggregating customer profile data, utilizing a computer-assisted retrieval engine to create database tables that can dynamically append Hive record columnar variables during runtime, reducing manual intervention and enabling real-time data aggregation and storage.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If attribute tables are manually created and maintained for data aggregation, then data organization is achieved, but development time and manual intervention increase

Engineering Contradiction:

Improvedata aggregation speedVSAvoiddevelopment time

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The system pre-generates attribute tables and data aggregation workflows automatically during the business plan approval process, before actual data collection begins. This preliminary automated setup eliminates the need for manual table creation and configuration later, significantly reducing development time while maintaining organized data structures for efficient aggregation.

Inventive Principle:

Principle #10Preliminary action

2Adaptability or versatility

If static data tables are used for storing customer profile data, then data storage is achieved, but real-time data aggregation and flexibility are hindered

Engineering Contradiction:

Improvedata study flexibilityVSAvoidreal-time data availability

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The system implements dynamic attribute tables that can be automatically modified and updated during runtime based on business plan requirements. These tables are generated on-demand and can adapt to changing data aggregation needs, enabling both real-time data availability and flexible data studies without requiring static, pre-defined structures.

Inventive Principle:

Principle #15Dynamics

3Loss of information

If comprehensive customer profile data is collected and stored, then data analysis capability is improved, but system complexity and processing overhead increase

Engineering Contradiction:

Improvecustomer profile data completenessVSAvoidsystem complexity

Core Design Contradiction:

Loss of informationVSDevice complexity

Solution Approach 1:

The system segments customer profile data into organized attribute tables with specific data types and structures. By dividing comprehensive customer data into manageable, categorized attributes, the system maintains complete information for thorough analysis while reducing processing complexity through structured organization and targeted data retrieval.

Inventive Principle:

Principle #1Segmentation

Data Source

PatentUS10346769B1System and method for dynamic attribute table

Publication Date: 2019.07.09 WALMART APOLLO LLC

AI summary

The present disclosure extends to methods, systems, and computer program products for generating attribute tables for holding attributes and modifying the table structure during run time by appending the record column file corresponding to the attribute table.