The present disclosure relates to a system, method and non-transitory computer readable medium. The system includes at least one computer-readable storage medium including a set of instructions and at least one processor in communication with the at least one computer-readable storage medium. When executing the set of instructions, the at least one processor is directed to: obtain a plurality of sub-tables, each being associated with one or more fields of a target wide table; generate a plurality of intermediate tables, each being directly or indirectly based on one or more of the plurality of sub-tables, wherein at least two of the plurality of intermediate tables are generated in parallel; and determine the target wide table based on the plurality of intermediate tables.