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!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator WU DI
SUN MENGSHI
LOU JIANGHANG
WU XUEQIANG
DING FENG
description 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语句。
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN113961586A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN113961586A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN113961586A3</originalsourceid><addsrcrecordid>eNrjZFAPDvRRKC5JLEnNTc0rUUjOzyspys9RyE0tychPUUjMS1FISS3LTE7lYWBNS8wpTuWF0twMim6uIc4euqkF-fGpxQWJyal5qSXxzn6GhsaWZoamFmaOxsSoAQB9Pyeo</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>SQL statement control method and device</title><source>esp@cenet</source><creator>WU DI ; SUN MENGSHI ; LOU JIANGHANG ; WU XUEQIANG ; DING FENG</creator><creatorcontrib>WU DI ; SUN MENGSHI ; LOU JIANGHANG ; WU XUEQIANG ; DING FENG</creatorcontrib><description>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语句。</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2022</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20220121&amp;DB=EPODOC&amp;CC=CN&amp;NR=113961586A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76290</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20220121&amp;DB=EPODOC&amp;CC=CN&amp;NR=113961586A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>WU DI</creatorcontrib><creatorcontrib>SUN MENGSHI</creatorcontrib><creatorcontrib>LOU JIANGHANG</creatorcontrib><creatorcontrib>WU XUEQIANG</creatorcontrib><creatorcontrib>DING FENG</creatorcontrib><title>SQL statement control method and device</title><description>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语句。</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2022</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZFAPDvRRKC5JLEnNTc0rUUjOzyspys9RyE0tychPUUjMS1FISS3LTE7lYWBNS8wpTuWF0twMim6uIc4euqkF-fGpxQWJyal5qSXxzn6GhsaWZoamFmaOxsSoAQB9Pyeo</recordid><startdate>20220121</startdate><enddate>20220121</enddate><creator>WU DI</creator><creator>SUN MENGSHI</creator><creator>LOU JIANGHANG</creator><creator>WU XUEQIANG</creator><creator>DING FENG</creator><scope>EVB</scope></search><sort><creationdate>20220121</creationdate><title>SQL statement control method and device</title><author>WU DI ; SUN MENGSHI ; LOU JIANGHANG ; WU XUEQIANG ; DING FENG</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN113961586A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2022</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>WU DI</creatorcontrib><creatorcontrib>SUN MENGSHI</creatorcontrib><creatorcontrib>LOU JIANGHANG</creatorcontrib><creatorcontrib>WU XUEQIANG</creatorcontrib><creatorcontrib>DING FENG</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>WU DI</au><au>SUN MENGSHI</au><au>LOU JIANGHANG</au><au>WU XUEQIANG</au><au>DING FENG</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>SQL statement control method and device</title><date>2022-01-21</date><risdate>2022</risdate><abstract>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语句。</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN113961586A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title SQL statement control method and device
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-01T00%3A56%3A40IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=WU%20DI&rft.date=2022-01-21&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN113961586A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true