Automated Database Load Back via Dynamic Subroutine Pool

Solution Overview

Problem

Conventional techniques for reloading archived data into database systems are resource-intensive and prone to errors due to the need for manual creation of load back reports for each different archiving object, which are freely customizable.

Innovation Solution

A system dynamically generates a subroutine pool to create internal tables and populate them based on the structure of the archiving object, allowing for automated reloading of archived data without manual intervention.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If manual creation of load back reports is performed for each archiving object, then the data reloading process can be completed, but significant resources are consumed and errors are prone to occur

Engineering Contradiction:

Improveerror rateVSAvoidresource consumption

Core Design Contradiction:

ReliabilityVSProductivity

Solution Approach 1:

The system performs self-service by automatically generating load back reports based on archiving object definitions stored in the database. The database management system itself retrieves the necessary archiving object data and creates the appropriate reports without requiring external manual intervention, thereby reducing both resource consumption and error rates.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The manual mechanical process of creating load back reports is replaced by an automated information processing system. The database management system uses stored program instructions to automatically retrieve archiving object definitions and generate the corresponding load back reports, substituting human manual operations with automated computational processes.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

2Ease of operation

If manual creation of load back reports is performed for each different archiving object, then the data reloading can be controlled, but significant time and effort are consumed

Engineering Contradiction:

Improveautomation levelVSAvoidtime consumption

Core Design Contradiction:

Ease of operationVSLoss of time

Solution Approach 1:

The system performs preliminary action by storing the complete definitions of archiving objects, including table structures and loading preferences, within the database management system in advance. When a load back operation is needed, the system simply retrieves these pre-stored definitions and automatically generates the appropriate reports, eliminating the need for time-consuming manual creation processes.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The manual mechanical process of creating load back reports is replaced by an automated information processing system. The database management system uses stored program instructions to automatically retrieve archiving object definitions and generate the corresponding load back reports, substituting human manual operations with automated computational processes.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

3Adaptability or versatility

If archiving objects are freely customized and configured, then the system is adaptable to different data structures, but a new load back report must be manually created for each different archiving object

Engineering Contradiction:

Improvecustomization capabilityVSAvoidprocess complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The database management system implements a universal solution by storing the definitions of all archiving objects within the database itself. A single automated process can retrieve any archiving object definition and generate the appropriate load back report, making the system adaptable to different data structures without requiring separate manual procedures for each case.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The manual mechanical process of creating load back reports is replaced by an automated information processing system. The database management system uses stored program instructions to automatically retrieve archiving object definitions and generate the corresponding load back reports, substituting human manual operations with automated computational processes.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS10303651B2Load back of archived data

Publication Date: 2019.05.28 SAP SE

AI summary

A system includes reception of an instruction to load data associated with an archiving object and an archiving session into a database system, determination of an archive file associated with the archiving object and the archiving session, determination of one or more database tables of the database system and fields of the one or more database tables associated with the archive file, automatic generation of processor-executable code of a subroutine pool based on the fields of the one or more database tables, and execution of the processor-executable code of the subroutine pool to read one or more data objects of the archive file, populate one or more internal tables based on records of the one or more data objects, and insert the one or more internal tables into corresponding ones of the one or more database tables of the database system.