US 2022/0066983 A1 · SYSTEM AND METHOD FOR THE AUTOMATED SCHEDULING AND RETRIEVAL OF ARCHIVED DATA

Abstract

A system and method for scheduling archival of enterprise relevant data and retrieving archived data on enterprise and organizational data archives. The archive scheduling system includes a computerized method of creating all ERP system variants identically except for date selections to insure mutually exclusive data ranges and enables the automated simultaneous processing and completion of archival tasks using parallel computing. The archive access and data retrieval system includes pre-request processing and customization to validate each request, validate each request's corresponding Infostructure, perform advance hashing to more closely determine relevant tables for the request, and to determine which method of file reading will most efficiently return results. The access and retrieval method is phased to fulfill a mediated request for access and/or retrieval in a resource and time efficient manner alone or in combination of phases.

Claims20

Dependent claims

A data archival database management system for automatically archiving an active database stored on an at least one first computing device to an at least one second computing device, the system comprising:

the at least one first computing device having a first connection to a network, a first processor, a first memory, and a first non-transitory computer readable medium having said active database stored thereon;
the at least one second computing device having a second connection to said network, a second processor, a second memory, and a second non-transitory computer readable medium capable of storing a data archival store;
and
an enterprise resource planning (ERP) system having an at least one variant list installed thereon said first non-transitory computer readable medium, said ERP system is configured to:
receive a user entry via said network from a user device connected to said network, said user entry contains a date range corresponding to a proposed data archive;
determine a period of time within said date range to divide said date range into a series of periods of time, each of said series of periods of time are associated with a mutually-exclusive data subset;
create a series of variants, each looped at each of said series of periods of time;
ensure mutual-exclusivity of each of said series of variants;
add said series of variants to said at least one variant list;
and
processing a series of archival jobs, each of said series of archival jobs is associated with one of said series of variants.

8 more elements

A data archival database management method to automatically archive an active database stored on an at least one first computing device to an at least one second computing device, each of said at least one first computing device and said at least one second computing device having a processor, a memory, a non-transitory computer readable medium, a connection to a network, and access to an Enterprise Resource Planning system having an at least one variant list, the method comprising the steps of:

receiving, from a user device connected to said network, a date range corresponding to a proposed data archive via said network;
determining a period of time within said date range to divide said date range into a series of periods of time, each of said series of periods of time are associated with a mutually-exclusive data subset;
creating a series of variants, each looped at each of said series of periods of time;
ensuring mutual-exclusivity of each of said series of variants;
adding said series of variants to said at least one variant list;
and
processing a series of archival jobs, each of said series of archival jobs is associated with one of said series of variants.

4 more elements

A system for an automatic archival of an active database, the system comprising:

a plurality of computing devices, said plurality of computing devices having a processor, a memory, a non-transitory computer-readable medium, and a connection to a network;
installed thereon an at least one of said plurality computing devices is an Enterprise Resource Planning (ERP) system having a data archival feature, the remaining of said plurality of computing devices having access to said ERP system via said network;
and
the ERP system and the data archival feature are capable of scheduling the automatic archival of said active database according to the following steps:
receiving, from a user device connected to said network, a date range corresponding to a proposed data archive via said network;
determining a period of time within said date range to divide said date range into a series of periods of time, each of said series of periods of time are associated with a mutually-exclusive data subset;
creating a series of variants, each looped at each of said series of periods of time;
ensuring mutual-exclusivity of each of said series of variants;
adding said series of variants to said at least one variant list;
and
processing a series of archival jobs, each of said series of archival jobs is associated with one of said series of variants.

8 more elements

Dependencies are inferred from the claim text.

System and method for the automated scheduling and retrieval of archived data

Life of this patent

System and method for the automated scheduling and retrieval of archived data

Life of this patent

Abstract

Claims20