We will discus Cassandra implementation : Important Points: http://www.datastax.com/documentation/cassandra/2.0/cassandra/gettingStartedCassandraIntro.html Recommended stable production version – DataStax Enterprise 4.5. (When this article as written) Compound Partition and Clustered keys- http://www.datastax.com/documentation/cql/3.0/cql/ddl/ddl_compound_keys_c.html Spring-Data-Cassandra API and reference docs- http://projects.spring.io/spring-data-cassandra/ (Current release- 1.1.0.RELEASE) Download and Installation: 1. Tarball Installation DataStax DB You need to register yourself with DataStax for download. DataStax Enterprise – http://www.datastax.com/download#dl-enterprise.Continue reading “Cassandra DataStax – Developer Guide with Spring Data Cassandra”
Category Archives: Database
MongoDB + Java + Maven Sample Application
Prerequisite: Download and Install MongoDB (http://docs.mongodb.org/manual/installation/) on your local machine and run two instances in two separate terminal/command prompt. This sample app is developed on Mac OS/Linux env. 1. Start MongoDB server using : ./mongod 2. Start MongoDB client : ./mongo Add MongoDB Jar dependency in your project: Sample MONGODB CRUD code:
Optimizing SQL Queries
I have found a nice article on Oracle query optimzation: D.1 Optimizing Single-Table Queries To improve the performance of a query that selects rows of a table based on a specific column value, create an index on that column. For example, the following query performs better if the NAME column of the EMP table hasContinue reading “Optimizing SQL Queries”
Difference between MongoDB and RDBMS
Why RDBMS (SQL): Frequent CRUD transactions for a limited similar type of data in GBs. It’s good for structured data. This kind of database is tightly structured with schema and perform slower (low latency) with huge growing data. RDBMS performs faster for low amount of data ( in GBs). SQL DBs- Oracle, MySQL, SQLServer etc.Continue reading “Difference between MongoDB and RDBMS”