Todos os livros

Profissional

Apps Sobre Coach Entrar Começar a ler

Quantitative Finance · Glossário

O que é Row-oriented and columnar layout?

Também chamado de: row-oriented layout · columnar layout

Definition 3.1 Research, Data and Risk Platforms · Capítulo 3 — Columnar Formats

In a row-oriented layout the fields of each record are stored next to each other, record after record. In a columnar layout the values of each field are stored next to each other, field after field, so that the ii-th record is the ii-th value of every column.

The same four quotes in a row-oriented layout (top: each record whole) and a columnar layout (bottom: each field whole). A query that needs one field of every record reads a contiguous run in the columnar layout and every record in the row layout.
Figure 3.1. The same four quotes in a row-oriented layout (top: each record whole) and a columnar layout (bottom: each field whole). A query that needs one field of every record reads a contiguous run in the columnar layout and every record in the row layout.
Ler no capítulo →