Seven Databases in Seven Weeks

Book description

Data is getting bigger and more complex by the day, and so are the choices in handling that data. As a modern application developer you need to understand the emerging field of data management, both RDBMS and NoSQL. Seven Databases in Seven Weeks takes you on a tour of some of the hottest open source databases today. In the tradition of Bruce A. Tate's Seven Languages in Seven Weeks, this book goes beyond your basic tutorial to explore the essential concepts at the core each technology.

Redis, Neo4J, CouchDB, MongoDB, HBase, Riak and Postgres. With each database, you'll tackle a real-world data problem that highlights the concepts and features that make it shine. You'll explore the five data models employed by these databases-relational, key/value, columnar, document and graph-and which kinds of problems are best suited to each.

You'll learn how MongoDB and CouchDB are strikingly different, and discover the Dynamo heritage at the heart of Riak. Make your applications faster with Redis and more connected with Neo4J. Use MapReduce to solve Big Data problems. Build clusters of servers using scalable services like Amazon's Elastic Compute Cloud (EC2).

Discover the CAP theorem and its implications for your distributed data. Understand the tradeoffs between consistency and availability, and when you can use them to your advantage. Use multiple databases in concert to create a platform that's more than the sum of its parts, or find one that meets all your needs at once.

Seven Databases in Seven Weeks will take you on a deep dive into each of the databases, their strengths and weaknesses, and how to choose the ones that fit your needs.

What You Need:

To get the most of of this book you'll have to follow along, and that means you'll need a *nix shell (Mac OSX or Linux preferred, Windows users will need Cygwin), and Java 6 (or greater) and Ruby 1.8.7 (or greater). Each chapter will list the downloads required for that database.

Table of contents

  1. Seven Databases in Seven Weeks
    1. Copyright
    2. For the Best Reading Experience...
    3. Table of Contents
    4. What Readers Are Saying About Seven Databases in Seven Weeks
    5. Foreword
    6. Acknowledgments
    7. Preface
      1. Why Seven Databases
      2. What’s in This Book
      3. What This Book Is Not
      4. Code Examples and Conventions
      5. Online Resources
    8. Chapter 1: Introduction
      1. It Starts with a Question
      2. The Genres
      3. Onward and Upward
    9. Chapter 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
    10. Chapter 3: Riak
      1. Riak Loves the Web
      2. Day 1: CRUD, Links, and MIMEs
      3. Day 2: Mapreduce and Server Clusters
      4. Day 3: Resolving Conflicts and Extending Riak
      5. Wrap-Up
    11. Chapter 4: 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
    12. Chapter 5: MongoDB
      1. Hu(mongo)us
      2. Day 1: CRUD and Nesting
      3. Day 2: Indexing, Grouping, Mapreduce
      4. Day 3: Replica Sets, Sharding, GeoSpatial, and GridFS
      5. Wrap-Up
    13. Chapter 6: CouchDB
      1. Relaxing on the Couch
      2. Day 1: CRUD, Futon, and cURL Redux
      3. Day 2: Creating and Querying Views
      4. Day 3: Advanced Views, Changes API, and Replicating Data
      5. Wrap-Up
    14. Chapter 7: Neo4J
      1. Neo4J Is Whiteboard Friendly
      2. Day 1: Graphs, Groovy, and CRUD
      3. Day 2: REST, Indexes, and Algorithms
      4. Day 3: Distributed High Availability
      5. Wrap-Up
    15. Chapter 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
    16. Chapter 9: Wrapping Up
      1. Genres Redux
      2. Making a Choice
      3. Where Do We Go from Here?
    17. Appendix 1: Database Overview Tables
    18. Appendix 2: The CAP Theorem
      1. Eventual Consistency
      2. CAP in the Wild
      3. The Latency Trade-Off
    19. Bibliography
      1. You May Be Interested In…

Product information

  • Title: Seven Databases in Seven Weeks
  • Author(s):
  • Release date: May 2012
  • Publisher(s): Pragmatic Bookshelf
  • ISBN: 9781934356920