Cassandra

0

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 a organized schema. The schema is dynamic or fixed schema Integrated caching facility To Increase performance, NOSQL cache data in system …

Continue reading NoSQL and Advantages of NOSQL

0

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 is always On/Available. Partition Tolerance:The system continues to function even if the servers are not able to communicate with each other …

Continue reading CAP Theorem

0

Data Manipulation Language in Cassandra: Insert data to KeySpace: Syntax: &lt;INSERTSTATEMENT&gt; ::= INSERT INTO &lt;TABLENAME&gt; '(' &lt;IDENTIFIER&gt; ( ',' &lt;IDENTIFIER&gt;)* ')' VALUES'(' &lt;TERM -OR- LITERAL&gt; (',' &lt;TERM -OR- LITERAL&gt;)<em>')'(IF NOT EXIST)?( USING&lt;OPTION&gt; (AND&lt;OPTION&gt;)</em> )?&lt;TERM -OR- LITERAL&gt; ::= &lt;TERM&gt; | &lt;COLLECTION-LITERAL&gt; &lt;OPTION&gt; ::= TIMESTAMP &lt;INTEGER&gt;|TTL&lt;INTEGER&gt; Update data in KeySpace: Syntax: &lt;UPDATE-STMT&gt; ::= UPDATE&lt;TABLE-NAME&gt; (USING &lt;OPTION&gt; (AND …

Continue reading Data Manipulation Language in Cassandra

0

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 &lt;NAME&gt; WITH STATEGY_CLASS = &lt;STATEGY_NAME&gt;[AND STRATEGY_OPTIONS;&lt;OPTION&gt;=&lt;VALUE&gt;[…]]; USE: It is used to switch to a keyspace to perform work Syntax: USE &lt;KEYSPACE&gt; Alter KeySpace: To change the existing keyspace Syntax: &lt;CRETAE-KEYSPACE-STMT&gt;::= ALTER …

Continue reading Data Definition Language in Cassandra

0

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 difficult to work with. So CQL was developed to overcome the Thrift RPC approach. It is similar to SQL but all …

Continue reading Cassandra Query Language (CQL)