Star Schema
The star schema, which is sometimes called a star join schema, is one of the most simple styles of a data warehouse schema. It consists of a few fact tables that reference any number of dimension tab...
Data Modeling
Star Schema
What is the Star Schema? The Star Schema is basically the simplest form of a data warehouse. This schema is made up of fact tables and dimension table. We have covered dimension tables in previous ar...
Semi-Structured Model
Semi-Structured Data Model What is the Semi-Structured Data Model? The semi-structured data model is a data model where the information that would normal be connected to a schema is instead contained...
Relational Model
What is a Relational Model? The Relational Model is a clean and simple model that uses the concept of a relation using a table rather then a graph or shapes. The information is put into a grid like s...
Network Model
The Network Model What is a Network Model? Oddly enough the Network model was designed to do what the Hierarchical model could not. Though both show how data is related the Network model allows for d...
The Multi-Dimensional Model
The Multi-Dimensional Model What is a Multi-dimensional Model? Multi-dimensional model is an integral aspect of the On-line Analytical Processing which also known as OLAP.
The Hierarchical Model
Hierarchical model What is a Hierarchical model? The term Hierarchical model is extremely and vastly broad. It often refers to a lot of set ups, set ups something like Multi-Level models where there ...
The Associative Model
What is the Associative Data Model? The Associative data model is a model for databases unlike any of those we spoke of in prior articles. Unlike the relational model, which is record based and deals...
The Object Model
What is the Object Model? The Object model, also referred to as the object oriented model was designed to add database functionality to object programming languages. Object models help to extend the ...
Object-Relational Model
Object-Relational Model What is the Object-Relational Model? The object-relational model is designed to provide a relational database management that allows developers to integrate databases with the...