View Generator for Archived Business Data

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing methods for generating views to access archived business data either result in data loss due to reusing standard views or incur high implementation costs from manually engineering custom export programs and user interfaces, making the process cumbersome and laborious.

Innovation Solution

A system that uses a standard object model to define relationships between tables, enabling auto-generated export programs and view-generating programs to account for customized table fields, allowing for seamless data transfer and view generation with minimal user interaction, while maintaining custom data integrity.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of manufacture

If standard views are reused to access archived data, then implementation cost is reduced, but custom data is lost

Engineering Contradiction:

Improveimplementation costVSAvoidcustom data

Core Design Contradiction:

Ease of manufactureVSLoss of information

Solution Approach 1:

The patent introduces an intermediary layer consisting of mapping files and transformation logic between the archive database and the view generation system. This intermediary captures custom field definitions and table structures, allowing standard view generation mechanisms to access customized data through automated mapping, thus preventing data loss while maintaining ease of implementation

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The system dynamically changes parameters by automatically detecting custom fields and tables in the archive database, then generating appropriate view definitions and mapping configurations. This parameter adaptation allows the system to handle customized data structures without manual intervention, resolving the contradiction between using standard processes and preserving custom data

Inventive Principle:

Principle #35Parameter changes

2Reliability

If custom export programs and views are manually engineered, then custom data integrity is preserved, but implementation cost and labor increase

Engineering Contradiction:

Improvecustom data integrityVSAvoidimplementation cost

Core Design Contradiction:

ReliabilityVSEase of manufacture

Solution Approach 1:

The patent implements a self-service mechanism where the view generation system automatically connects to the archive database, detects custom fields and tables, and generates appropriate views and mapping files without requiring manual engineering. This automation preserves custom data integrity while eliminating the high implementation costs and labor associated with manual customization

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system performs preliminary actions by pre-generating mapping files and view definitions based on automated analysis of the archive database structure. This preliminary automation captures all custom fields and relationships before view generation, ensuring data integrity is preserved without requiring subsequent manual customization efforts

Inventive Principle:

Principle #10Preliminary action

3Loss of information

If manual view generation is used, then custom fields are preserved, but the process becomes cumbersome and laborious

Engineering Contradiction:

Improvecustom fieldsVSAvoidimplementation time

Core Design Contradiction:

Loss of informationVSLoss of time

Solution Approach 1:

The patent replaces the mechanical manual process of view generation with an automated computer-based system that connects to the archive database, parses table structures, detects custom fields, and generates views automatically. This substitution eliminates the cumbersome manual process while preserving all custom fields through automated detection and mapping

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS20220207061A1Technique for generating views of archived business data

Publication Date: 2022.06.30 BUSINESS MOBILE AG

AI summary

An apparatus, a method and a non-transitory computer readable medium are described herein related to generating views for archived business objects. The views display query results which are retrieved from a relational database for archived business data. The views are generated with a view generator which makes use of both a catalog, a standard business object and a business object parser which may detect differences in terms of field names and foreign-key relationships between a standard business object and a customer-enhanced business object. The combination of standard business objects with a business object parser enables the re-use of components from a standard library of business objects across various clients without resulting data loss, especially when there are client-specific deviations from the standard model of business objects.