SQL statement control method and device

The embodiment of the invention provides an SQL (structured query language) statement control method and device. A user of the database system can configure a plurality of control policies and provide the control policies to the database system, and the database system can perform control operation...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: WU DI, SUN MENGSHI, LOU JIANGHANG, WU XUEQIANG, DING FENG
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 embodiment of the invention provides an SQL (structured query language) statement control method and device. A user of the database system can configure a plurality of control policies and provide the control policies to the database system, and the database system can perform control operation on SQL statements hitting the control policies. The control operation can specifically be that if a waiting condition specified by the control strategy is met, the SQL statement hitting the control strategy is added to a waiting queue corresponding to the control strategy. The database system can sequentially execute the SQL statements in the waiting queue on the premise that the current concurrency does not exceed the maximum concurrency specified by the control strategy. 本说明书披露的多个实施例提供了一种SQL语句的控制方法及装置。数据库系统的用户可以配置若干控制策略并提供给数据库系统,数据库系统可以针对命中控制策略的SQL语句进行控制操作。此处的控制操作具体可以是,如果满足控制策略指定的可等待条件,则将命中控制策略的SQL语句添加到控制策略对应的等待队列。数据库系统可以在坚持当前并发量不超出控制策略指定的最大并发数量的前提下,依序执行该等待队列中的SQL语句。