Micro Focus Lcc

Natalya Aksman

Stephen Gregory Walkauskas

James Clampffer

Deepak Majeti

A complex data type is encoded over columns of a table of a columnar database by mapping fields of the complex data type to the columns. An optimized query can be generated for a query specifying the complex data type. The optimized query specifies the columns to which the fields specified within the query are mapped, instead of specifying the fields. The optimized query can be processed against the database in a late materialization manner to fulfill the query.

Complex data type encoding within columnar database

In some examples, a system includes query path determination circuitry to identify an aggregate projection to consider for generating a query path for the query. The aggregate projection may include an aggregated value calculated from a table column of a database table using an aggregate function. The query path determination circuitry may further be to compare candidate query paths for the query derived using the aggregate projection with candidate query paths for the query derived using a non-aggregate projection, determine a selected query path among the candidate query paths derived using the aggregate projection and the non-aggregate projection and use the selected query path as part of the query path for handling the query.

Growing community of inventors

Cambridge, MA, United States of America

Natalya Aksman