The application discloses a kind of physical view incremental refreshing method, device, equipment, medium and product, it is related to
database technical field.The method comprises: dividing base table, obtains at least two sub-tables of
shard;Log temporary table and log main table of physical view are created for the sub-table of
shard;In data
shard, shard local physical view is created, and incremental refreshing control information is registered;According to incremental refreshing point, the log temporary table and the log main table determine
incremental change set;According to the base table involved in the shard local physical view and the
incremental change set, the shard local physical view is refreshed, obtains the new shard local physical view or intermediate
result set of the sub-table of shard;At least two new shard local physical views or intermediate result sets of sub-table of shard are merged, and the target physical view of the base table is obtained.