发明名称 Dynamic priority-based query scheduling
摘要 Techniques for scheduling query execution are provided. In one embodiment, a computer system can receive a query to be executed and can assign a priority to the query. The computer system can further divide the query into a plurality of sub-queries and can assign a sub-priority to each sub-query, where the sub-priority is based on a resource consumption metric of the query. The computer system can then select, from a plurality of sub-query pools, a sub-query pool that includes sub-queries of queries that have the same priority as the query, and can add the plurality of sub-queries to the selected sub-query pool.
申请公布号 US9436739(B2) 申请公布日期 2016.09.06
申请号 US201314106313 申请日期 2013.12.13
申请人 VMware, Inc. 发明人 Li Zhenmin;Huang Chengdu;Patel Jay A.
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项 1. A method for scheduling query execution, the method comprising: receiving, by a computer system, a query to be executed; assigning, by the computer system, a priority to the query, the priority being identical to priorities assigned to one or more previously received queries; dividing, by the computer system, the query into a plurality of sub-queries; assigning, by the computer system, a sub-priority to each sub-query in the plurality of sub-queries, wherein the sub-priority for each sub-query of the query is identical to each other, and wherein the sub-priority is based on a resource consumption metric of the query that reflects an amount of computing resources consumed due to execution of the query; selecting, by the computer system from a plurality of sub-query pools, a sub-query pool that is associated with the priority of the query, the selected sub-query pool including sub-queries of the one or more previously received queries; and adding, by the computer system, the plurality of sub-queries to the selected sub-query pool.
地址 Palo Alto CA US