Database table switching method and device, electronic equipment and computer storage medium

The embodiment of the invention discloses a database table switching method and device, electronic equipment and a computer storage medium, and the method comprises the steps: receiving a database table switching request, confirming a target logic database where a to-be-switched source table is loca...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: DING SHUNJIE, WU DI, GUO PENG, WAN KAIMING, LIN YANFENG, WU XUEQIANG, LIU XINCHAO
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The embodiment of the invention discloses a database table switching method and device, electronic equipment and a computer storage medium, and the method comprises the steps: receiving a database table switching request, confirming a target logic database where a to-be-switched source table is located, and creating an intermediate table in the target logic database according to the to-be-switched source table; copying data in the source table to be switched into the intermediate table; and receiving a table switching command, and switching the related operation of the to-be-switched source table to the intermediate table after the completion of data copying is confirmed. According to the technical scheme, the situation of read-write errors during data migration can be avoided, the data read-write time is greatly shortened, the data read-write efficiency is improved, improvement of the data service quality is facilitated, meanwhile, the data table switching workload can be greatly reduced, and waste of comput