SQL & NoSQL Databases

Models, Languages, Consistency Options and Architectures for Big Data Management

By: Andreas Meier, Michael Kaufmann

Write A Review

eText | 5 July 2019

At a Glance

Format
ePUB

eText

$84.99

or 4 interest-free payments of $21.25 with

Instant online reading in your Booktopia eTextbook Library *

Why choose an eTextbook?

Instant Access *

Purchase and read your book immediately

Read Aloud

Listen and follow along as Bookshelf reads to you

Study Tools

Built-in study tools like highlights and more

* eTextbooks are not downloadable to your eReader or an app and can be accessed via web browsers only. You must be connected to the internet and have no technical issues with your device or browser that could prevent the eTextbook from operating.

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 includes more than 100 tables, examples and illustrations, and each chapter offers a list of resources for further reading.

SQL & NoSQL Databases conveys the strengths and weaknesses of relational and non-relational approaches, and shows how to undertake development for big data applications. The book benefits readers including students and practitioners working across the broad field of applied information technology.

This textbook has been recommended and developed for university courses in Germany, Austria and Switzerland.