You're reading from Database Design and Modeling with PostgreSQL and MySQL Build efficient and scalable databases for modern applications using open source databases

Product type Paperback

Published in Jul 2024

Publisher Packt

ISBN-13 9781803233475

Length 222 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Artificial Intelligence

Authors (2):

Alkin Tezuysal

Ibrar Ahmed

View More author details

Table of Contents (16) Chapters

Preface

1. Part 1: Introduction to Databases

2. Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs FREE CHAPTER

3. Chapter 2: Building a Strong Foundation for Database Design

4. Part 2: Practical Implementation

5. Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL

6. Part 3: Core Concepts in Database Design

7. Chapter 4: Mastering the Building Blocks of Database Design and Modeling

8. Part 4: Advanced Database Techniques

9. Chapter 5: Advanced Techniques for Advanced Databases

10. Chapter 6: Understanding Database Scalability

11. Part 5: Best Practices and Future Trends

12. Chapter 7: Best Practices for Building and Maintaining Your Database

13. Chapter 8: The Future of Databases and Their Designs

14. Index

Why subscribe?

15. Other Books You May Enjoy

Introduction to columnar databases with ClickHouse

Columnar databases represent a significant shift in database technology, optimizing for speed and efficiency in data analytics and read-heavy operations. Unlike traditional row-oriented databases, columnar databases store data by column rather than by row, providing substantial performance advantages for querying large datasets. Among the leading columnar databases is ClickHouse, an open source, high-performance columnar database management system designed for OLAP.

What is ClickHouse?

ClickHouse was initially developed by Yandex to manage and analyze web analytics data. It excels in real-time query execution and can generate analytical data reports in milliseconds, even across billions of rows and terabytes of data. The ClickHouse architecture is shown in the following diagram: