External Schema
The word schema as defined in the dictionary means plan, diagram, scheme or an underlying organizational structure. Therefore, as can be very briefly said, an external schema is a plan on how to stru...
Information Technology
Entity Structure Chart
An entity structure chart is a visual representation of everything related to the entities related to the business rules, activities as well as the data model for the company in its database, data wa...
Entity Relation Diagram
Entity Relation Diagram which is also known as an E-R diagram is a data relation diagram. The entity relation diagram uses specialized graphical symbols for illustrating all of the interrelatio...
Entity Attribute Value (EAV)
Entity Attribute Values What is an Entity-Attribute-Value Model (EAV)? The Entity-Attribute-Value model or EAV is also sometimes referred to at the Object-Attribute-Value Model, or even the Open Sch...
XML Database
What is an XML database? The XML database is most commonly described as a data persistence system that enables data to be accessed, exported, and imported. XML stands for Extensible Markup Language.
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...
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...
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...