Joe Celko’s Complete Guide to NoSQL
What Every SQL Professional Needs to Know about Non-Relational Databases
Description
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
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
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
Ratings and Reviews
There are currently no reviews for "Joe Celko’s Complete Guide to NoSQL"