×

Run-time decision of bulk insert for massive data loading

  • US 9,665,612 B2
  • Filed: 05/29/2014
  • Issued: 05/30/2017
  • Est. Priority Date: 05/29/2014
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • initiating execution of a database command, the database command associated with a base table with at least one row to copy to a target table, the database command associated with a non-bulk insert mode;

    detecting a run-time statistic including a number of row buffers filled with rows from the base table;

    making a run-time decision to automatically convert the insert mode from the non-bulk insert mode to a BULK insert mode based on the number of row buffers filled with rows during execution of the database command;

    inserting a set of rows into the target table using the BULK insert mode based on the run-time decision;

    determining at least one more rows remains in one or more buffers; and

    inserting the one or more rows in a non-bulk insert mode and updating one or more indexes corresponding to the one or more rows in a serial mode.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×