The invention relates to the technical field of
data analysis, in particular to a
data path tracking and
visualization method and
system. The
data path tracking and
visualization method comprises the following steps: querying a
database, obtaining an original interaction
record set, extracting a
timestamp, a numerical value and an identity identification field of each
record, and constructing a cache structure; setting a
time range and a numerical threshold value in a self-defined manner, and screening target records meeting conditions; performing bidirectional link tracking on each screened target
record, constructing a visual map structure, and binding the visual map structure to an original record; and carrying out deduplication
processing, and inserting into a
database in batches after deduplication. According to the
data path tracking and
visualization method and
system, time and numerical value double constraints are combined, the
path recognition accuracy is improved, input and output bidirectional tracing is supported, and complex service requirements can be met; meanwhile, the performance is improved in combination with asynchronous concurrent calculation, the expandability is high, and the method is suitable for various business scenes such as finance, audit and supervision.