Database field intelligent updating method and device

The invention provides a database field intelligent updating method and device, and belongs to the technical field of big data application and data governance, and the method comprises the steps: determining the total data volume in a database and the number of fields needing to be updated, and coll...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: QI LU, LUO XIAOGUANG, FU JIALE, HUANG JUN, RONG MENGYU
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 invention provides a database field intelligent updating method and device, and belongs to the technical field of big data application and data governance, and the method comprises the steps: determining the total data volume in a database and the number of fields needing to be updated, and collecting the load information of a system; inputting the load information, the total data volume needing to be updated and the field number into a preset multi-objective optimization model, taking the batch updating time as an independent variable of the preset multi-objective optimization model, and solving the multi-objective optimization model by utilizing a genetic algorithm to obtain an optimal batch updating time factor; the method comprises the following steps: acquiring a database, solving a preset proportional-integral-differential control model, calculating the batch size of batch updating of the database in real time based on the solved proportional-integral-differential control model, and performing updat