Suggest Cassandra data model for an existing schema

Posted by Andriy Bohdan on Stack Overflow See other posts from Stack Overflow or by Andriy Bohdan
Published on 2010-03-19T18:12:23Z Indexed on 2010/03/20 21:41 UTC
Read the original article Hit count: 396

Filed under:

cassandra

|

data-modeling

|

database-design

|

nosql

|

key-value

Hello guys!

I hope there's someone who can help me suggest a suitable data model to be implemented using nosql database Apache Cassandra. More of than I need it to work under high loads and large amounts of data.

Simplified I have 3 types of objects:

Product
Tag
ProductTag

Product:

key - string key
name - string
.... - some other fields

Tag:

key - string key
name - unique tag words

ProductTag:

product_key - foreign key referring to product
tag_key  - foreign key referring to tag
rating - this is rating of tag for this product

Each product may have 0 or many tags. Tag may be assigned to 1 or many products. Means relation between products and tags is many-to-many in terms of relational databases.

Value of "rating" is updated "very" often.

I need to be run the following queries

Select objects by keys
Select tags for product ordered by rating
Select products by tag order by rating
Update rating by product_key and tag_key

The most important is to make these queries really fast on large amounts of data, considering that rating is constantly updated.

© Stack Overflow or respective owner

Related posts about cassandra

Cassandra inserts using Net::Cassandra::Easy in Perl

as seen on Stack Overflow - Search for 'Stack Overflow'
When using the Perl module Net::Cassandra::Easy to interface with Cassandra I use the following code to read colums col[123] from rows row[123] in column-family Standard1: my $cassandra = Net::Cassandra::Easy->new(keyspace => 'Keyspace1', server => 'localhost'); $cassandra->connect(); my… >>> More
How do I insert a row with a TimeUUIDType column in Cassandra?

as seen on Stack Overflow - Search for 'Stack Overflow'
In Cassandra, I have the following Column Family: <ColumnFamily CompareWith="TimeUUIDType" Name="Posts"/> I'm trying to insert a record into it as follows using a C++ generated function generated by Thrift: ColumnPath new_col; new_col.__isset.column = true; /* this is required! */ new_col… >>> More
shell script over SSH ends unexpectedly after running 'ant build'

as seen on Super User - Search for 'Super User'
I wrote a shell script that runs on remote host to build source code with 'ant build' command, and then distribute the built binary to other servers. However, right after Ant build is over successfully(I can see the command line output saying Build was successful), the ssh session ends and whatever… >>> More
Cassandra Remote Connection

as seen on Server Fault - Search for 'Server Fault'
I'm not managing to connect to cassandra from outside machines. The database is hosted on a windows machine and im trying to connect through a mac (but this shouldn't cause problems) Local connection works: C:\cassandra\bin>cassandra-cli Starting Cassandra Client Connected to: "Test Cluster"… >>> More
A catalogue of Cassandra log messages: What is the correct interpretation?

as seen on Stack Overflow - Search for 'Stack Overflow'
The following is a complete catalogue of all log messages generated by Cassandra 0.6 when stress-testing a Cassandra installation over an extended period of time: AntiEntropyService: Sending AEService tree for (,) to: [] CassandraDaemon: Binding thrift service to localhost/N.N.N.N:N CassandraDaemon:… >>> More

Related posts about data-modeling

Handling incremental Data Modeling Changes in Functional Programming

as seen on Stack Overflow - Search for 'Stack Overflow'
Most of the problems I have to solve in my job as a developer have to do with data modeling. For example in a OOP Web Application world I often have to change the data properties that are in a object to meet new requirements. If I'm lucky I don't even need to programmatically add new "behavior" code… >>> More
Data Modeling Resources

as seen on SQL Blog - Search for 'SQL Blog'
You can find many different data modeling resources. It is impossible to list all of them. I selected only the most valuable ones for me, and, of course, the ones I contributed to. Books Chris J. Date: An Introduction to Database Systems – IMO a “must” to understand the relational model… >>> More
Struggling with a data modeling problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I am struggling with a data model (I use MySQL for the database). I am uneasy about what I have come up with. If someone could suggest a better approach, or point me to some reference matter I would appreciate it. The data would have organizations of many types. I am trying to do a 3 level classification… >>> More
Need some advice on Core Data modeling strategy

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on an iPhone app and need a little advice on modeling the Core Data schema. My idea is a utility that allows the user to speed-dial their contacts using user-created rules based on the time of day. In other words, I would tell the app that my wife is commuting from 6am to 7am, at work… >>> More
Data Modeling of Entity with Attributes

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm storing some very basic information "data sources" coming into my application. These data sources can be in the form of a document (e.g. PDF, etc.), audio (e.g. MP3, etc.) or video (e.g. AVI, etc.). Say, for example, I am only interested in the filename of the data source. Thus, I have the following… >>> More