# Data modelling

Data modelling connects table value contracts with the way an application reads and changes rows. These guides use explicit CoordinatorDB schemas and queries, including the limits of snapshot tables and prepared-statement interfaces.

## Guides

* [Backfill a table](https://coordinatordb.com/docs/guides/clickhouse/data-modelling/backfilling)
* [Combine related data](https://coordinatordb.com/docs/guides/clickhouse/data-modelling/denormalization)
* [Generate test data](https://coordinatordb.com/docs/guides/clickhouse/data-modelling/generating-test-data)
* [Design a schema](https://coordinatordb.com/docs/guides/clickhouse/data-modelling/schema-design)
* [Prepared statements](https://coordinatordb.com/docs/guides/clickhouse/data-modelling/stored-procedures-and-prepared-statements)