首页> 外国专利> Fair scheduling for mixed-query loads

Fair scheduling for mixed-query loads

机译:合理安排混合查询负载

摘要

A fair scheduling system with methodology for fairly scheduling queries for execution by a database management system. The system obtains query jobs for execution by the database management system and cost estimates to execute the query jobs. The cost estimate can be a number of results the query is expected to return. Based on the cost estimates, the system causes the database management system to execute the query jobs as separately sub-query tasks in a round-robin fashion. By doing so, the execution latency of “low cost” query jobs that return few results is reduced when the query jobs are concurrently executed with “high cost” query jobs that return a large number of results.
机译:一个公平的调度系统,具有用于公平调度查询以由数据库管理系统执行的方法。该系统获取要由数据库管理系统执行的查询作业,并获得执行该查询作业的成本估算。成本估算可以是查询期望返回的许多结果。基于成本估算,系统使数据库管理系统以循环方式将查询作业作为单独的子查询任务执行。这样,当查询作业与返回大量结果的“高成本”查询作业同时执行时,减少返回很少结果的“低成本”查询作业的执行等待时间。

著录项

相似文献

  • 专利
  • 外文文献
  • 中文文献
获取专利

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号