Radbaserade

Radbaserade is a term used in computing, primarily in Swedish-language literature, to describe row-based data storage and processing. The word combines rad (row) and baserad (based). In practice, a radbaserad storage layout stores all fields of a row together, as opposed to kolumnbaserade (columnar) storage, where data for each column is stored contiguously. This distinction matters for performance characteristics and workload suitability.

In relational databases, radbaserad storage is typical of row-store architectures (row-oriented databases). Such systems excel at transactional workloads (OLTP) that frequently insert, update, or delete full rows and often need to read most columns of a given row. By contrast, kolumnbaserade databases are optimized for analytical workloads (OLAP) that scan large numbers of rows but only require a subset of columns, enabling better compression and vectorized execution.

Hybrid and multi-model databases may support both storage layouts or allow data to be stored in a row-based manner for some tables and column-based for others. The choice between radbaserade and kolumnbaserade designs involves trade-offs in write performance, read patterns, compression efficiency, and hardware features such as CPU caching and SIMD.

In summary, radbaserade describes a row-oriented approach to organizing data, contrasting with column-oriented designs. See also: column-store databases, OLTP, OLAP.