A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Types of Data Models

Document Model
Document Model

When you start modeling data in a document store, such as Azure Cosmos DB, try to treat your entities as self-contained documents represented in JSON. Before we dive in too much further, let us take a few steps back and have a look at how we might model something in a relational database, a subject many of us are already familiar with.

Entity-Attribute-Value Model
Entity-Attribute-Value Model

What is an Entity-Attribute-Value model? These come in various levels of sophistication. At their simplest they may represent little more than a key-value pair with an additional field to denote the type of value being stored.

Entity-Relationship Model
Entity-Relationship Model

Entity Relationship Diagram, also known as ERD, ER Diagram or ER model, is a type of structural diagram for use in database design. An ERD contains different symbols and connectors that visualize two important information: The major entities within the system scope, and the inter-relationships among these entities.

image: cnx.org
Hierarchical Database Model
Hierarchical Database Model

A hierarchical database is a design that uses a one-to-many relationship for data elements. Hierarchical database models use a tree structure that links a number of disparate elements to one "owner," or "parent," primary record.

image: www2.amk.fi
Network Databases
Network Databases

Data Integrity: In a network model, there's always a connection between the parent and the child segments because it depends on the parent-child relationship. Data Independence: Data independence is better in network models as opposed to the hierarchical models.

Network Model
Network Model

Data Integrity: In a network model, there's always a connection between the parent and the child segments because it depends on the parent-child relationship. Data Independence: Data independence is better in network models as opposed to the hierarchical models.

Object-Oriented Database Model
Object-Oriented Database Model

ER data model is one of the important data model which forms the basis for the all the designs in the database world. It defines the mapping between the entities in the database. Object oriented data model, along with the mapping between the entities, describes the state of each entity and the tasks performed by them.

Object-Oriented Databases
Object-Oriented Databases

An object-oriented database is a database that subscribes to a model with information represented by objects. Object-oriented databases are a niche offering in the relational database management system (RDBMS) field and are not as successful or well-known as mainstream database engines.

Relational Databases
Relational Databases

The second major characteristic of the relational model is the usage of keys. These are specially designated columns within a relation, used to order data or relate data to other relations. One of the most important keys is the primary key, which is used to uniquely identify each row of data. To make querying for data easier, most relational databases go further and physically order the data by the primary key. Foreign keys relate data in one relation to the primary key of another relation.

Relational Model
Relational Model

The relational model is the conceptual basis of relational databases. Proposed by E.F. Codd in 1969, it is a method of structuring data using relations, which are grid-like mathematical structures consisting of columns and rows.

Star Schema
Star Schema

In data warehousing and business intelligence , a star schema is the simplest form of a dimensional model, in which data is organized into facts and dimensions. A fact is an event that is counted or measured, such as a sale or login.

Related Facts

Related Question Categories