Home Page Icon
Home Page
Table of Contents for
CockroachDB: The Definitive Guide
Close
CockroachDB: The Definitive Guide
by
CockroachDB: The Definitive Guide
1. Introduction to CockroachDB
A Brief History of Databases
Pre-relational Databases
The Relational Model
Implementing the relational model
Transactions
The SQL Language
The RDBMS hegemony
Enter the Internet
The NoSQL movement
The emergence of distributed SQL
The Advent of CockroachDB
CockroachDB design goals
CockroachDB Releases
CockroachDB in action
CockroachDB at Baidu
Cockroach at MyWorld
CockroachDB at Bose
Summary
2. CockroachDB architecture
The CockroachDB Cluster Architecture
Ranges and Replicas
The CockroachDB software stack
The CockroachDB SQL layer
SQL Optimization
From SQL to Key-Values
Tables as represented in the KV store
Column Families
Indexes in the KV store
Inverted Indexes
The STORING clause
Table Definitions and schema changes
The CockroachDB Transactional layer
MVCC principles
Transaction workflow
Write intents
Parallel Commit
Transaction clean up
Overview of transaction flow
Read/Write conflicts
Clock synchronization and clock skew
The CockroachDB distribution layer
Meta Ranges
Gossip
Leaseholders
Range Splits
Multi-region distribution
The CockroachDB Replication layer
Raft
Raft and Leaseholders
Closed timestamps and follower reads
The CockroachDB Storage layer
Log Structured Merge (LSM) Trees
SSTables and Bloom Filters
Deletes and updates
MultiVersion Concurrency Control
The Block cache
Summary
3. Getting Started
Installation
Installing CockroachDB software
Creating a CockroachCloud cluster
Starting a local single-node server
Starting up CockroachDB in a docker container
Starting up a secure server
Remote connection
Creating a Kubernetes cluster
Using a GUI client
Exploring CockroachDB
Adding some data
Databases and tables
Issuing SQL
The console
Working with programming languages
Connecting to CockroachDB from NodeJS
Connecting to CockroachDB from Java
Connecting to CockroachDB from Python
Connecting to CockroachDB from Go
Summary
4. CockroachDB SQL
SQL LANGUAGE COMPATIBILITY
QUERYING DATA WITH SELECT
The SELECT list
The FROM clause
JOINS
Anti-joins
CROSS JOINS
Set operations
Group operations
Subqueries
Correlated subquery
Lateral subquery
The WHERE clause
Common Table expressions
ORDER BY
Window functions
Other SELECT clauses
CockroachDB arrays
Working with JSON
Summary of SELECT
CREATING TABLES AND INDEXES
Column Definitions
Computed Columns
Datatypes
Primary Keys
Constraints
INDEXES
CREATE TABLE AS SELECT
ALTERING TABLES
DROPPING TABLES
VIEWS
INSERTING DATA
IMPORT/IMPORT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
TRANSACTIONAL STATEMENTS
BEGIN TRANSACTION
SAVEPOINT
COMMIT
ROLLBACK
SELECT FOR UPDATE
AS OF SYSTEM TIME
OTHER DATA DEFINITION LANGUAGE TARGETS
ADMINISTRATIVE COMMANDS
THE INFORMATION_SCHEMA
SUMMARY
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
CockroachDB: The Definitive Guide
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset