Data rollback method and device for SCADA system

The invention relates to the technical field of databases, in particular to a data rollback method and device for an SCADA system. The method comprises the steps that operation, on an SCADA database, of a user is obtained; rollback logic configuration information is read; information needing to be r...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: QI GUOCHENG, JIN FENLAN, LI JUNLIANG, CHEN PENG, MI WEIMIN, SUN DI
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention relates to the technical field of databases, in particular to a data rollback method and device for an SCADA system. The method comprises the steps that operation, on an SCADA database, of a user is obtained; rollback logic configuration information is read; information needing to be rolled back is recorded according to the rollback logic configuration information; a reverse SQL statement is generated according to the information needing to be rolled back, an object at which this operation aims and time are marked in the reverse SQL statement; an index of the reverse SQL statement is generated. According to the method and the device, disaster recovery operation on integrated maintenance data can be carried out conveniently, when one record is recovered, data records relevant to the record can be recovered, and therefore the object needing to be rolled back can be found out more accurately.