Joe Celko’s Complete Guide to NoSQL - 1st Edition - ISBN: 9780124071926, 9780124072206

Joe Celko’s Complete Guide to NoSQL

1st Edition

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

Authors: Joe Celko
Paperback ISBN: 9780124071926
eBook ISBN: 9780124072206
Imprint: Morgan Kaufmann
Published Date: 17th October 2013
Page Count: 244
Tax/VAT will be calculated at check-out
44.95
27.99
34.95
48.14
Unavailable
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access


Description

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

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

Details

No. of pages:
244
Language:
English
Copyright:
© Morgan Kaufmann 2014
Published:
Imprint:
Morgan Kaufmann
eBook ISBN:
9780124072206
Paperback ISBN:
9780124071926

About the Author

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

Reviews

"The book summarizes various NoSQL topics to acquaint readers with both old and new data management issues outside the realm of the relational framework… I found it thought provoking and believe that it has a place on the data manager’s bookshelf."--ComputingReviews.com, March 4, 2014