The invention relates to the technical field of
oil field databases, and discloses a
dynamic data management method, device, equipment and medium for an oil and gas field
database, and the method comprises the steps: docking multi-
source data of the oil and gas field
database, the multi-
source data comprising a shaft sensor real-time
monitoring data flow, geologic modeling gridding structure data and an equipment management tree coding table; the method comprises the following steps: performing abnormal value cleaning and
timestamp alignment on real-time
monitoring data flow of a shaft sensor, converting geologic modeling gridding structure data into a reservoir unit set with a coordinate
system label, extracting a set membership chain of well IDs and equipment IDs in an equipment management tree-shaped coding table, generating an identifier
system with a unified coding format, and storing the identifier
system in a
database; the identifier system comprises a well identifier, a reservoir unit identifier and a device identifier; generating a structured data
pool based on the identifier system; and when the data
pool is updated, sending a change instruction to a plurality of subsystems of the oil and gas field database, and updating each subsystem based on the change instruction.