Techniques for reducing backup read access in differential backup of databases

A non-transitory computer-readable medium storing instructions for reducing deduplication in database backup, wherein the instructions, when executed by one or more processors, cause the one or more processors to:

• select a first primary key of a database;
• extract a plurality of row groups from the database based on the selected first primary key;
• store the plurality of row groups arranged according to the first primary key in one or more files having a column-oriented data storage format as a database backup at a first time;
• read at least a portion of the database backup at a second time to detect a plurality of changes in the database;
• select a second primary key of the database as a primary key, when utilizing the second primary key generates a smaller number of row groups than utilizing the first primary key, wherein the smaller number of row groups includes a change in at least a row;
• and
• generate a database backup of the database at the second time based on the selected second primary key, wherein prior to generating the database backup at the second time, the one or more files of the database backup at the first time are rearranged based on the selected second primary key.

A system for reducing deduplication in database backup, the system comprising:

• one or more processors;
• and
• a memory storing instructions that, when executed by the one or more processors, cause the one or more processors to:
• select a first primary key of a database;
• extract a plurality of row groups from the database based on the selected first primary key;
• store the plurality of row groups arranged according to the first primary key in one or more files having a column-oriented data storage format as a database backup at a first time;
• read at least a portion of the database backup at a second time to detect a plurality of changes in the database;
• select a second primary key of the database as a primary key, when utilizing the second primary key generates a smaller number of row groups than utilizing the first primary key, wherein the smaller number of row groups includes a change in at least a row;
• and
• generate a database backup of the database at the second time based on the selected second primary key, wherein prior to generating the database backup at the second time, the one or more files of the database backup at the first time are rearranged based on the selected second primary key.