The invention provides a quick
data conversion method,
system and device based on a cross-table structure and a medium, a configuration module associatively queries query results of multiple types of configuration tables to generate configuration data for cross-table
data conversion, and the configuration data is stored in a cache module to obtain a configuration
data cache for determining an association relationship between the tables and fields; the
queue module adopts a thread security
queue to store external to-be-converted source table data into a read
queue to obtain to-be-converted source table data in the read queue; a
data conversion module obtains data from the read queue, assigns values through a
dynamic field mapping mechanism by utilizing a configuration
data cache identification table and a field association relationship, and stores the converted data into a write queue to obtain target table data; and the
database operation module obtains the target table data from the write queue, determines a service scene according to the service identifier in the configuration
data cache, and stores all the target table data in the scene into a single transaction. By adopting the method, the configuration and data conversion efficiency can be improved, the
database load is reduced, and the data
storage security and the
database falling consistency are guaranteed.