Method and system for ingesting data in a database

A non-transitory computer readable medium that stores a set of instructions that is executable by at least one processor of a computer to cause the computer to perform a method for inserting data in a database, the method comprising:

• storing one or more rows of data in a delta table in response to a request to insert the one or more rows in a destination table, wherein the destination table is one of a group of destination tables of a first database, and wherein the delta table contains requested changes of rows of the destination table, the changes being caused by a data operation;
• determining a priority of the destination table based on runtime information of the destination table relative to the group of destination tables;
• and
• scheduling the merging of the inserted rows from the delta table to the destination table based on the determined priority of the destination table;
• wherein the destination table is in a format of a file storing one or more blocks, each block having a set of sequence of elements clustered from each column of the destination table.

A database system for inserting data in a database, comprising:

• a memory storing a set of instructions;
• and
• a processor configured to execute the set of instructions to cause the database system to perform:
• storing one or more rows of data in a delta table in response to a request to insert the one or more rows in a destination table, wherein the destination table is one of a group of destination tables of a first database, and wherein the delta table contains requested changes of rows of the destination table, the changes being caused by a data operation,
• determining a priority of the destination table based on runtime information of the destination table relative to the group of destination tables, and
• scheduling the merging of the inserted rows from the delta table to the destination table based on the determined priority of the destination table,
• wherein the destination table is in a format of a file storing one or more blocks, each block having a set of sequence of elements clustered from each column of the destination table.