Database model

data design modeldatabasedata modelmodels
A database model is a type of data model that determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized and manipulated.wikipedia
102 Related Articles

Relational model

relationalrelational data modelrelationships
The most popular example of a database model is the relational model, which uses a table-based format.
Other models are the hierarchical model and network model.

Database

database management systemdatabasesDBMS
A database model is a type of data model that determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized and manipulated.
Computer scientists may classify database-management systems according to the database models that they support.

Network model

networknetwork databasenetwork data model
The network model expands upon the hierarchical structure, allowing many-to-many relationships in a tree-like structure that allows multiple parents.
The network model is a database model conceived as a flexible way of representing objects and their relationships.

Data model

structured datastructuredData models
A database model is a type of data model that determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized and manipulated.

Data

statistical datascientific datadatum
A database model is a type of data model that determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized and manipulated. The flat (or table) model consists of a single, two-dimensional array of data elements, where all members of a given column are assumed to be similar values, and all members of a row are assumed to be related to one another.

Logical schema

logical data modelschemadatabase schema
Common logical data models for databases include:

Object-relational database

object-relationalobject-relational database management systemobject extensions
An object-relational database combines the two related structures.

Physical schema

physical data model.pdmPhysical architecture
Various physical data models can implement any given logical model.

Entity–relationship model

entity-relationship modelentity-relationshipEntity-relationship diagram

Object database

object-oriented databaseobject-oriented databasesobject persistence
Most object databases (invented in the 1990s) use the navigational concept to provide fast navigation across networks of objects, generally using object identifiers as "smart" pointers to related objects.

Document-oriented database

document databasedocumentdocument-oriented
Document-oriented database Clusterpoint uses inverted indexing model to provide fast full-text search for XML or JSON data objects for example.

Star schema

starstar-like schema
The dimensional model is often implemented on top of the relational model using a star schema, consisting of one highly normalized table containing the facts, and surrounding denormalized tables containing each dimension.

Inverted index

inverted fileinverted listindex
In an inverted file or inverted index, the contents of the data are used as keys in a lookup table, and the values in the table are pointers to the location of each instance of a given content item.

Flat-file database

flat fileflat file databaseflat files
The flat (or table) model consists of a single, two-dimensional array of data elements, where all members of a given column are assumed to be similar values, and all members of a row are assumed to be related to one another.

MultiValue

MultiValue databaseMultivalue modelmulti-valued

Semantic data model

semantic data modelingdata semanticssemantic knowledge extraction

Select (SQL)

SELECTSQL query keyword
The relational model, for example, defines operations such as select (project) and join.

Projection (relational algebra)

projectionprojectionsproject
The relational model, for example, defines operations such as select (project) and join.