Data processing method, medium and electronic device for a database

A non-transitory computer-readable medium having a computer program stored thereon, wherein the computer program when executed by a processing device causes the processing device to implement a data processing method for a database, comprising:

• obtaining a first execution statement for performing a target operation;
• reading, in response to a data source corresponding to the first execution statement comprising first data corresponding to a committed transaction and second data corresponding to an uncommitted transaction, a materialized view obtained after performing the target operation on the first data as a target materialized view from a pre-created materialized view set, wherein at least a materialized view obtained after performing a specified operation on any data is maintained in the pre-created materialized view set;
• reading the second data and performing the target operation on the second data to obtain operation result data;
• performing data merging processing on the target materialized view and the operation result data to obtain merged data;
• and
• performing the target operation on the merged data to obtain an execution result corresponding to the first execution statement.

An electronic device, comprising:

• a storage device having a computer program stored thereon;
• and
• a processing device configured to execute the computer program in the storage device to implement a data processing method for a database, comprising:
• obtaining a first execution statement for performing a target operation;
• reading, in response to a data source corresponding to the first execution statement comprising first data corresponding to a committed transaction and second data corresponding to an uncommitted transaction, a materialized view obtained after performing the target operation on the first data as a target materialized view from a pre-created materialized view set, wherein at least a materialized view obtained after performing a specified operation on any data is maintained in the pre-created materialized view set;
• reading the second data and performing the target operation on the second data to obtain operation result data;
• performing data merging processing on the target materialized view and the operation result data to obtain merged data;
• and
• performing the target operation on the merged data to obtain an execution result corresponding to the first execution statement.