O'Reilly logo

Cassandra Data Modeling and Analysis by C.Y. Kan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Modeling by query

In the previous section, we gained a basic understanding of the differences between a relational database and Cassandra. The most important difference is that a relational database models data by relationships whereas Cassandra models data by query. Now let us start with a simple example to look into what modeling by query means.

Relational version

The following figure shows a simple relational data model of a stock quote application:

Relational version

The relational data model of a stock quote application (Source: Yahoo! Finance)

The stock_symbol table is an entity representing the stock master information such as the symbol of a stock, the description ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required