Joe Celko’s Complete Guide to NoSQL

Joe Celko’s Complete Guide to NoSQL

What Every SQL Professional Needs to Know about Non-Relational Databases

1st Edition - October 7, 2013

Write a review

  • Author: Joe Celko
  • eBook ISBN: 9780124072206
  • Paperback ISBN: 9780124071926

Purchase options

Purchase options
DRM-free (PDF, Mobi, EPub)
Available
Sales tax will be calculated at check-out

Institutional Subscription

Free Global Shipping
No minimum order

Description

Joe Celko's Complete Guide to NoSQL provides a complete overview of non-relational technologies so that you can become more nimble to meet the needs of your organization. As data continues to explode and grow more complex, SQL is becoming less useful for querying data and extracting meaning. In this new world of bigger and faster data, you will need to leverage non-relational technologies to get the most out of the information you have. Learn where, when, and why the benefits of NoSQL outweigh those of SQL with Joe Celko's Complete Guide to NoSQL. This book covers three areas that make today's new data different from the data of the past: velocity, volume and variety. When information is changing faster than you can collect and query it, it simply cannot be treated the same as static data. Celko will help you understand velocity, to equip you with the tools to drink from a fire hose. Old storage and access models do not work for big data. Celko will help you understand volume, as well as different ways to store and access data such as petabytes and exabytes. Not all data can fit into a relational model, including genetic data, semantic data, and data generated by social networks. Celko will help you understand variety, as well as the alternative storage, query, and management frameworks needed by certain kinds of data.

Key Features

  • Gain a complete understanding of the situations in which SQL has more drawbacks than benefits so that you can better determine when to utilize NoSQL technologies for maximum benefit
  • Recognize the pros and cons of columnar, streaming, and graph databases
  • Make the transition to NoSQL with the expert guidance of best-selling SQL expert Joe Celko

Readership

Database Programmers

Table of Contents

  • Dedication

    About the Author

    Introduction

    Chapter 1. NoSQL and Transaction Processing

    Abstract

    Introduction

    1.1 Databases Transaction Processing in the Batch Processing World

    1.2 Transaction Processing in the Disk Processing World

    1.3 ACID

    1.4 Pessimistic Concurrency in Detail

    1.5 CAP Theorem

    1.6 BASE

    1.7 Server-side Consistency

    1.8 Error Handling

    1.9 Why SQL Does Not Work Here

    Concluding Thoughts

    References

    Chapter 2. Columnar Databases

    Abstract

    Introduction

    2.1 History

    2.2 How It Works

    2.3 Query Optimizations

    2.4 Multiple Users and Hardware

    2.5 Doing an ALTER Statement

    2.6 Data Warehouses and Columnar Databases

    Concluding Thoughts

    Reference

    Chapter 3. Graph Databases

    Abstract

    Introduction

    3.1 Graph Theory Basics

    3.2 RDBMS Versus Graph Database

    3.3 Six Degrees of Kevin Bacon Problem

    3.4 Vertex Covering

    3.5 Graph Programming Tools

    Concluding Thoughts

    References

    Chapter 4. MapReduce Model

    Abstract

    Introduction

    4.1 Hadoop Distributed File System

    4.2 Query Languages

    Concluding Thoughts

    References

    Chapter 5. Streaming Databases and Complex Events

    Abstract

    Introduction

    5.1 Generational Concurrency Models

    5.2 Complex Event Processing

    5.3 Commercial Products

    Concluding Thoughts

    References

    Chapter 6. Key–Value Stores

    Abstract

    Introduction

    6.1 Schema Versus no Schema

    6.2 Query Versus Retrieval

    6.3 Handling Keys

    6.4 Handling Values

    6.5 Products

    Concluding Thoughts

    Chapter 7. Textbases

    Abstract

    Introduction

    7.1 Classic Document Management Systems

    7.2 Text Mining and Understanding

    7.3 Language Problem

    Concluding Thoughts

    References

    Chapter 8. Geographical Data

    Abstract

    Introduction

    8.1 GIS Queries

    8.2 Locating Places

    8.3 SQL Extensions for GIS

    Concluding Thoughts

    References

    Chapter 9. Big Data and Cloud Computing

    Abstract

    Introduction

    9.1 Objections to Big Data and the Cloud

    9.2 Big Data and Data Mining

    Concluding Thoughts

    References

    Chapter 10. Biometrics, Fingerprints, and Specialized Databases

    Abstract

    Introduction

    10.1 Naive Biometrics

    10.2 Fingerprints

    10.3 DNA Identification

    10.4 Facial Databases

    Concluding Thoughts

    References

    Chapter 11. Analytic Databases

    Abstract

    Introduction

    11.1 Cubes

    11.2 Dr. Codd’s OLAP Rules

    11.3 MOLAP

    11.4 ROLAP

    11.5 HOLAP

    11.6 OLAP Query Languages

    11.7 Aggregation Operators in SQL

    11.8 OLAP Operators in SQL

    11.9 Sparseness in Cubes

    Concluding Thoughts

    References

    Chapter 12. Multivalued or NFNF Databases

    Abstract

    Introduction

    12.1 Nested File Structures

    12.2 Multivalued Systems

    12.3 NFNF Databases

    12.4 Existing Table-Valued Extensions

    Concluding Thoughts

    Chapter 13. Hierarchical and Network Database Systems

    Abstract

    Introduction

    13.1 Types of Databases

    13.2 Database History

    13.3 Simple Hierarchical Database

    13.4 Summary

    Concluding Thoughts

    References

    Glossary

    Index

Product details

  • No. of pages: 244
  • Language: English
  • Copyright: © Morgan Kaufmann 2013
  • Published: October 7, 2013
  • Imprint: Morgan Kaufmann
  • eBook ISBN: 9780124072206
  • Paperback ISBN: 9780124071926

About the Author

Joe Celko

Joe Celko
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Affiliations and Expertise

Independent Consultant, Austin, Texas

Ratings and Reviews

Write a review

There are currently no reviews for "Joe Celko’s Complete Guide to NoSQL"