Backing up a database in multiple parts to multiple locations to improve timing

A method comprising the steps of:

• receiving a command to perform a full backup procedure in which data stored in a structured database managed by a Data Base Management System (DBMS) is intended to be backed up;
• programmatically detecting from among a plurality of physical or logical data drives located at one or more data storage facilities, those drives that are available for data storage by determining a storage-availability state of each drive;
• and
• based on the detected physical or logical drives and a database-aware data distribution plan generated according to a database schema of the structured database, dividing the data stored in the database into multiple data sections corresponding to portions of the structured database and distributing, in a manner that is at least partially in parallel, the multiple data sections to corresponding physical or logical drives to reduce a completion time of the full backup procedure.

A non-transitory computer-readable medium configured to store a data distribution program having instructions that enable a processing device to:

• receive a command to perform a full backup procedure in which data stored in a structured database managed by a Data Base Management System (DBMS) is intended to be backed up;
• programmatically detect, from among a plurality of physical or logical data drives located at one or more data storage facilities, those drives that are currently available for data storage by determining a storage-availability state of each drive;
• and
• based on the detected physical or logical drives and a database-aware data distribution plan generated according to a database schema of the structured database, divide the data stored in the database into multiple data sections corresponding to portions of the structured database and distribute, in a manner that is at least partially in parallel, the multiple data sections to corresponding physical or logical drives to reduce a completion time of the full backup procedure.