SQL & NoSQL Databases Models, Languages, Consistency Options and Architectures for Big Data Management

<p></p><p>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.</p> <p>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:</p><p></p><ul><li>SQL and NoSQL databases, and their respective management systems<br></li><li>The nature and uses of Big Data<br></li><li>A high-level view of the organization of data management<br></li></ul><p></p> <b>Data Modeling and Consistency </b><p></p> <p>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.</p> <p>A full chapter probes the challenges of Ensuring Data Consistency, covering:</p><p></p><ul><li>Multi-User Operation<br></li><li>Troubleshooting<br></li><li>Consistency in Massive Distributed Data<br></li><li>Comparison of the ACID and BASE consistency models, and more<br></li></ul><p></p> <p>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. </p> <p><b>Post-Relational and NoSQL Databases</b></p> <p>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. </p> <p>A final chapter covers NoSQL Databases, along with</p><p></p><ul><li>Development of Non-Relational Technologies,<br></li><li>Key-Value, Column-Family and Document Stores<br></li><li>XML Databases and Graphic Databases, and more<br></li></ul><p></p> The book includes more than 100 tables, examples and illustrations, and each chapter offers a list of resources for further reading. <p></p> <p><i>SQL & NoSQL Databases</i> 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.</p><p>This textbook has been recommended and developed for university courses in Germany, Austria and Switzerland.<br></p><br><p></p>