- Dedicated trainers
- Maximum 6 per class
- Superb courseware
Phone (01457) 858877 or email
DATA STRUCTURES IN SQL SERVER ANALYSIS SERVICES
Part one of a four-part series of blogs
This series of blogs introduces the basic data structures for storing data, including OLTP and OLAP databases.
- Types of Data Storage Structures (this article)
- Comparison of the Two Storage Methods
- Cubes in SQL Server Analysis Services
- Summary of Jargon in SQL Server Analysis Services
Types of Data Storage Structures
There are two main types of storage structure used in the database world: relational databases and multi-dimensional models.
Relational Databases
The following is a sample relational database of films, containing 3 tables:
In our sample database there are:
- 40 film studios
- 121 directors; and
- 260 films
Thus in total there are 421 records spread over the 3 tables. The lines joining the tables together are called relationships.
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;
- The film studio; and
- The film director
The statistic being displayed (here the number of films) is called the measure.
DATA STRUCTURES IN SQL SERVER ANALYSIS SERVICES
Part one of a four-part series of blogs
This series of blogs introduces the basic data structures for storing data, including OLTP and OLAP databases.
- Types of Data Storage Structures (this article)
- Comparison of the Two Storage Methods
- Cubes in SQL Server Analysis Services
- Summary of Jargon in SQL Server Analysis Services
Comments on this blog
This blog currently has no comments.