Apache Cassandra Essentials

Chapter 3. Creating Database and Schema

In the previous chapter, we learned about creating a keyspace and defining its replication strategy. In this chapter, we'll discuss how we can create tables in our keyspace. We'll see what different table options could be used while creating a table. We'll discuss various features provided by Cassandra, such as lightweight transactions and batch statements, and their trade-offs. Terms such as memtable, bloomfilter, index interval, and so on that we come across in this chapter will be discussed in detail in the next chapter.

Note

I am using the terms table and column family interchangeably here.

A database and schema

A Cassandra database schema has two major building blocks: Keyspace, Column Family and Primary ...