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 : Brown
4.4 (13)
close
Learning Apache Cassandra

Learning Apache Cassandra

4.4 (13)
By: Brown

Overview of this book

If you're an application developer familiar with SQL databases such as MySQL or Postgres, and you want to explore distributed databases such as Cassandra, this is the perfect guide for you. Even if you've never worked with a distributed database before, Cassandra's intuitive programming interface coupled with the step-by-step examples in this book will have you building highly scalable persistence layers for your applications in no time.
Table of Contents (14 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
1. Getting Up and Running with Cassandra
chevron up
1. Getting Up and Running with Cassandra
What Cassandra offers, and what it doesn't
Installing Cassandra
Bootstrapping the project
Creating a keyspace
Summary
2
2. The First Table
2. The First Table
Creating the users table
Inserting data
Selecting data
Developing a mental model for Cassandra
Summary
3
3. Organizing Related Data
3. 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
4. Beyond Key-Value Lookup
4. Beyond Key-Value Lookup
Looking up rows by partition
Retrieving status updates for a specific time range
Paginating over rows in a partition
Reversing the order of rows
Paginating over multiple partitions
Building an autocomplete function
Summary
5
5. Establishing Relationships
5. Establishing Relationships
Modeling follow relationships
Storing follow relationships
Looking up follow relationships
Unfollowing users
Using secondary indexes to avoid denormalization
Summary
6
6. Denormalizing Data for Maximum Performance
6. Denormalizing Data for Maximum Performance
A normalized approach
Partial denormalization
Fully denormalizing the home timeline
Write complexity and data integrity
Summary
7
7. Expanding Your Data Model
7. Expanding Your Data Model
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 have a cost
Summary
8
8. Collections, Tuples, and User-defined Types
8. Collections, Tuples, and User-defined Types
The problem with concurrent updates
Collection columns and concurrent updates
Using lists for ordered, nonunique 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
Comparing data structures
Summary
9
9. Aggregating Time-Series Data
9. Aggregating Time-Series Data
Recording discrete analytics observations
Recording aggregate analytics observations
Recording analytics observations
Summary
10
10. How Cassandra Distributes Data
10. How Cassandra Distributes Data
Data distribution in Cassandra
Data replication in Cassandra
Consistency
Handling conflicting data
Distributed deletion
Summary
11
A. Peeking Under the Hood
A. 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
12
B. Authentication and Authorization
B. Authentication and Authorization
Enabling authentication and authorization
Setting up a user
Controlling access
Authorization in action
Security beyond authentication and authorization
Summary
Wrapping up
13
Index
Index

Chapter 1. Getting Up and Running with Cassandra

As an application developer, you have almost certainly worked with databases extensively. You must have built products using relational databases like MySQL and PostgreSQL, and perhaps experimented with a document store like MongoDB or a key-value database like Redis. While each of these tools has its strengths, you will now consider whether a distributed database like Cassandra might be the best choice for the task at hand.

In this chapter, we'll talk about the major reasons to choose Cassandra from among the many database options available to you. Having established that Cassandra is a great choice, we'll go through the nuts and bolts of getting a local Cassandra installation up and running. By the end of this chapter, you'll know:

  • When and why Cassandra is a good choice for your application
  • How to install Cassandra on your development machine
  • How to interact with Cassandra using cqlsh
  • How to create a keyspace
End of Section 1
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