DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


question

Aravind Palani avatar image
Aravind Palani asked ·

What does wide column store generally mean?

What is difference between wide column store and wide row / dynamic columns

cassandra
1 comment
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Just letting you know that we've had a high volume of questions in the last 48 hours and we've been caught up with the FREE Cassandra Workshop Series so our responses are delayed but we will get to them in the next few hours. Cheers!

0 Likes 0 · ·
Erick Ramirez avatar image
Erick Ramirez answered ·

Cassandra stores data in column families -- a collection of rows which can contain any columns in a sparse fashion. Storage is sparse since only columns that exist are stored in rows. Rows can have any number of columns unlike tables in relational databases which have a fixed size.

To illustrate, consider this table of users' email addresses:

CREATE TABLE user_emails (
    username text,
    email_type text,
    email_address text
    ...
    PRIMARY KEY (userid, email_type)
)

In this example, a user can potentially have unlimited email addresses like this:

INSERT INTO user_emails (username, email_type, email_address) \
    VALUES ( 'jackjones', 'personal', 'jack@jones.me')
INSERT INTO user_emails (username, email_type, email_address) \
    VALUES ( 'jackjones', 'work', 'jack.jones@enterprise.com')
INSERT INTO user_emails (username, email_type, email_address) \
    VALUES ( 'jackjones', 'other', 'justjack@private.mail')

Another example is a table of video comments:

CREATE TABLE video_comments (
    video_id text,
    comment_id text,
    username text,
    comment text,
    PRIMARY KEY (video_id, comment_id)
)

Any particular video can have thousands and even millions of comments. Put another way, a partition (a video) can have thousands of columns of comments.

These examples are what is referred to as wide column store (or wide partitions). Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

laxmikant.hcl_32751 avatar image
laxmikant.hcl_32751 answered ·

As explained here:

Tabular databases organize data in rows and columns, but with a twist from the traditional RDBMS. Also known as wide-column stores or partitioned row stores, they provide the option to organize related rows in partitions that are stored together on the same replicas to allow fast queries. Unlike RDBMSs, the tabular format is not necessarily strict. For example, Apache Cassandra™ does not require all rows to contain values for all columns in the table. Like Key/Value and Document databases, Tabular databases use hashing to retrieve rows from the table. Examples include: Cassandra, HBase, and Google Bigtable.

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.