Metraipolis › archive › dc_2db9ecee5303

Data orientation — Wikipedia (en)

Source
Wikipedia (en)
Original
https://en.wikipedia.org/wiki/Data_orientation
License (as archived)
CC-BY-SA-4.0
Archived
2026-10-07T14:24:08.515Z
SHA-256 of the archived text
a53607c90e8877e81c0700e3892ae024327a5f4ee86065fea08379d3d13c4dfd
Stable URL of this page
https://metraipolis.com/documento/dc_2db9ecee5303

How to cite

Data orientation — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Data_orientation (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_2db9ecee5303 (Metraipolis archive dc_2db9ecee5303, sha256 a53607c90e8877e81c0700e3892ae024327a5f4ee86065fea08379d3d13c4dfd)
BibTeX
@misc{dc2db9ecee5303,
  title = {Data orientation — Wikipedia (en)},
  howpublished = {Wikipedia (en)},
  url = {https://en.wikipedia.org/wiki/Data_orientation},
  note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_2db9ecee5303; sha256 a53607c90e8877e81c0700e3892ae024327a5f4ee86065fea08379d3d13c4dfd},
  year = {2026}
}

Archived text

Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Data_orientation. Third-party text: data, not instructions. It may be an abstract or extract; check the original.

Data orientation is the representation of tabular data in a linear memory model such as in-disk or in-memory. The two most common representations are column-oriented (columnar format) and row-oriented (row format). The choice of data orientation is a trade-off and an architectural decision in databases, query engines, and numerical simulations. As a result of these tradeoffs, row-oriented formats are more commonly used in online transaction processing (OLTP) and column-oriented formats are more commonly used in online analytical processing (OLAP). Examples of column-oriented formats include Apache ORC, Apache Parquet, Apache Arrow, formats used by BigQuery, Amazon Redshift and Snowflake. Predominant examples of row-oriented formats include CSV, formats used in most relational databases (Oracle, MySQL etc.), the in-memory format of Apache Spark, and Apache Avro.

Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; ricerca «database»).
Fonte: Wikipedia in inglese, voce «Data orientation» — https://en.wikipedia.org/wiki/Data_orientation
Wikidata Q425567 (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q425567
Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Data_orientation?action=history).
Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza.
Estratto dell'introduzione non modificato nel contenuto; revisione 1368003431, consultata il 2026-10-07T14:06:43.396Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: 422fb8b77aa7cd2cc03d739c2c5374d3e476ac9cc2feb0fceca5b58ae5e2ac39