PROCESSING COLUMNS IN A DATABASE ACCELERATOR WHILE PRESERVING ROW-BASED ARCHITECTURE

摘要

Database processing using columns to present to a processing unit decompressed column data without changing the underlying row-based database architecture. For some embodiments, a database accelerator is used to efficiently process the columns of a database and output tuples to a processing unit's memory, such that the columns can be quickly processed (with the advantages of a column-based architecture) to create tuples of requested data, but without having to depart from a row-based architecture at the processing unit level or having decompressed data scattered throughout the processing unit's memory.

主权项

1. A method of database processing, comprising:
storing, in a first memory associated with a first processing unit, data associated with a table having a plurality of columns, wherein the data is stored in the first memory as the plurality of columns; reading at least a portion of each of the stored plurality of columns with the first processing unit; forming one or more tuples of the table from the at least the portion of each of the columns using the first processing unit; and outputting, to a second memory associated with a second processing unit, the tuples for processing by the second processing unit.