Seven Databases in Seven Weeks, 2nd Edition

Book description

Data is getting bigger and more complex by the day, and so are your choices in handling it. Explore some of the most cutting-edge databases available - from a traditional relational database to newer NoSQL approaches - and make informed decisions about challenging data storage problems. This is the only comprehensive guide to the world of NoSQL databases, with in-depth practical and conceptual introductions to seven different technologies: Redis, Neo4J, CouchDB, MongoDB, HBase, Postgres, and DynamoDB. This second edition includes a new chapter on DynamoDB and updated content for each chapter.

While relational databases such as MySQL remain as relevant as ever, the alternative, NoSQL paradigm has opened up new horizons in performance and scalability and changed the way we approach data-centric problems. This book presents the essential concepts behind each database alongside hands-on examples that make each technology come alive.

With each database, tackle a real-world problem that highlights the concepts and features that make it shine. Along the way, explore five database models - relational, key/value, columnar, document, and graph - from the perspective of challenges faced by real applications. Learn how MongoDB and CouchDB are strikingly different, make your applications faster with Redis and more connected with Neo4J, build a cluster of HBase servers using cloud services such as Amazon's Elastic MapReduce, and more. This new edition brings a brand new chapter on DynamoDB, updated code samples and exercises, and a more up-to-date account of each database's feature set.

Whether you're a programmer building the next big thing, a data scientist seeking solutions to thorny problems, or a technology enthusiast venturing into new territory, you will find something to inspire you in this book.

What You Need:

You'll need a *nix shell (Mac OS or Linux preferred, Windows users will need Cygwin), Java 6 (or greater), and Ruby 1.8.7 (or greater). Each chapter will list the downloads required for that database.

Publisher resources

View/Submit Errata

Table of contents

  1.  Acknowledgments
  2.  Preface
    1. Why a NoSQL Book
    2. Why Seven Databases
    3. What’s in This Book
    4. What This Book Is Not
    5. Code Examples and Conventions
    6. Credits
    7. Online Resources
  3. 1. Introduction
    1. It Starts with a Question
    2. The Genres
    3. Onward and Upward
  4. 2. PostgreSQL
    1. That’s Post-greS-Q-L
    2. Day 1: Relations, CRUD, and Joins
    3. Day 2: Advanced Queries, Code, and Rules
    4. Day 3: Full Text and Multidimensions
    5. Wrap-Up
  5. 3. HBase
    1. Introducing HBase
    2. Day 1: CRUD and Table Administration
    3. Day 2: Working with Big Data
    4. Day 3: Taking It to the Cloud
    5. Wrap-Up
  6. 4. MongoDB
    1. Hu(mongo)us
    2. Day 1: CRUD and Nesting
    3. Day 2: Indexing, Aggregating, Mapreduce
    4. Day 3: Replica Sets, Sharding, GeoSpatial, and GridFS
    5. Wrap-Up
  7. 5. CouchDB
    1. Relaxing on the Couch
    2. Day 1: CRUD, Fauxton, and cURL Redux
    3. Day 2: Creating and Querying Views
    4. Day 3: Advanced Views, Changes API, and Replicating Data
    5. Wrap-Up
  8. 6. Neo4J
    1. Neo4j Is Whiteboard Friendly
    2. Day 1: Graphs, Cypher, and CRUD
    3. Day 2: REST, Indexes, and Algorithms
    4. Day 3: Distributed High Availability
    5. Wrap-Up
  9. 7. DynamoDB
    1. DynamoDB: The “Big Easy” of NoSQL
    2. Day 1: Let’s Go Shopping!
    3. Day 2: Building a Streaming Data Pipeline
    4. Day 3: Building an “Internet of Things” System Around DynamoDB
    5. Wrap-Up
  10. 8. Redis
    1. Data Structure Server Store
    2. Day 1: CRUD and Datatypes
    3. Day 2: Advanced Usage, Distribution
    4. Day 3: Playing with Other Databases
    5. Wrap-Up
  11. 9. Wrapping Up
    1. Genres Redux
    2. Making a Choice
    3. Where Do We Go from Here?
  12. A1. Database Overview Tables
  13. A2. The CAP Theorem
    1. Eventual Consistency
    2. CAP in the Wild
    3. The Latency Trade-Off
  14.  Bibliography

Product information

  • Title: Seven Databases in Seven Weeks, 2nd Edition
  • Author(s): Luc Perkins, Eric Redmond, Jim Wilson
  • Release date: April 2018
  • Publisher(s): Pragmatic Bookshelf
  • ISBN: 9781680502534