首页>
外国专利>
METHODS FOR AUTOMATIC SELECTION OF DEGREES OF PARALLELISM FOR EFFICIENT EXECUTION OF QUERIES IN A DATABASE SYSTEM
METHODS FOR AUTOMATIC SELECTION OF DEGREES OF PARALLELISM FOR EFFICIENT EXECUTION OF QUERIES IN A DATABASE SYSTEM
展开▼
机译:数据库中查询有效执行的并行度自动选择方法
展开▼
页面导航
摘要
著录项
相似文献
摘要
Methods for automatic selection of degrees of parallelism for efficient execution of queries in a database system are performed by systems and devices. An incoming query associated with a query system is received and features of the incoming query are determined. A system state of the query system and a set of executing queries are also determined, along with a query state of each executing query in the set. At runtime of the incoming query, allocation of a degree of parallelism for executing the query is determined by calculating different possible execution times for the incoming query at least partially concurrently with the set of executing queries. Execution times are calculated for different parallel thread options and based on query features, system state, or query states of executing queries. The execution of the incoming query is initialized with the parallel thread option corresponding to a specific execution completion time.
展开▼