Kundera (https://github.com/impetus-opensource/Kundera)- an open source APL Java ORM allows polyglot persistence between RDBMS and NoSQL databases such as Cassandra, MongoDB, HBase etc. transparently to the business logic developer.
A note of caution- this does not mean that Cassandra data modeling can be bypassed- NoSQL entities still need to be modeled in such a way so as to best use Cassandra capabilities. Kundera can also take care of relationship between the entities in RDBMS. Transactions management is still pending however. Regards, Sanjay From: Adam Haney [mailto:adam.ha...@retickr.com] Sent: Sunday, February 26, 2012 7:51 PM To: user@cassandra.apache.org Subject: Re: Combining Cassandra with some SQL language I've been using a combination of MySQL and Cassandra for about a year now on a project that now serves about 20k users. We use Cassandra for storing large entities and MySQL to store meta data that allows us to do better ad hoc querying. It's worked quite well for us. During this time we have also been able to migrate some of our tables in MySQL to Cassandra if MySQL performance / capacity became a problem. This may seem obvious but if you're planning on creating a data model that spans multiple databases make sure you encapsulate the logic to read/write/delete information in a good data model library and only use that library to access your data. This is good practice anyway but when you add the extra complication of multiple databases that may reference one another it's an absolute must. On Sun, Feb 26, 2012 at 8:06 AM, R. Verlangen <ro...@us2.nl<mailto:ro...@us2.nl>> wrote: Hi there, I'm currently busy with the technical design of a new project. Of course it will depend on your needs, but is it weird to combine Cassandra with a SQL language like MySQL? In my usecase it would be nice because we have some tables/CF's with lots and lots of data that does not really have to be consistent 100%, but also have some data that should be always consistent. What do you think of this? With kind regards, Robin Verlangen ________________________________ Impetus' Head of Innovation labs, Vineet Tyagi will be presenting on 'Big Data Big Costs?' at the Strata Conference, CA (Feb 28 - Mar 1) http://bit.ly/bSMWd7. Listen to our webcast 'Hybrid Approach to Extend Web Apps to Tablets & Smartphones' available at http://bit.ly/yQC1oD. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
