This book offers a comprehensive introduction to relational (SQL) and non-relational (NoSQL) databases. The authors thoroughly review the current state of database tools and techniques, and examine coming innovations.
The book opens with a broad look at data management, including an overview of information systems and databases, and an explanation of contemporary database types:
- SQL and NoSQL databases, and their respective management systems
- The nature and uses of Big Data
- A high-level view of the organization of data management
Data Modeling and Consistency Chapter-length treatment is afforded Data Modeling in both relational and graph databases, including enterprise-wide data architecture, and formulas for database design. Coverage of languages extends from an overview of operators, to SQL and and QBE (Query by Example), to integrity constraints and more.
A full chapter probes the challenges of Ensuring Data Consistency, covering:
- Multi-User Operation
- Troubleshooting
- Consistency in Massive Distributed Data
- Comparison of the ACID and BASE consistency models, and more
System Architecture also gets from its own chapter, which explores Processing of Homogeneous and Heterogeneous Data; Storage and Access Structures; Multi-dimensional Data Structures and Parallel Processing with MapReduce, among other topics.
Post-Relational and NoSQL Databases
The chapter on post-relational databases discusses the limits of SQL - and what lies beyond, including Multi-Dimensional Databases, Knowledge Bases and and Fuzzy Databases.
A final chapter covers NoSQL Databases, along with
- Development of Non-Relational Technologies,
- Key-Value, Column-Family and Document Stores
- XML Databases and Graphic Databases, and more
The book i
