Comments on: Installing and using Apache Cassandra With Java Part 1 (Installation)

By: Ronald Mathies

Ronald Mathies — Wed, 18 Aug 2010 08:22:45 +0000

Where clauses are not possible within the Cassandra database. What you normally do is create multiple inverted index ColumnFamilies. The advantage of this is that retrieving data based on keys is very fast and efficient. Since Cassandra only allows you to define a single key value you need to figure out what your search paths are. Suppose i have a table with cars. If i would like to search all cars from a single brand i would create a ColumnFamily where the key is the brand name and columns are the ID’s of the cars. But if i want to search cars by engine type i would need to create another ColumnFamily where the engine type is the Key and the columns are the ID’s of the cars. These two column families don’t have any information about the cars itself except the key information.

A third Column family would be needed to store the car details where the key is the ID of the car en de columns the details.

About the business logic, Cassandra itself doesn’t provide any means or methods for handling business methods. So you would need to apply business logic from within the client before storing data or after retrieving data. Also keep in mind that the consistency between the two tables needs to be handled, what happens if data is removed from one database but us dependent on the data in the other database?

But some questions, the table you are referring to, how much data does it contain? What is the structure of the data?

By: mallikarjun

mallikarjun — Wed, 18 Aug 2010 07:47:12 +0000

Hi,

I have a requirement of using Cassandra in my application. In my application there is one table with lot of data and most of my application uses that table. Due to lot of data,performance of the application is decreasing when i use that table is in Oracle.

So, I have decided to use the Cassandra database for that one table and all other tables in oracle. Lot of business logic is dependent on that table.

No my question is, Can I use the Cassandra for a table which has lot of business logic.

I am unable to implement lot of where clauses for Cassandra database.

Is there any supporting tool to use Cassandra in an efficient way?

Please let me know…
i am in urgency..

Thanks in advance

By Mallik

By: Great 5-part tutorial on Cassandra « {lambda & cloud}

Great 5-part tutorial on Cassandra « {lambda & cloud} — Fri, 06 Aug 2010 14:27:55 +0000

[...] 5-part tutorial on Cassandra http://www.sodeso.nl/?p=80 [...]

By: OCTO talks ! » Let’s play with Cassandra…(Part 2/3)

OCTO talks ! » Let’s play with Cassandra…(Part 2/3) — Sat, 12 Jun 2010 09:25:21 +0000

[...] will not drive deep into the details of a Cassandra set up. This article explains it in details but here are the main [...]

By: Palanikumar

Palanikumar — Fri, 28 May 2010 06:54:10 +0000

Thanks for a beautiful write up on Cassandra.. It was very helpful to get to speed with your articles ..

By: Cassandra入门 : NoSQLfan

Cassandra入门 : NoSQLfan — Fri, 07 May 2010 16:08:46 +0000

[...] Installing and using Apache Cassandra With Java Part 1 (Installation) [...]

By: Apache Cassandra with Java « Unnaki

Apache Cassandra with Java « Unnaki — Thu, 06 May 2010 15:38:52 +0000

[...] Installing and using Apache Cassandra With Java Part 1 (Installation) [...]

By: Tutorial: Getting Started With Cassandra. › PHP App Engine

Tutorial: Getting Started With Cassandra. › PHP App Engine — Thu, 06 May 2010 15:10:00 +0000

[...] I should put together a detailed guide to getting started with Cassandra. As one would expect the first post is briefly introducing Cassandra and covers the distribution details and installation steps. (Wed, [...]

By: Andrew Babkin

Andrew Babkin — Tue, 04 May 2010 11:10:11 +0000

Great article, I tried Cassandra under OpenJDK 1.6.0_18 – it didn’t work. However it worked with Sun JDK.

By: links for 2010-04-26 « Daniel Harrison's Personal Blog

links for 2010-04-26 « Daniel Harrison's Personal Blog — Tue, 27 Apr 2010 02:02:39 +0000

[...] Sodeso » Installing and using Apache Cassandra With Java Part 1 (Installation) (tags: java cassandra) [...]