Statement detection method and device, nonvolatile storage medium and electronic equipment

The invention discloses a statement detection method and device, a nonvolatile storage medium and electronic equipment. Relates to the field of big data, and the method comprises the following steps: obtaining a structured query language (SQL) statement comprising predicates, the SQL statement being...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LU FAN, ZHENG PEILONG, GENG RUI, LIANG YONGYAO
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 statement detection method and device, a nonvolatile storage medium and electronic equipment. Relates to the field of big data, and the method comprises the following steps: obtaining a structured query language (SQL) statement comprising predicates, the SQL statement being used for performing data query on a target data table in a relational database management system MySQL database, and the predicates being used for screening conditional expressions of data; according to the predicate, a target field in a target index of the target data table is determined, and the target field is matched with the predicate; screening grouped data matched with the target field from the target data table; and determining a statement efficiency detection result of the SQL statement according to the data volume of the grouped data. The technical problem that it is difficult to check SQL statements which may have performance hidden dangers in the aspect of business data search is solved. 本发明公开了一种语句检测方法