Database schema

schemarelational schemaschemasdata schemadatabase schemasschema object
The database schema of a database is its structure described in a formal language supported by the database management system (DBMS).wikipedia
158 Related Articles

Schema

Schema (disambiguation)schemas
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).

Database

database management systemdatabasesDBMS
The database schema of a database is its structure described in a formal language supported by the database management system (DBMS). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database.
Having produced a conceptual data model that users are happy with, the next stage is to translate this into a schema that implements the relevant data structures within the database.

Data integrity

integrityintegrity constraintsDatabase integrity
The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database.
Data integrity often includes checks and correction for invalid data, based on a fixed schema or a predefined set of rules.

Synonym (database)

synonym
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 synonym is an alias or alternate name for a table, view, sequence, or other schema object.

Schema matching

schema mappingunified
For this article, we differentiate the two as follows: Schema matching is the process of identifying that two objects are semantically related (scope of this article) while mapping refers to the transformations between the objects.

Data dictionary

data dictionariesData Description SpecificationsDDS
A database generally stores its schema in a data dictionary.

Formal language

formal language theoryformal languageslanguage
The database schema of a database is its structure described in a formal language supported by the database management system (DBMS).

Query language

querydatabase query languageData query language
A database can be considered a structure in realization of the database language.

Conceptual schema

conceptual data model.cdmconcept-level schema
The states of a created conceptual schema are transformed into an explicit mapping, the database schema.

Explicit and implicit methods

explicitimplicitexplicit method
The states of a created conceptual schema are transformed into an explicit mapping, the database schema.

Data modeling

data modellingmodelingmodeled
This describes how real-world entities are modeled in the database.

Database administrator

database administratorsDBADatabase Administration
"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."

End user

end-userend-usersend users
"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."

First-order logic

predicate logicfirst-orderpredicate calculus
The notion of a database schema plays the same role as the notion of theory in predicate calculus.

Mathematical object

mathematical objectsobjectsgeometric object
A model of this "theory" closely corresponds to a database, which can be seen at any instant of time as a mathematical object.

Table (database)

tabletablesdatabase table
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.

Field (computer science)

fieldsfielddata fields
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.

View (SQL)

viewviewsdatabase view
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.

Database index

indexindexesindexing
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.

Package manager

package management systempackagesoftware package
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.

Stored procedure

stored proceduresproceduresdatabase procedures
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.

Subroutine

functionfunctionssubroutines
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.

Queue (abstract data type)

queuequeuesFIFO queues
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.

Database trigger

triggerstriggerprocedural triggers
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.

Data type

typedatatypetypes
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.