Teradata US, Inc.

Arnab Roy

Snigdha Prasad

Venkata Sai Prakash Reddy Sangu

Sama Rajender Reddy

Dinesh Chengalpatu

Karthik Sai Vakkalagadda

A method, apparatus, and computer program product for executing a relational database management system (RDBMS) in a computer system, wherein the RDBMS manages a relational database comprised of at least one column-partitioned base table storing data. Column values from at least one column of the column-partitioned base table are stored in one or more containers spread across one or more data blocks. Metadata comprising summarized information about the column values in the containers is stored in a metadata index subtable. A query with a filtering condition on the column is applied to the metadata index subtable before the column-partitioned base table is accessed, so that only qualified containers and data blocks are accessed, and unqualified containers and data blocks are eliminated, when responding to the query.

Growing community of inventors

Hyderabad Telangana, India

Arnab Roy