Secure CheckoutPersonal information is secured with SSL technology.
Free ShippingFree global shipping
No minimum order.
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.
- 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
About the Author
Chapter 1. NoSQL and Transaction Processing
1.1 Databases Transaction Processing in the Batch Processing World
1.2 Transaction Processing in the Disk Processing World
1.4 Pessimistic Concurrency in Detail
1.5 CAP Theorem
1.7 Server-side Consistency
1.8 Error Handling
1.9 Why SQL Does Not Work Here
Chapter 2. Columnar Databases
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
Chapter 3. Graph Databases
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
Chapter 4. MapReduce Model
4.1 Hadoop Distributed File System
4.2 Query Languages
Chapter 5. Streaming Databases and Complex Events
5.1 Generational Concurrency Models
5.2 Complex Event Processing
5.3 Commercial Products
Chapter 6. Key–Value Stores
6.1 Schema Versus no Schema
6.2 Query Versus Retrieval
6.3 Handling Keys
6.4 Handling Values
Chapter 7. Textbases
7.1 Classic Document Management Systems
7.2 Text Mining and Understanding
7.3 Language Problem
Chapter 8. Geographical Data
8.1 GIS Queries
8.2 Locating Places
8.3 SQL Extensions for GIS
Chapter 9. Big Data and Cloud Computing
9.1 Objections to Big Data and the Cloud
9.2 Big Data and Data Mining
Chapter 10. Biometrics, Fingerprints, and Specialized Databases
10.1 Naive Biometrics
10.3 DNA Identification
10.4 Facial Databases
Chapter 11. Analytic Databases
11.2 Dr. Codd’s OLAP Rules
11.6 OLAP Query Languages
11.7 Aggregation Operators in SQL
11.8 OLAP Operators in SQL
11.9 Sparseness in Cubes
Chapter 12. Multivalued or NFNF Databases
12.1 Nested File Structures
12.2 Multivalued Systems
12.3 NFNF Databases
12.4 Existing Table-Valued Extensions
Chapter 13. Hierarchical and Network Database Systems
13.1 Types of Databases
13.2 Database History
13.3 Simple Hierarchical Database
- No. of pages:
- © Morgan Kaufmann 2013
- 7th October 2013
- Morgan Kaufmann
- eBook ISBN:
- Paperback ISBN:
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.
Independent Consultant, Austin, Texas
"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
Elsevier.com visitor survey
We are always looking for ways to improve customer experience on Elsevier.com.
We would like to ask you for a moment of your time to fill in a short questionnaire, at the end of your visit.
If you decide to participate, a new browser tab will open so you can complete the survey after you have completed your visit to this website.
Thanks in advance for your time.