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
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
chevron up
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

Comparing data structures

We've now seen five different data structures that allow us to store multiple values within a single field. Each data structure has certain advantages and disadvantages, and each is best suited to particular use cases. In the table below, we summarize the important features of each of the data structures from this chapter:

 

Set

List

Map

Tuple

User-defined Type

Size

Flexible

Flexible

Flexible

Fixed

Fixed

Discrete updates

Yes

Yes

Yes

No

No

Partial Selection

No

No

No

No

Yes

Name-value pairs

No

No

Yes

No

Yes

Multiple Types

No

No

Keys and Values

Yes

Yes

Index

Individual elements

Individual elements

Individual elements

Entire value

Entire value

Can be used as primary key

No

No

No

Yes

Yes

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 11
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