Table - Physical Data Structure

1 - About

The different way, structure that exists to saved tabular data on (disk|memory).

2 - Storage

Columnar format are generally slower to write than non-columnar file formats.

2.1 - Columnar

2.2 - Row

3 - On Disk and in Memory

Different trade offs

  • On disk: Storage.
    • Accessed by multiple queries.
    • Priority to I/O reduction (but still needs good CPU throughput).
    • Mostly Streaming access.
  • In memory: Transient.
    • Specific to one query execution.
    • Priority to CPU throughput (but still needs good I/O).
    • Streaming and Random access.
data/type/relation/structure/structure.txt ยท Last modified: 2018/09/22 18:04 by