Load and dump as a single function
AssigneeUnisys Corporation
InventorsEllen L. Sorenson, Kelsey L. Bruso
Life of this patent
Estimating the term…
Abstract
Embodiments of the present disclosure include systems and methods for optimizing functions of a database system. A combination load and dump function is recited that transforms a first set of backup data into a set of transformed data, where the first set of backup data is accessed in response to receiving a request to load the first set of backup data to the database. A set of operations is automatically executed and includes loading the database with the set of transformed data and storing the set of transformed data in a second set of backup data. This combination load and dump function removes the need for a subsequent read function to read data previously loaded to a database file in order to perform the dump function.
Claims17
A method comprising:
- receiving, by a processor, a request to load a database;
- determining, by the processor, a first set of backup data to load to the database;
- transforming, by the processor, the first set of backup data into a set of transformed data;
- and
- automatically executing, by the processor, a set of operations that load the database with the set of transformed data and store the set of transformed data as a second set of backup data thereby creating a new backup file without reading the set of transformed data from the database after loading and freeing up cache memory resource for other database operations.
A system comprising:
- a processing device coupled to a memory component, the memory component having instructions stored thereon that cause the processing device to perform operations comprising:
- transforming a first set of database log data into a set of transformed database log data, wherein the first set of database log data is accessed in response to a request to recover the database;
- and
- automatically executing a set of operations that load the database with the set of transformed database log data and store the set of transformed database log data as a second set of database log data thereby generating a new database log without reading the set of transformed database log data from the database after loading and freeing up cache memory resource for other database operations:
- load the database with the set of transformed database log data;
- and
- store the set of transformed database log data as a second set of database log data.
One or more computer storage media storing computer-readable instructions thereon that, when executed by a processor, cause the processor to perform a method, the method comprising:
- transforming a first set of backup data into a set of transformed data, wherein the first set of backup data is accessed in response to a request to load the first set of backup data to the database;
- and
- automatically executing a set of operations that load the database with the set of transformed data and store the set of transformed data as a second set of backup data thereby creating a new backup file without reading the set of transformed data from the database after loading and freeing up cache memory resource for other database operations.
Dependencies are inferred from the claim text.