Unified View Management for Bitemporal ERP Data Correlation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current systems for managing and analyzing time-related data in ERP systems are complex and often confusing, particularly when dealing with bitemporal data, as they lack efficient methods for concurrent browsing and correlation discovery across separate data groups.

Innovation Solution

A database system with a view management module that standardizes access to multiple ERP systems, creating a unified timeline for historical data and data group views, allowing users to sort, browse, and edit entity data across different data groups, thereby facilitating the observation of time-based correlations.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If multiple separate ERP systems are used to manage different data groups, then data can be organized by functional areas, but users cannot efficiently browse and discover correlations across data groups concurrently

Engineering Contradiction:
Improvedata organization flexibilityVSAvoidconcurrent browsing efficiency
Core Design Contradiction:
Adaptability or versatilityVSEase of operation

Solution Approach 1:

The patent combines multiple separate ERP systems into a single unified ERP system that maintains separate data groups for different functional areas. This allows the system to preserve the organizational flexibility of separate systems while enabling concurrent browsing and correlation discovery across all data groups through a unified interface and shared timeline mechanism.

Inventive Principle:
Principle #5Merging (Combining)

2Measurement precision

If bitemporal data is managed with separate transaction time and valid time for each data group, then temporal accuracy is maintained, but data presentation becomes confusing and complex

Engineering Contradiction:
Improvetemporal data accuracyVSAvoiddata presentation complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The patent implements a universal timeline mechanism that serves multiple data groups simultaneously. This single timeline structure handles transaction times and valid times across all data groups, maintaining temporal accuracy for each while presenting a unified, simplified view that reduces presentation complexity and user confusion.

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

3Reliability

If users access separate ERP systems concurrently, then specialized data management is achieved, but trend and correlation discovery becomes difficult

Engineering Contradiction:
Improvespecialized data managementVSAvoidcorrelation information
Core Design Contradiction:
ReliabilityVSLoss of information

Solution Approach 1:

The patent merges multiple ERP systems into one unified system that preserves specialized data groups for reliable domain-specific management. The unified timeline and concurrent browsing capabilities enable users to view and analyze correlations across different data groups, preventing loss of correlation information that would occur when accessing separate systems independently.

Inventive Principle:
Principle #5Merging (Combining)

Data Source

PatentUS8078626B1Unified management of time related information
Publication Date: 2011.12.13 GOOGLE LLC
  • US8078626B1 patent drawing
  • US8078626B1 patent drawing
  • US8078626B1 patent drawing

AI summary

Unified management of time related information presents a user with a single interface by which the data in different ERP systems can be browsed and modified. Each of the ERP systems can contain data specific to a data group such as the address data group in a human resources ERP system, sales data in a sales ERP system, and project data in a project planning ERP system. A view management module obtains records from the ERP systems. The view manager also obtains journaling information that can be kept in the ERP systems or kept separately. The view manager creates a history view and data group views that can be presented to a user. The user interacts with the presentation to sort, browse, analyze, and edit the view and data. Data changed in a data group view can be forwarded to produce changes in the ERP and journaling systems.