SQL & NoSQL Databases

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

  • Andreas Meier
  • Michael Kaufmann

Table of contents

  1. Front Matter
    Pages i-xvi
  2. Andreas Meier, Michael Kaufmann
    Pages 1-23
  3. Andreas Meier, Michael Kaufmann
    Pages 25-83
  4. Andreas Meier, Michael Kaufmann
    Pages 85-121
  5. Andreas Meier, Michael Kaufmann
    Pages 123-142
  6. Andreas Meier, Michael Kaufmann
    Pages 143-167
  7. Andreas Meier, Michael Kaufmann
    Pages 169-199
  8. Andreas Meier, Michael Kaufmann
    Pages 201-218
  9. Back Matter
    Pages 219-229

About this book


This book introduces readers to the field of relational (SQL) and non-relational (NoSQL) databases. The main topics covered are data management, data modeling, query and manipulation languages, consistency, privacy and security, system architectures and multi-user operation. The book also provides an overview of post-relational and non-relational database systems. In addition to classic concepts, important aspects of NoSQL databases are discussed, such as map / reduce, distribution options (fragments, replication), and the CAP theorem (Consistency, Availability, and Partition tolerance). The book will benefit students looking for an introduction to the area of SQL and NoSQL databases, as well as practitioners, helping them better understand the strengths and weaknesses of relational and non-relational approaches and developments in connection with big data applications. 


Data Management - Data Modeling - Database Languages - Ensuring Data Consistency - System Architecture - Post-Relational Databases - NoSQL Databases

The authors 

Andreas Meier is a former member of the Faculty of Economics and Social Science and was a Professor of Information Technology at the University of Fribourg. He specializes in electronic business, electronic government, and information management. He is member of the GI (Gesellschaft für Informatik), IEEE Computer Society, and ACM.

Michael Kaufmann is a Professor of Data Science and Big Data at the School of Information Technology, Lucerne University of Applied Sciences and Arts. He is also the coordinator of the university’s Data Intelligence research team, which develops and studies methods and technologies for intelligent data management.  


Big Data Data modeling SQL Database NoSQL Database SQL database design Database reference SQL Database architecture SQL and noSQL Database post-relational databases noSQL Database book SQL Database book Andreas Meier Michael Kaufmann

Authors and affiliations

  • Andreas Meier
    • 1
  • Michael Kaufmann
    • 2
  1. 1.Departement für InformatikUniversität FribourgFribourgSwitzerland
  2. 2.Departement für InformatikHochschule Luzern RotkreuzSwitzerland

Bibliographic information

Industry Sectors
Materials & Steel
Chemical Manufacturing
Finance, Business & Banking
IT & Software
Consumer Packaged Goods
Energy, Utilities & Environment