BUFFERED DATA MERGE PROCESSES IN DATABASE PLATFORMS

1 . A system comprising:

one or more processors; and

a memory storing instructions that, when executed by at least one processor in the one or more processors, cause the at least one processor to perform operations for generating a text response corresponding to an object displayed in a user interface (UI) page, the operations comprising:

accessing an external table including changed data associated with a master table;

inserting one or more rows of data included in the changed data into a buffer table;

generating a unified view that combines the changed data in the buffer table and original data in the master table, the unified view including a materialized table that cachesa join result of one or more rows of the master table and one or more rows of the buffer table, the unified view configured to enable one or more devices to run one or more queries on the materialized table;

querying on the materialized table of the unified view to retrieve one or more identity records having one or more pieces of the changed data;

re-accessing the external table to identify a new piece of changed data associated with the master table;

dynamically updating the buffer table by appending the new piece of changed data the buffer table; and

dynamically updating the unified view based on the updated buffer table to include the new piece of changed data in the unified view.

2 . The system of claim 1 , wherein the operations further comprise adjusting a merge condition based on at least one of an access pattern of the master table, available merge resources, a configuration of the external table, a configuration of the buffer table, and a configuration of the unified view.

3 . The system of claim 1 , wherein the operations further comprise adjusting a merge condition based on a size measurement for the external table, a size measurement for the unified view, and a size measurement for the buffer table.

4 . The system of claim 1 , wherein the operations further comprise adjusting a merge condition based on a performance metric, a degradation threshold for the unified view, and a query response time for the unified view.

5 . The system of claim 1 , wherein the operations further comprise querying on the external table to identify one or more pieces of the changed data from the external data in the external table.

6 . The system of claim 1 , wherein the one or more queries generate query results that identity one or more identity records in the original data that have changed data.

7 . The system of claim 1 , wherein generating the unified view comprises generating a first non-materialized table that includes the changed data in the buffer table and the original data the master table; and

generating a materialized version of the first-non materialized table that includes one or more rows of the changed data and one or more rows of the master table.

8 . The system of claim 1 , wherein the operations further comprise generating metadata related to at least one of the unified view and the buffer table;

comparing one or more pieces of the metadata to one or more merge conditions;

initiating a merge process based on identifying a piece of metadata that satisfies one or more of the merge conditions;

executing the merge process to update the mater table by merging the changed data in the buffer table with the original data in the master table; and

clearing the changed data from the buffer table.

9 . The system of claim 8 , wherein the one or more merge conditions include a master size metric and a relative size metric and the operations further comprise:

determining a master size metric for the master table;

determining a relative size for the buffer table based on a comparison of the buffer size metric and the master size metric; and

executing the merge process based on a comparison of the relative size metric to a merge condition.

10 . The system of claim 1 , wherein the one or more merge conditions includes a degradation level of the buffer view and a buffer size of the buffer table.

11 . A method for generating a text response corresponding to an object displayed in a user interface (UI) page, the method comprising:

accessing an external table including changed data associated with a master table;

inserting one or more rows of data included in the changed data into a buffer table;

generating a unified view that combines the changed data in the buffer table and original data in the master table, the unified view including a materialized table that cachesa join result of one or more rows of the master table and one or more rows of the buffer table, the unified view configured to enable one or more devices to run one or more queries on the materialized table;

querying on the materialized table of the unified view to retrieve one or more identity records having one or more pieces of the changed data;

re-accessing the external table to identify a new piece of changed data associated with the master table;

dynamically updating the buffer table by appending the new piece of changed data the buffer table; and

dynamically updating the unified view based on the updated buffer table to include the new piece of changed data in the unified view.

12 . The method of claim 11 , further comprising adjusting a merge condition based on at least one of an access pattern of the master table, available merge resources, a configuration of the external table, a configuration of the buffer table, and a configuration of the unified view.

13 . The method of claim 11 , further comprising adjusting a merge condition based on a size measurement for the external table, a size measurement for the unified view, and a size measurement for the buffer table.

14 . The method of claim 11 , further comprising adjusting a merge condition based on a performance metric, a degradation threshold for the unified view, and a query response time for the unified view.

15 . The method of claim 11 , further comprising querying on the external table to identify one or more pieces of the changed data from the external data in the external table.

16 . The method of claim 11 , wherein the one or more queries generate query results that identity one or more identity records in the original data that have changed data.

17 . The method of claim 11 , wherein generating the unified view comprises generating a first non-materialized table that includes the changed data in the buffer table and the original data the master table; and

generating a materialized version of the first-non materialized table that includes one or more rows of the changed data and one or more rows of the master table.

18 . The method of claim 11 , further comprising generating metadata related to at least one of the unified view and the buffer table;

comparing one or more pieces of the metadata to one or more merge conditions;

initiating a merge process based on identifying a piece of metadata that satisfies one or more of the merge conditions;

executing the merge process to update the mater table by merging the changed data in the buffer table with the original data in the master table; and

clearing the changed data from the buffer table.

19 . The method of claim 18 , wherein the one or more merge conditions include a master size metric and a relative size metric, the method further comprising:

determining a master size metric for the master table;

determining a relative size for the buffer table based on a comparison of the buffer size metric and the master size metric; and

executing the merge process based on a comparison of the relative size metric to a merge condition.

20 . The method of claim 11 , wherein the one or more merge conditions include a degradation level of the buffer view and a buffer size of the buffer table.