Data Orientation
Data orientation refers to how tabular data is represented in a linear memory model. The two primary formats are row-oriented and column-oriented, each with its own advantages and use cases. This choice impacts performance and storage in various applications, particularly in databases and data processing systems.
- ▪Data orientation is the representation of tabular data in a linear memory model.
- ▪Row-oriented formats are typically used in online transaction processing, while column-oriented formats are favored in online analytical processing.
- ▪Examples of column-oriented formats include Apache ORC and Apache Parquet, whereas row-oriented formats include CSV and MySQL.
Opening excerpt (first ~120 words) tap to expand
Toggle the table of contents Data orientation 13 languages AzərbaycancaDeutschEspañolفارسیFrançaisहिन्दीItaliano日本語한국어Norsk bokmålPolskiРусский中文 Edit links ArticleTalk English ReadEditView history Tools Tools move to sidebar hide Actions Read Edit View history General What links hereRelated changesUpload filePermanent linkPage informationCite this pageGet shortened URL Print/export Download as PDFPrintable version In other projects Wikidata item Appearance move to sidebar hide From Wikipedia, the free encyclopedia Tabular data representation in memory Data orientation is the representation of tabular data in a linear memory model such as in-disk or in-memory.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at Wikipedia.
