schema

A formal description of the structure of data: which fields or columns exist, their types and which are required.

In more detail

A database schema defines tables, columns, keys and constraints; a message schema, such as a JSON Schema, defines the shape of data sent between programs. The schema is a contract with every program that reads or writes the data, so rules written into it apply to all of them.

Examples

In AWS: The structure of a database: its tables, columns, types, keys and relationships.
Avro and Protocol Buffers are schema-full formats; JSON is schema-less and self-describing.
In the browser: In IndexedDB the schema can only change inside an upgradeneeded event, triggered by opening the database with a higher version number.
In a SIEM, the schema decides that a source address is always source.ip (ECS) or src_endpoint.ip (OCSF), whatever the log said.
In this course: A fresh temporary schema per test group keeps database tests independent. In contract testing, the schema of a response is part of the promise between services.

Related terms

Taught in

References

Certification courses