Database script optimization method, system and equipment and storage medium

The invention discloses a database script optimization method, system and device and a storage medium. The method comprises the steps of obtaining a to-be-optimized database script; analyzing the to-be-optimized database script according to the AI algorithm model to obtain sql calling information of...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LIU XUNGANG, HE XUAN, LI SUN, HE YI
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 discloses a database script optimization method, system and device and a storage medium. The method comprises the steps of obtaining a to-be-optimized database script; analyzing the to-be-optimized database script according to the AI algorithm model to obtain sql calling information of the to-be-optimized database script; performing statement analysis according to the AI algorithm model, the sql calling information and a preset condition to obtain a statement analysis result; performing simulation operation according to the statement analysis result and the to-be-optimized database script to obtain a simulation operation result; and performing script optimization according to the to-be-optimized database script, the simulation running result and the statement analysis result to obtain an optimization result of the to-be-optimized database script, analyzing the database script by combining the use scene and the calling frequency of the database script, realizing intelligent operation and maintena