BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 16 May 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Types of Data Storage Structures
There are two main types of storage structure used in the database world: relational databases and multi-dimensional models.
The following is a sample relational database of films, containing 3 tables:
Relational databases are good at fast, day-to-day transactions: entering, editing and deleting records one at a time.
Unified Dimensional Model (UDM)
Another way to look at the same data is dimensionally:
Here the dimensions are;