Stack Overflow
Stack Overflow

Questions tagged [column-oriented]

Column oriented DBMS are systems that store all the data related to a single column together, unlinke traditional DBMS that store data by row.

Sometimes the term is confused or used interchangeably with wide column store which is a different concept related to nosql databases.

In order to be unambiguous it's better to use the tag when dealing with systems like , and use when dealing with systems like .

Certain systems, like share both features, they have a wide column store data model but also store data on disk in a column oriented way (specifcally grouped by column family).

Resources:

41 questions
82
votes
7 answers

Why many refer to Cassandra as a Column oriented database?

Reading several papers and documents on internet, I found many contradictory information about the Cassandra data model. There are many which identify it as a column oriented database, other as a row-oriented and then who define it as a hybrid way…
cesare
  • 1,125
  • 1
  • 10
  • 14
30
votes
4 answers

Open source column-oriented storage engine for PostgreSQL?

Are there any open source projects in the works to create a column-oriented storage engine for PostgreSQL? I know Yahoo created one in-house, and that there are commercial products built on PostgreSQL that are column-oriented.
Rob
  • 5,512
  • 10
  • 41
  • 45
29
votes
5 answers

What's the difference between NoSQL and a Column-Oriented database?

The more I read about NoSQL, the more it begins to sound like a column oriented database to me. What's the difference between NoSQL (e.g. CouchDB, Cassandra, MongoDB) and a column oriented database (e.g. Vertica, MonetDB)?
Tedk
  • 339
  • 1
  • 3
  • 4
24
votes
5 answers

Is Cassandra a column oriented or columnar database

Columnar database should store group of columns together. But Cassandra stores data row-wise. SS Table will hold multiple rows of data mapped to their corresponding partition key. So I feel like Cassandra is a row wise data store like MySQL but has…
saktheesh
  • 263
  • 1
  • 2
  • 6
17
votes
7 answers

Recommendations for column-oriented database

I've found databases typically come in two flavors, your traditional row-oriented RDBMS or an object oriented database (OODBMS). However, in the mid 90s I remember, a new breed of databases showing up that were column oriented. Some of these were…
Ajaxx
  • 2,500
  • 4
  • 27
  • 38
13
votes
1 answer

Wide column vs column family vs columnar vs column oriented DB definition

There's a lot of confusion among these terms. I'd like to throw my understanding out and see if people agree. I have seen conflicting and wrong definitions all over the web. In my mind, wide column and column family DBs are essentially the same…
Kenneth
  • 561
  • 1
  • 5
  • 13
10
votes
2 answers

Columnar storage: Cassandra vs Redshift

How is columnar storage in the context of a NoSQL database like Cassandra different from that in Redshift. If Cassandra is also a columnar storage then why isn't it used for OLAP applications like Redshift?
p0712
  • 331
  • 2
  • 14
8
votes
2 answers

Is it worth trying MonetDB?

Has anyone had any experience with MonetDB? Currently, I have a MySQL database that is growing too large, and queries are getting too slow. According to column-oriented paradigm, insertions will be slower (which I don't mind at all), but data…
martincho
  • 4,517
  • 7
  • 32
  • 42
8
votes
2 answers

Relational vs Columnar and Document Databases - aren't they one in the same?

I understand that document-oriented NoSQL DBs are "extensions" of the KV model in that they allow you to query more than just a single lookup key. But once something is a "document", I feel like it already has a relational model baked into…
IAmYourFaja
  • 55,468
  • 181
  • 466
  • 756
4
votes
3 answers

Recommendations for TimeSeries db

preferably open source for storing tick info.
Kumar
  • 10,997
  • 13
  • 84
  • 134
4
votes
1 answer

Differences between NoSQL databases

NoSQL term has 4 categories. Key\value stores Document oriented Graph Column oriented. From my point of view all these data modeling has same definition, What are differences? Key\value database maintains data in structure like object in…
AMiSH13
  • 97
  • 3
  • 8
3
votes
0 answers

Columnar/Column-oriented database vs wide-column/column family database

I got really confused about Cassandra recently because most online material even AWS and Google describe it as columnar database. But actually it is row-based, partitioned, column-family database. Now everything makes sense to me: Then are all…
Stan
  • 602
  • 6
  • 23
3
votes
1 answer

What's the Meaning of "the primary key is the data" in Columnar DB

While researching column-oriented DB, I read "the primary key is the data" many times. (e.g., at Column-oriented DBMS) I thought I can randomly access to any cell (in a certain column) by value because values, the data, are already indexed as…
ghchoi
  • 4,812
  • 4
  • 30
  • 53
3
votes
1 answer

Mixing column and row oriented databases?

I am currently trying to improve the performance of a web application. The goal of the application is to provide (real time) analytics. We have a database model that is similiar to a star schema, few fact tables and many dimensional tables. The…
enricog
  • 4,226
  • 5
  • 35
  • 54
3
votes
1 answer

Which NoSQL database should I use for a URL shortener?

I'm working on a project for uni, that is building a URL shortener. I've studied the different types of NoSQL databases, but I can't figure out which is better for my purpose and why. I can choose between a key/value db, document-oriented,…
TheBlueBird
  • 33
  • 1
  • 5
1
2 3