What does schema mean?
A schema is a structured plan or representation showing how the parts of a system are organized and how they relate to one another. Its best-known use is in computing, where a database schema specifies tables, fields, data types, and relationships; schemas can also describe structured formats such as JSON. In scholarly or analytical writing, the term can more broadly mean an underlying pattern or conceptual framework used to interpret a subject. The word suggests deliberate organization rather than simply listing separate elements. Although “scheme” overlaps with it and can also mean a systematic arrangement, “schema” more specifically emphasizes a defined structure and the relationships within it. Understanding schemas is useful because effective data systems, documents, and analytical arguments all depend on clearly organized components and coherent connections among them.
nounA structured representation or arrangement of information that defines how data, concepts, or other elements are organized. In computing, a schema is a formal description of the structure and relationships within a database or data format.
- A structured description or arrangement that specifies the components of a system and the relationships between them.
- A formal specification of the organization of data in a database or information system.
- A broader underlying form, pattern, or conceptual structure.
"The developer updated the database schema to accommodate new fields."
"The schema establishes the fields and relationships used by the application."
"Her account of the literary movement offered a schema for understanding its recurring imagery."
The plural is normally schemas. The technical form schemata is also used, especially in mathematical, philosophical, and linguistic contexts.
"The migrations must work with both schemas without corrupting existing records."
A schema is the invisible architecture that tells data where it belongs and how everything fits together.
Reviewed by Deb Chak, Editor. AI-assisted content curated by RJS Tech Solutions LLP.
Where does schema come from?
The word comes through Latin from Greek skhēma, meaning a figure, form, or appearance. Greek philosophers used the term for the underlying form or arrangement that gives a thing its identity, and English later adopted it in philosophical and scientific writing. Its modern association with databases developed during the twentieth century as computing systems needed explicit descriptions of how stored information was organized.
Related word forms
How schema is actually used
In modern technical usage, especially in computing, the word is most commonly associated with databases, data formats, and validation systems. In broader analytical contexts, it can denote an analytical framework without implying a database.
Easily confused with schema
A schema primarily describes an organized structure or the relationships among components, whereas a scheme more broadly denotes a plan, system, or method of doing something.