Hewlett-packard Development Company, L.p.

Entit Software LLC

Hewlett Packard Enterprise Development LP

Sreenath Bodagala

Shilpa Lawande

Benjamin M Vandiver

Charles Edward Bear

Andrew Allinson Lamb

Matthew Steven Fuller

Rajat Venkatesh

Chuck Bear

Benjamin Vandiver

A method for query processing includes receiving a query, and determining a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations. Based on the determination, the method includes processing the query to generate an output, and performing a predetermined number of maximum group by operations on the output based on the query type to generate a response to the query.

Query processing

Methods, systems and program products for database storage. In one implementation, data of a projection of a database is stored at least partly in grouped ROS format and partly in column format based on patterns of updating the projection data. The projection data is updated so that the updated projection is stored partly in grouped ROS format and partly in column format.

Database storage architecture

Growing community of inventors

North Andover, MA, United States of America

Sreenath Bodagala