Hewlett-Packard Development Company, L.p.

Hewlett Packard Enterprise Development LP

Zbigniew Omanski

Subbarao Kakarlamudi

Arvind Narain

Patrick M Brown

Anan Mahasintunan

Awny Kayed Al-Omari

Hansjorg Zeller

Robert Matthew Wehrmeister

Kashif Abdullah Siddiqui

Tharaknath Capirala

Peter Friedenbach

Capirala Tharaknath

Robert M Wehrmeister

A workload management service component of a parallel database-management system monitors usage of computational resources in the parallel database-management system. The component provides a query-processing-task-management interface and a query-execution engine. The engine receives query-processing requests associated with one of a number of services from host computers, and accesses the workload-management-services component to determine whether to immediately launch execution of query-processing tasks corresponding to the received query-processing requests. Alternatively, the engine accesses the component to place the query-processing requests on wait queues for subsequent execution. The determination is based on the current usage of computational resources within the parallel database-management system.

Workload management in a parallel database system

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.

Allocation of resources for concurrent query execution via adaptive segmentation

A database management system that can comprise a memory for storing computer executable instructions and a processing unit for accessing the memory and executing the computer executable instructions. The computer executable instruction scan comprise a compiler to hold a query received at a query input, thereby preventing the query from executing based on a cost comparison between an estimated resource execution cost of a query plan for the query and cost rules.

Systems and methods for holding a query

Growing community of inventors

San Jose, CA, United States of America

Zbigniew Omanski