Tous les livres

Professionnel

Applis À propos Coach Connexion Commencer la lecture

Quantitative Finance · Glossaire

Qu'est-ce que « Row-oriented and columnar layout » ?

Aussi appelé : row-oriented layout · columnar layout

Definition 3.1 Research, Data and Risk Platforms · Chapitre 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.
Lire dans le chapitre →