RE: Combining Cassandra with some SQL language
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.nlmailto: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.
[ANN] BigDataCamp Delhi, India, Sep 10, 2011
Registration here (few seats left) - http://www.cloudcamp.org/delhi Agenda: 9:30 am - Food, Drinks Networking 10:00 am - Welcome, Thank yous Introductions 10:15 am - Lightning Talks (5 minutes each) 10:45 am - Unpanel 11:45 am - Prepare for Unconference Breakout Sessions (solicit breakout topics, etc.). 12:00 - 12:15 Break 12:15 pm - Unconference - Round 1 1:00 pm Lunch 2:15pm - Unconference - Round 2 2:45pm - Unconference - Round 3 3:15pm - Unconference - Round 4 3:45pm - Wrap Up Proposed Topics: Introduction to Hadoop / Big Data Kundera (ORM for Cassandra, Hbase and MongoDB) Introduction to NOSQL BigData Analytics Crux Sponsors: IBM, Impetus, Nasscom Location: Impetus Infotech (India) Pvt. Ltd. D-39 40, Sector 59 Noida (Near New Delhi) Uttar Pradesh - 201307 Regards, Sanjay Sharma Need to identify code bottlenecks? Register for Impetus Webinar on 'Rapid Bottleneck Identification through Software Performance Diagnostic Tools' on Aug 19. Click http://www.impetus.com to know more. Follow us on www.twitter.com/impetuscalling 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.
[INFO] Apache Cassandra monitoring through Hyperic HQ
Sharing an useful article on Cassandra Monitoring through Hyperic HQ- http://www.theserverside.com/news/thread.tss?thread_id=62185 Regards, Sanjay Sharma Impetus Are you exploring a Big Data Strategy ? Listen to this recorded webinar on Planning your Hadoop/ NoSQL projects for 2011 at www.impetus.com/featured_webinar?eventid=37 Follow us on www.twitter.com/impetuscalling or visit www.impetus.com to know more. 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.
RE: cassandra database viewer
You could also try http://cassui.googlecode.com -Sanjay From: Shashank Tiwari [mailto:tsha...@gmail.com] Sent: Saturday, December 11, 2010 4:01 AM To: user@cassandra.apache.org Subject: Re: cassandra database viewer what about https://github.com/suguru/cassandra-webconsole? any good? On Fri, Dec 10, 2010 at 2:00 PM, Aaron Morton aa...@thelastpickle.commailto:aa...@thelastpickle.com wrote: This is the only thing I can think of https://github.com/driftx/chiton Have not used it myself. Aaron On 11/12/2010, at 5:33 AM, Liangzhao Zeng liangzhao.z...@gmail.commailto:liangzhao.z...@gmail.com wrote: Is there any database viewer in cassandra to browser the content of the database, like what DB2 or oracle have? Thanks, Liangzhao Impetus is a proud sponsor for the NCR Tester Monthly Meet- – a technology un-conference being held on Dec 18th in Noida. The event will focus on various aspects of Test Engineering. Click http://www.impetus.com to know more. Follow us on www.twitter.com/impetuscalling. 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.
kundera: Open source JPA 1.0 compliant ORM for Cassandra
Hi All,
We are happy to announce and share a new ORM over Cassandra - kundera
The project is Apache licensed and hosted at http://kundera.googlecode.com
The project uses custom Cassandra Annotations and is fully JPA 1.0 compliant.
@ColumnFamily and @SuperColumnFamily are the main Cassandra specific
annotations.
Search/Indexing is automatically included by using Lucandra and drives the
JPA-QL query support. Use of Lucandra also enables users to write Lucene
queries along with JPA-QL queries.
As per the main author of kundera - Animesh - The idea behind Kundera is to
make working with Cassandra drop-dead simple and fun. Kundera does not reinvent
the wheel by making another client library; rather it leverages the existing
libraries and builds - on top of them - a wrap-around API to help developers do
away with unnecessary boiler plate codes, and program a neater-and-cleaner code
that reduces code-complexity and improves quality. And above all, improves
productivity.
The current implementation uses the versatile Pelops library as the
underlying client API and plans are to add support for Hector and Thrift
clients as well.
Here is a sample kundera Entity bean -
@Entity
@ColumnFamily(keyspace = Keyspace1, family = SimpleComment)
public class SimpleComment {
@Id
private String id;
@Column(name = userId)
private String userId;
@Column(name = comment)
private String commentText;
..
}
JPA queries are as simple as-
Query query = entityManager.createQuery(SELECT c from SimpleComment c
where userId='me');
ListSimpleComment list = query.getResultList();
There is already support for Spring based persistence integration like the good
old Spring+Hibernate integration and is as simple as this-
bean id=entityManagerFactory
class=org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean
property name=persistenceUnitName value=myPersistenceUnit/
/bean
More examples are available in kundera's
wikihttp://code.google.com/p/kundera/wiki and Animesh's
bloghttp://anismiles.wordpress.com/2010/07/14/kundera-now-jpa-1-0-compatible/s.
The spring integration example is
herehttp://code.google.com/p/kundera/wiki/HowToUseKunderaWithSpring
Regards,
Sanjay Sharma
iLabs, Impetus
Impetus is sponsoring 'Hadoop India User Group Meet Up'- a technology
un-conference on July 31, 2010 at Impetus Office, Noida. The event will shed
light on Hadoop technology and channelized efforts to develop an active Hadoop
community.
Click http://www.impetus.com/ to know more. Follow our updates on
www.twitter.com/impetuscalling .
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.
RE: A very short summary on Cassandra for a book
Hi Jonathan, I fear 'row-oriented' could fuel the holy war between 'row-based RDBMS' and 'column-oriented NoSQL databases' Some related reads here - -http://dbmsmusings.blogspot.com/2010/03/distinguishing-two-major-types-of_29.html -http://en.wikipedia.org/wiki/Column-oriented_DBMS -http://en.wikipedia.org/wiki/Apache_Cassandra says- The values from a column family for each key are stored together, making Cassandra a hybrid between a column-oriented DBMS and a row-oriented store http://en.wikipedia.org/wiki/Apache_Cassandra certainly needs some cleanup! Cheers, Sanjay -Original Message- From: Jonathan Ellis [mailto:jbel...@gmail.com] Sent: Tuesday, July 20, 2010 8:11 AM To: user@cassandra.apache.org Subject: Re: A very short summary on Cassandra for a book Keep it simple. Something like Cassandra is a row-oriented, fully distributed database designed for scalability, availability, and durability. Trying to explain the data model in two sentences is not going to work, and 4 or 5 dimension associated arrays is the wrong tree to bark up entirely. (row-oriented is the right one. :) On Thu, Jul 15, 2010 at 6:26 PM, Karoly Negyesi chx1...@gmail.com wrote: Hi, I am writing a scalability chapter in a book and I need to mention Apache Cassandra although it's just a mention. Still I would not like to be sloppy and would like to get verification whether my summary is accurate. Cassandra stores four or five dimension associated arrays. The first dimension is fixed on creation of the database but the rest can be infinitely large. Inserts are super fast and can happen to any database server in the cluster. However, the system is append only there so there is no in-place update operation like increment. Also sorting happens on insert time. Thanks Karoly Negyesi -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cassandra support http://riptano.com Meet Impetus at the OSCON 2010 in Portland, Oregon during July 19th to 23rd. Listen to our Senior Director of Engineering and expert speaker Vineet Tyagi talk about building a Ruby application server. Click http://www.impetus.com/ to know more. Follow our updates on www.twitter.com/impetuscalling . 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.
