Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Learning Apache Cassandra
  • Toc
  • feedback
Learning Apache Cassandra

Learning Apache Cassandra

By : Yarabarla
4 (26)
close
Learning Apache Cassandra

Learning Apache Cassandra

4 (26)
By: Yarabarla

Overview of this book

Cassandra is a distributed database that stands out thanks to its robust feature set and intuitive interface, while providing high availability and scalability of a distributed data store. This book will introduce you to the rich feature set offered by Cassandra, and empower you to create and manage a highly scalable, performant and fault-tolerant database layer. The book starts by explaining the new features implemented in Cassandra 3.x and get you set up with Cassandra. Then you’ll walk through data modeling in Cassandra and the rich feature set available to design a flexible schema. Next you’ll learn to create tables with composite partition keys, collections and user-defined types and get to know different methods to avoid denormalization of data. You will then proceed to create user-defined functions and aggregates in Cassandra. Then, you will set up a multi node cluster and see how the dynamics of Cassandra change with it. Finally, you will implement some application-level optimizations using a Java client. By the end of this book, you'll be fully equipped to build powerful, scalable Cassandra database layers for your applications.
Table of Contents (15 chapters)
close
close
Preface
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
Getting Up and Running with Cassandra
Getting Up and Running with Cassandra
What is big data?
Challenges of modern applications
Why not relational databases?
How to handle big data
What is Cassandra and why Cassandra?
MapReduce and Spark
Installing Cassandra
Installing the JDK
Installing on Debian-based systems (Ubuntu)
Installing on RHEL-based systems
Installing on Windows
Installing on Mac OS X
Installing the binary tarball
Bootstrapping the project
CQL—the Cassandra Query Language
Interacting with Cassandra
Getting started with CQL
New features in Cassandra 2.2, 3.0, and 3.X
Summary
2
The First Table
The First Table
How to configure keyspaces
Creating the users table
Inserting data
Selecting data
Developing a mental model for Cassandra
Summary
3
Organizing Related Data
Organizing Related Data
A table for status updates
Working with status updates
Anatomy of a compound primary key
Beyond two columns
Compound keys represent parent-child relationships
Coupling parents and children using static columns
Refining our mental model
Summary
4
Beyond Key-Value Lookup
Beyond Key-Value Lookup
Looking up rows by partition
The limits of the WHERE keyword
Retrieving status updates for a specific time range
Paginating over rows in a partition
Reversing the order of rows
Paginating over multiple partitions
JSON support
Building an autocomplete function
Summary
5
Establishing Relationships
Establishing Relationships
Modeling follow relationships
Storing follow relationships
Cassandra data modelling
Denormalization
Looking up follow relationships
Unfollowing users
Using secondary indexes to avoid denormalization
Materialized views
Summary
6
Denormalizing Data for Maximum Performance
Denormalizing Data for Maximum Performance
A normalized approach
Partial denormalization
Fully denormalizing the home timeline
Write complexity and data integrity
Batching in Cassandra
Summary
7
Expanding Your Data Model
Expanding Your Data Model
Viewing a keyspace schema
Viewing a table schema in cqlsh
Adding columns to tables
Deleting columns
Updating the existing rows
Removing a value from a column
Inserts, updates, and upserts
Lightweight transactions and their cost
Summary
8
Collections, Tuples, and User-Defined Types
chevron up
Collections, Tuples, and User-Defined Types
The problem with concurrent updates
Collection columns and concurrent updates
Using lists for ordered, non-unique values
Using maps to store key-value pairs
Collections in inserts
Collections and secondary indexes
The limitations of collections
Working with tuples
User-defined types
Choosing between tuples and user-defined types
Nested collections
Nested tuples/UDTs
Comparing data structures
Summary
9
Aggregating Time-Series Data
Aggregating Time-Series Data
Recording discrete analytics observations
Recording aggregate analytics observations
Recording analytics observations
Cassandra configuration
User-defined functions
User-defined aggregate functions
Summary
10
How Cassandra Distributes Data
How Cassandra Distributes Data
Data distribution in Cassandra
Data replication in Cassandra
Gossip protocol
Multidata center cluster
Consistency
Handling conflicting data
Distributed deletion
Table configuration options
Summary
11
Cassandra Multi-Node Cluster
Cassandra Multi-Node Cluster
3 - node cluster
Consistency in action
Cassandra internals
Cassandra repair mechanisms
Summary
12
Application Development Using the Java Driver
Application Development Using the Java Driver
A simple query
Prepared statements
QueryBuilder API
Asynchronous querying
Driver policies
Summary
13
Peeking under the Hood
Peeking under the Hood
Using cassandra-cli
The structure of a simple primary key table
Compound primary keys in column families
Collection columns in column families
Summary
14
Authentication and Authorization
Authentication and Authorization
Enabling authentication and authorization
Setting up a user
Controlling access
Authorization in action
Security beyond authentication and authorization
Summary
Wrapping up

Nested collections

Suppose that we wish store a set of phone numbers for a user each identified by a category of phone type, such as home phone or office phone. We can do this by using a map where the key is phone type and value can be a set of phone numbers, assuming there are multiple phone numbers of each type. This is an example of nested collection where we are using a set as value within a map. Let us try to create the collection:

ALTER TABLE "users" 
ADD "telephone_numbers" map<text, set<text>>;

You will get an error saying non-frozen collections are not allowed inside collections:

Cassandra lets us use nested collection types only if we use the frozen collections nested within the frozen or non-frozen collections. This means we cannot update individual values of the frozen collection. To create the preceding collection, use this:

ALTER TABLE "users" 
ADD "telephone_numbers" map<text, frozen<set<text>>>;

Now let's add some home as well as office phone numbers...

End of Section 3
Next Section
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete