NoSQL and Advantages of NOSQL
Why NoSQL? Bigger data handling capability To handle Volume of data it allows data to be spread across commodity hardware Elastic scaling Scale out the storage Flexible Schema/fixed data model It does not need...
Category: Cassandra
CAP Theorem
CAP Theorem for a distributed architecture: Consistency: The data in database remains consistent after the execution of an operation. Example: After an insert operation all clients will see the same data Availability:The System...
Data Manipulation Language in Cassandra
Data Manipulation Language in Cassandra: Insert data to KeySpace: Syntax: <INSERTSTATEMENT> ::= INSERT INTO <TABLENAME> '(' <IDENTIFIER> ( ',' <IDENTIFIER>)* ')' VALUES'(' <TERM -OR- LITERAL> (',' <TERM -OR- LITERAL>)<em>')'(IF NOT EXIST)?( USING<OPTION> (AND<OPTION>)</em> )?<TERM...
Data Definition Language in Cassandra
Data Definition Language in Cassandra: You can create,alter,drop,truncate table/keyspaces in Cassandra. Create KeySpace: It is used to create a new keyspace Syntax: CREATE KEYSPACE <NAME> WITH STATEGY_CLASS = <STATEGY_NAME>[AND STRATEGY_OPTIONS;<OPTION>=<VALUE>[…]]; USE: It is used...
Cassandra Query Language (CQL)
Cassandra Query Language:(CQL) CQL is the SQL interface in Cassandra.CQL is intended to privide a simple,common and easier interface in Cassandra. Cassandra was originally developed with a Thrift RPC based approach and it was...