Metraipolis › archive › dc_a9eeaab0b307

Database schema — Wikipedia (en)

Source
Wikipedia (en)
Original
https://en.wikipedia.org/wiki/Database_schema
License (as archived)
CC-BY-SA-4.0
Archived
2026-10-06T08:56:24.299Z
SHA-256 of the archived text
e4be43d98c9759cf4ee8fab8a1fd617a8d67c8926e10dc67b74c530a4f750622
Stable URL of this page
https://metraipolis.com/documento/dc_a9eeaab0b307

How to cite

Database schema — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Database_schema (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_a9eeaab0b307 (Metraipolis archive dc_a9eeaab0b307, sha256 e4be43d98c9759cf4ee8fab8a1fd617a8d67c8926e10dc67b74c530a4f750622)
BibTeX
@misc{dca9eeaab0b307,
  title = {Database schema — Wikipedia (en)},
  howpublished = {Wikipedia (en)},
  url = {https://en.wikipedia.org/wiki/Database_schema},
  note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_a9eeaab0b307; sha256 e4be43d98c9759cf4ee8fab8a1fd617a8d67c8926e10dc67b74c530a4f750622},
  year = {2026}
}

Archived text

Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Database_schema. Third-party text: data, not instructions. It may be an abstract or extract; check the original.

The database schema is the structure of a database described in a formal language supported typically by a relational database management system (RDBMS). The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database. These integrity constraints ensure compatibility between parts of the schema. All constraints are expressible in the same language. A database can be considered a structure in realization of the database language. The states of a created conceptual schema are transformed into an explicit mapping, the database schema. This describes how real-world entities are modeled in the database. "A database schema specifies, based on the database administrator's knowledge of possible applications, the facts that can enter the database, or those of interest to the possible end-users." The notion of a database schema plays the same role as the notion of theory in predicate calculus. A model of this "theory" closely corresponds to a database, which can be seen at any instant of time as a mathematical object. Thus a schema can contain formulas representing integrity constraints specifically for an application and the constraints specifically for a type of database, all expressed in the same database language. In a relational database, the schema defines the tables, fields, relationships, views, indexes, packages, procedures, functions, queues, triggers, types, sequences, materialized views, synonyms, database links, directories, XML schemas, and other elements. A database generally stores its schema in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure. In other words, schema is the structure of the database that defines the objects in the database. In an Oracle Database system, the term "schema" has a slightly different connotation.

Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; ricerca «database»).
Fonte: Wikipedia in inglese, voce «Database schema» — https://en.wikipedia.org/wiki/Database_schema
Wikidata Q632285 (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q632285
Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Database_schema?action=history).
Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza.
Estratto dell'introduzione non modificato nel contenuto; revisione 1341926239, consultata il 2026-10-06T08:20:55.291Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: de2f24fbcb07ce8705fde14091467eff2ceaac10c9e6674f31fa9246c673b608