Hewlett-packard Development Company, L.p.

Hewlett Packard Enterprise Development LP

Subbarao Kakarlamudi

Arvind Narain

Zbigniew Omanski

Michael James Hanlon

Patrick M Brown

Anan Mahasintunan

Tharaknath Capirala

Awny Kayed Al-Omari

Hansjorg Zeller

Robert Matthew Wehrmeister

David W Birdsall

Gary Stephen Smith

Kashif Abdullah Siddiqui

Anoop Sharma

Shang-Sheng Tung

Capirala Tharaknath

Peter Friedenbach

Selvaganesan Govindarajan

Robert M Wehrmeister

Regulating enterprise database warehouse resource usage can include identifying a number of queries in an enterprise database warehouse (EDW) and regulating EDW resource usage among the number of queries.

Regulating enterprise database warehouse resource usage of dedicated and shared process by using OS kernels, tenants, and table storage engines

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

There is provided a computer-implemented method of modifying a query executing in a database management system. The method comprises sending a no-wait message for the query to a control broker. The method also comprises receiving a reply to the no-wait message from the control broker. The reply to the no-wait message specifies a modification to the query. Additionally, the method comprises performing the modification.

System and method for modifying an executing query

Growing community of inventors

Milpitas, CA, United States of America

Subbarao Kakarlamudi