Buffered data merge processes in database platforms

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.