a HackerNoon project
Original · left

Schema (psychology)

A mental framework that organizes knowledge and expectations about the world.

First in use: the 1920s
Duplicate · right

Database schema

The formal structure of a database: its tables, columns, types and relationships.

First in use: the 1970s

Schema / Schema (psychology) / Database schema

Loading data…
Canonical todayMeasuring…
Status—
Duplicate share · 12 mo—
Last crossover—
Colour keyGrey · original meaningGreen · duplicate meaningAmber · contested (40–60%)How colours work

Piaget's mental frameworks vs. table definitions.

Which meaning of Schema is the original, and which one is the duplicate riding on its name? Schema (psychology) came first (the 1920s). Database schema arrived in the 1970s. The data below shows which one owns the word now.

Wikipedia pageviews since 2015

Schema (psychology)Database schema
English Wikipedia pageviews since July 2015 load here.

Duplicate's share of attention

Green line = duplicate's % · above 60 it owns the word · below 40 the original does

Share-of-attention line loads here.

The case for each meaning

Sourced definitions, usage stats and quotes

Original · the 1920s

Schema (psychology)

Loading the Wikipedia definition…

12-mo pageviews—
Year over year—
Peak month—
Duplicate · the 1970s

Database schema

Loading the Wikipedia definition…

12-mo pageviews—
Year over year—
Peak month—

More duplicated terms

Data & databases