CSCI 3287: Project 2 Introduction to the Cassandra Key-Value Store Solved
In this project you will work with the Apache Cassandra database. Cassandra is a key-value store database, essentially a giant hash table.
To complete this project you will need to install Cassandra and the C++ bindings for the database. All documentation regarding the Apache Cassandra project can be found at http://cassandra.apache.org/
Cassandra is designed in a way that is quite similar to MySQL. A server daemon runs on your system continuously and you use clients running in various languages that connect via network connections to the daemon. You will write a simple client program that allows you to exercise the Cassandra database from a simple command line written in C++
Your program should maintain a current keyspace. You can print this keyspace name along with your prompt.
Your program should accept five commands:
1) Show all the available keyspaces
2) List the contents of the current keyspace
3) Set the current keyspace and table. You do NOT need to create a new keyspace and/or a new table if it does not already exist.
cassandra use <keyspace.<table
4) Retrieve the data associated with a key
cassandra get <key
5) Insert a value in the database associated with a key
cassandra insert <key <value
where <key and <value should be any value legally allowed by Cassandra for insertion and retrieval.
A skeleton of the command line interface program will be provided.
Use cqlsh to create a keyspace and a table. When you create the table, give it a single attribute (of any type) as its primary key. Now in your client, you should be able to "use" the keyspace and table you created using cqlsh. You can then perform your inserts and gets using the name of the single primary key attribute. We'll only test for one value being inserted and then retrieved. The value can be of any type.
You'll get a 90.8KB .ZIP file.