The invention relates to the technical field of
big data, can be applied to the field of science and technology finance / digital
medical treatment, and discloses an automatic offline method and device for a big
database table,
electronic equipment and a storage medium. The method comprises the following steps: setting a permission approval person of a
virtual user in a target
distributed computing framework as an owner of the
virtual user, and
synchronizing owner information and permission configuration change information; automatically
synchronizing dependency,
authorization records and auditing records at the downstream of the
library table to a data middle table; performing automatic cleaning and conversion on downstream dependency,
authorization records and auditing records of the
library table; generating a unified wide table according to downstream dependency,
authorization records and auditing records of the
library table; receiving an input library table to be evaluated offline, generating evaluation information and
virtual user owner information of the library table to be evaluated offline, and sending an offline notification to an
associated party for confirmation; and receiving feedback confirmation information returned by the related party, and performing offline
processing on the to-be-offline evaluation library table. According to the method, the
automation degree and efficiency of large
database table offline are improved.