EP 3044692 A4 20170503 - PREDICTING EXECUTION TIMES OF CONCURRENT QUERIES
Title (en)
PREDICTING EXECUTION TIMES OF CONCURRENT QUERIES
Title (de)
VORHERSAGE DER AUSFÜHRUNGSZEITEN VON KONKURRIERENDEN ANFRAGEN
Title (fr)
PRÉVISION DES TEMPS D'EXÉCUTION D'INTERROGATIONS SIMULTANÉES
Publication
Application
Priority
US 2013059837 W 20130914
Abstract (en)
[origin: WO2015038152A1] Example embodiments relate to predicting execution times of concurrent queries. In example embodiments, historical data is iteratively generated for a machine learning model by varying a concurrency level of query executions in a database, determining a query execution plan for a pending concurrent query, extracting query features from the query execution plan, and executing the pending concurrent query to determine a query execution time. The machine learning model may then be created based on the query features, variation in the concurrency level, and the query execution time. The machine learning model is used to generate an execution schedule for production queries, where the execution schedule satisfies service level agreements of the production queries.
IPC 8 full level
G06F 17/00 (2006.01); G06F 17/30 (2006.01); G06N 20/00 (2019.01)
CPC (source: EP US)
G06F 16/24532 (2018.12 - EP US); G06N 5/04 (2013.01 - US); G06N 20/00 (2018.12 - EP US)
Citation (search report)
- [I] US 2010082599 A1 20100401 - GRAEFE GOETZ [US], et al
- [I] US 2010114865 A1 20100506 - GUPTA CHETAN KUMAR [US], et al
- [I] US 2010235349 A1 20100916 - KUNO HARUMI [US], et al
- [I] US 5574900 A 19961112 - HUANG DANIEL T [US], et al
- [I] US 6009265 A 19991228 - HUANG DANIEL T [US], et al
- [A] US 2012191698 A1 20120726 - ALBRECHT SCOTT A [US], et al
- [A] US 5819255 A 19981006 - CELIS PEDRO [US], et al
- [A] US 8370280 B1 20130205 - LIN WEI-HAO [US], et al
- [A] US 2013081005 A1 20130328 - GOUNARES ALEXANDER G [US], et al
- See references of WO 2015038152A1
Designated contracting state (EPC)
AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR
DOCDB simple family (publication)
WO 2015038152 A1 20150319; EP 3044692 A1 20160720; EP 3044692 A4 20170503; US 2016203404 A1 20160714
DOCDB simple family (application)
US 2013059837 W 20130914; EP 13893241 A 20130914; US 201314917074 A 20130914