Automated View Generation for Archived Business Data
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, allowing for auto-generated export programs and views that account for customized table fields, enabling efficient data transfer and access without omitting custom data, by selecting standard business objects, parsing associated database tables, and generating user interfaces using HTML5 and JavaScript.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of manufacture
If standard views are reused to access archived data, then implementation cost is reduced, but custom data is lost
Solution Approach 1:
The patent introduces an automatic view generation system that acts as an intermediary between the archived data and standard views. This system automatically analyzes the archived data structure, identifies custom fields, and generates customized views without manual intervention, thereby preserving custom data while avoiding the high costs of manual view engineering
Solution Approach 2:
The view generation system operates autonomously by automatically detecting custom fields in archived tables, generating appropriate view definitions, and creating user interfaces without requiring manual configuration. This self-service capability eliminates the need for expensive manual customization while preserving all custom data elements
2Loss of information
If custom export programs and views are manually engineered, then custom data is preserved, but implementation time and labor increase
Solution Approach 1:
The system automatically performs all tasks previously requiring manual engineering: it detects custom fields in archived tables, generates view definitions, creates export programs, and builds user interfaces. This automation preserves custom data while reducing implementation time from weeks to minutes
Solution Approach 2:
The patent replaces the manual mechanical process of view engineering with an automated computer-based system that uses algorithms to analyze data structures, generate view definitions, and create user interfaces, thereby eliminating manual labor while preserving custom data
3Loss of time
If custom views are generated automatically, then implementation time is reduced, but complexity of the generation system increases
Solution Approach 1:
The patent creates a universal view generation system that handles multiple types of archived data, various custom field configurations, and different user interface requirements through a single automated platform. This multi-functional system reduces implementation time across diverse scenarios while managing complexity through standardized processes
Data Source
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.