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...
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 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 |
---|