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...
Gespeichert in:
Hauptverfasser: | , , , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
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 |
---|