Load and dump as a single function
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.
1 . 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.
2 . The method of claim 1 , wherein:
transforming the first set of backup data comprises decompressing the first set of backup data; and
storing the set of transformed data as the second set of backup data comprises compressing the set of transformed data.
3 . The method of claim 1 , wherein the first set of back up data is transformed into the set of transformed data, and the set of operations are automatically executed based on receiving an input from a user.
4 . The method of claim 1 , wherein transforming the first set of backup data into the set of transformed data comprises encrypting the first set of backup data.
5 . The method of claim 1 , wherein transforming the first set of backup data into the set of transformed data comprises transforming integer data to Boolean data.
6 . The method of claim 1 , wherein the request to load comprises a request to recover the database to a previous state.
7 . 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.
8 . The system of claim 7 , wherein:
transforming the first set of database log data comprises decompressing the first set of database log data; and
storing the set of transformed database log data in the second set of database log data comprises compressing the set of transformed database log data.
9 . The system of claim 7 , wherein the first set of database log data is transformed into the set of transformed database log data, and the set of operations are automatically executed based on receiving an input from a user.
10 . The system of claim 7 , wherein transforming the first set of database log data into the set of transformed database log data comprises encrypting the first set of database log data.
11 . The system of claim 7 , wherein transforming the first set of database log data into the set of transformed database log data comprises transforming integer data to Boolean data.
12 . The system of claim 7 , wherein the request to recover comprises a request to restore the database to a previous state.
13 . 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.
14 . The media of claim 13 , wherein:
transforming the first set of backup data comprises decompressing the first the first set of backup data; and
storing the set of transformed data in the second set of backup data comprises compressing the transformed data.
15 . The media of claim 13 , wherein the first set of backup data is transformed into the set of transformed data, and the set of operations are automatically executed based on receiving an input from a user.
16 . The media of claim 13 , wherein transforming the first set of backup data into the set of transformed data comprises encrypting the first set of backup data.
17 . The media of claim 13 , wherein transforming the first set of backup data into the set of transformed data comprises transforming integer data to Boolean data.