> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Data modelling overview

> Overview of Data Modelling

This section is about data modeling in ClickHouse and contains the following topics:

| Page                                                                                        | Description                                                                                                                                                                                   |
| ------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [Schema Design](/guides/clickhouse/data-modelling/schema-design)                            | Discusses ClickHouse schema design for optimal performance, considering factors like queries, data updates, latency, and volume.                                                              |
| [Dictionary](/concepts/features/dictionaries/index)                                         | An explainer on how to define and use dictionaries to improve query performance and enrich data.                                                                                              |
| [Materialized Views](/concepts/features/materialized-views/index)                           | Information on Materialized Views and Refreshable Materialized Views in ClickHouse.                                                                                                           |
| [Projections](/concepts/features/projections/projections)                                   | Information on Projections in ClickHouse.                                                                                                                                                     |
| [Data Compression](/guides/clickhouse/data-modelling/compression/compression-in-clickhouse) | Discusses various compression modes in ClickHouse and how to optimize data storage and query performance by choosing the right compression method for your specific data types and workloads. |
| [Denormalizing Data](/guides/clickhouse/data-modelling/denormalization)                     | Discusses the denormalization approach used in ClickHouse which aims to improve query performance by storing related data in a single table.                                                  |