What is Schema

Definition

A schema is the formal definition of how data is structured, specifying the fields, their data types, relationships, and constraints within a dataset or database, providing the blueprint that tells systems and people how to interpret and validate the data.

« Back to Glossary Index

Provides a clear blueprint of fields, types, and relationships
Enables validation so data conforms to expected structure
Acts as a shared contract between systems producing and consuming data
Improves data quality and interoperability through enforced consistency

Real World Example

A database schema for an orders system defines the order table's columns, their types, and its foreign-key link to customers, so every application reading the data interprets and validates it the same way.

FAQs

What does a schema define?

It defines the fields, data types, relationships, and constraints that describe how data in a dataset or database is structured.

Why are schemas important?

They ensure data is consistent and interpretable, acting as a shared contract between producers and consumers of the data.

What is the difference between logical and physical schema?

A logical schema describes structure and relationships conceptually, while a physical schema describes how that data is actually stored.