公开(公告)号：US20090132488A1

公开(公告)日：2009-05-21

申请号：US11986599

申请日：2007-11-21

申请人： Robert M. Wehrmeister ,  Awny K. Al-Omari ,  Subbarao Kakarlamudi ,  Zbigniew Omanski ,  Kashif A. Siddiqui ,  Hansjorg Zeller ,  Peter Friedenbach

发明人： Robert M. Wehrmeister ,  Awny K. Al-Omari ,  Subbarao Kakarlamudi ,  Zbigniew Omanski ,  Kashif A. Siddiqui ,  Hansjorg Zeller ,  Peter Friedenbach

IPC分类号： G06F17/30

CPC分类号： G06F17/30445 ,  G06F17/30545

摘要： An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an application at a database client system. The query compiler configured to prepare the execution plan for the query and compute the number of executive server processes (ESPs) in each ESP layer of the query. The workload management system is configured to generate an affinity value, and the query executor is configured to execute the query. As disclosed herein, placement of the executive server process layers of the query onto processors of the computing system is determined using the affinity value. Other embodiments, aspects and features are also disclosed.

摘要翻译： 具有多个处理器和存储器资源的企业数据仓库或商业智能系统。 该系统至少包括数据库服务器，工作负载管理系统，查询编译器和查询执行器。 数据库服务器被配置为从数据库客户端系统的应用程序接收数据库查询。 查询编译器配置为准备查询的执行计划，并计算查询的每个ESP层中的执行服务器进程（ESP）的数量。 工作负载管理系统被配置为生成关联值，并且查询执行器被配置为执行查询。 如本文所公开的，使用亲和度值来确定查询的执行服务器处理层的位置到计算系统的处理器。 还公开了其它实施例，方面和特征。

公开(公告)号：US09165032B2

公开(公告)日：2015-10-20

申请号：US11986599

申请日：2007-11-21

申请人： Robert M Wehrmeister ,  Awny K Al-Omari ,  Subbarao Kakarlamudi ,  Zbigniew Omanski ,  Kashif A Siddiqui ,  Hansjorg Zeller ,  Peter Friedenbach

发明人： Robert M Wehrmeister ,  Awny K Al-Omari ,  Subbarao Kakarlamudi ,  Zbigniew Omanski ,  Kashif A Siddiqui ,  Hansjorg Zeller ,  Peter Friedenbach

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30445 ,  G06F17/30545

摘要： An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an application at a database client system. The query compiler configured to prepare the execution plan for the query and compute the number of executive server processes (ESPs) in each ESP layer of the query. The workload management system is configured to generate an affinity value, and the query executor is configured to execute the query. As disclosed herein, placement of the executive server process layers of the query onto processors of the computing system is determined using the affinity value. Other embodiments, aspects and features are also disclosed.