SQL & NoSQL databases

Más información sobre el libro

This book provides a thorough introduction to relational (SQL) and non-relational (NoSQL) databases, reviewing current tools and techniques while exploring future innovations. It begins with a broad overview of data management, covering information systems, contemporary database types, and their management systems. The text delves into Big Data, data management organization, and offers in-depth discussions on Data Modeling and Consistency in both relational and graph databases, including enterprise-wide architecture and database design formulas. Language coverage includes operators, SQL, QBE (Query by Example), and integrity constraints. A dedicated chapter addresses the challenges of ensuring data consistency, tackling multi-user operations, troubleshooting in massive distributed data, and comparing ACID and BASE models. System Architecture is also explored, focusing on homogeneous and heterogeneous data processing, storage structures, multi-dimensional data, and parallel processing with MapReduce. The section on post-relational databases examines SQL limitations and introduces Multi-Dimensional Databases, Knowledge Bases, and Fuzzy Databases. The final chapter covers NoSQL technologies, including Key-Value, Column-Family, Document Stores, XML, and Graph Databases. With over 100 tables, examples, and resources for further reading, this textbook is beneficial for students and practitioners in applied information technology, an