Data updating method and device and storage medium

• Main Authors: ZHAO YUE, TANG BINGBING, MA YOULIANG, SONG YU, FENG YI, WANG XIANG, CHEN LIN, NING QIUYI, SONG WENLONG
• Format: Patent
• Language: Chinese; English
• Published: 07.06.2024
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention provides a data updating method and device and a storage medium, relates to the technical field of data processing, and can solve the problem that an existing hive database cannot support real-time query and updating operation of data. The method comprises the steps that updated data are stored in a hiveI table, the operation sequence of the updated data is recorded, the hiveI table comprises original data, the operation sequence of the original data is smaller than the operation sequence of the updated data, physical deletion data are stored in a hiveD table, the operation sequence of the physical deletion data is recorded, the hiveD table comprises logic deletion data, and the logic deletion data are stored in the hiveD table. The operation order of logically deleting the data is smaller than the operation order of physically deleting the data, the target data is obtained based on the operation order in the hiveI table and the operation order in the hiveD table, and the operation order in the