Cassandra set up in local environment

Cassandra is a free and open-source distributed NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. If offers robust support for clusters spanning multiple data centers, with asynchronous masterless replication allowing low latency operations for all clients.


Feature of Cassandra:

• Elastic Scalability
• Always on architecture
• Fast linear scale performance
• Flexible data storage
• Easy data distribution
• Transaction support: (ACID)
• Fast writes

Components of cassandra:

• Node
• Data center
• Cluster
• Commit log
• Mem-table
• SSTable
• Bloom filter

CQL commands:

• Documented Shell Commands

1. HELP
2. CAPTURE
3. CONSISTENCY
4. COPY
5. DESCRIBE
6. EXPAND
7. EXIT
8. PAGING
9. SHOW
10. SOURCE
11. TRACING

CQL Data Definition Commands:

1. CREATE KEYSPACE
2. USE
3. ALTER KEYSPACE
4. DROP KEYSPACE
5. CREATE TABLE
6. ALTER TABEL
7. DROP TABLE
8. TRUNCATE
9. CREATE INDEX
10. DROP INDEX

CQL Data Manipulation Commands:

1. INSERT
2. UPDATE
3. DELETE
4. BATCH

CQL Clauses:

1. SELECT
2. WHERE
3. ORDERBY