The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 20, 2015
Filed:
Nov. 21, 2007
Robert M Wehrmeister, Austin, TX (US);
Awny K Al-omari, Cedar Park, TX (US);
Subbarao Kakarlamudi, Milpitas, CA (US);
Zbigniew Omanski, San Jose, CA (US);
Kashif a Siddiqui, Austin, TX (US);
Hansjorg Zeller, Los Altos, CA (US);
Peter Friedenbach, Santa Clara, CA (US);
Robert M Wehrmeister, Austin, TX (US);
Awny K Al-Omari, Cedar Park, TX (US);
Subbarao Kakarlamudi, Milpitas, CA (US);
Zbigniew Omanski, San Jose, CA (US);
Kashif A Siddiqui, Austin, TX (US);
Hansjorg Zeller, Los Altos, CA (US);
Peter Friedenbach, Santa Clara, CA (US);
Hewlett-Packard Development Company, L.P., Houston, TX (US);
Abstract
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.