Master Control Table for Dynamic Domain Data Management

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing systems for modifying large numbers of domain data tables are inefficient and prone to inaccuracies, requiring excessive system resources and hard-coded changes to user interfaces.

Innovation Solution

A master control table is generated that aggregates data from multiple domain data tables, allowing users to dynamically modify domain data and user interfaces without directly accessing individual tables, through a user interface with two portions: one listing available tables and another for displaying and editing selected table data and configurations.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If existing data tables are modified directly to implement changes, then the user interface can be updated, but the system requires excessive resources and is prone to inaccuracies

Engineering Contradiction:
Improveease of modifying data tablesVSAvoidaccuracy of data table modifications
Core Design Contradiction:
Ease of operationVSReliability

Solution Approach 1:

The patent introduces a master control table as an intermediary between users and the actual domain data tables. Users modify data in the master control table, which then automatically propagates changes to the underlying domain data tables. This intermediary layer eliminates the need for users to directly access and modify multiple domain data tables, thereby reducing errors and improving reliability while maintaining ease of operation.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Quantity of substance

If multiple domain data tables are created and maintained separately, then data can be stored and accessed, but the system becomes inefficient and resource-intensive

Engineering Contradiction:
Improvenumber of data tablesVSAvoidefficiency of data table management
Core Design Contradiction:
Quantity of substanceVSProductivity

Solution Approach 1:

The patent merges the functionality of multiple domain data tables into a single master control table. Instead of maintaining separate domain data tables for different purposes, the master control table consolidates all data and configuration information in one centralized location. This reduces the total number of tables the system must manage, thereby improving productivity and reducing resource consumption while still providing access to all necessary data.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The master control table serves multiple functions simultaneously: it stores domain data, manages configurations, controls user interface generation, and propagates changes to underlying data tables. This multi-functional approach eliminates the need for separate specialized tables for each function, improving efficiency by reducing the quantity of data tables while maintaining full operational capability.

Inventive Principle:
Principle #6Universality (Multi-functionality)

3Adaptability or versatility

If hard-coded changes are made to user interfaces, then the interface can be updated, but the system loses adaptability and requires excessive modifications

Engineering Contradiction:
Improveflexibility of user interfaceVSAvoidcomplexity of interface modifications
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements a dynamic user interface system where the interface is generated automatically based on data from the master control table. Instead of hard-coding interface elements, the system dynamically creates interface components by reading configuration data and domain data from the master control table. This allows the interface to adapt flexibly to different data sets and configurations without requiring hard-coded changes, thereby improving adaptability while reducing the complexity of interface modifications.

Inventive Principle:
Principle #15Dynamics

Data Source

PatentUS10255260B2System and framework for transforming domain data
Publication Date: 2019.04.09 BANK OF AMERICA CORP
  • US10255260B2 patent drawing
  • US10255260B2 patent drawing
  • US10255260B2 patent drawing

AI summary

Methods, systems, and computer-readable media for transforming or modifying domain data are provided. A master control table may be generating including data from a plurality of domain data tables and a configuration associated with each domain data table. A user may modify a domain data table (or associated domain data) via the master control table. A user interface may be generated having a first portion, listing domain data tables in the master control table, and a second portion. Upon selection of a domain data table from the first portion, the second portion may be populated with the data and associated configuration of the selected domain data table. Modifications to the domain data table (and/or domain data) may be made via the second portion.