Sql Server Cubes

Written by Jacey Harmon
Bookmark and Share

SQL Server is a Microsoft product used for data analysis and business intelligence applications. The program offers applications that can be used to analyze corporate data stored in databases. The analysis process can include designing and manipulating data cubes. A data cube is a multidimensional database that is comprised of a set of dimensions and measures.

SQL Server Data Cubes

To understand data cubes we must first take a look at databases. A database is what contains all the data used for data sources, cubes and dimensions. A database is the source of data when constructing a data cube or source. The term "data source" is often used to describe the source data. When dealing with SQL Server, the "data source" is what is used to establish connections with the source data.

Dimensions are part of the main structure behind a data cube. A dimension is any factor that can be grouped, recorded and catalogued. Dimensions are organized in hierarchal categories known as levels. For example, a company that sells shoes and shirts can create a shoe dimension in a data cube. Under the cube dimension each brand of shoe, i.e. Nike and Reebok will be a level under the shoe dimension. The dimension can be broken down even further to indicate the various models of shoes Nike and Reebok make.

Data cubes can be used for a variety of applications. The multidimensional aspect of each cube allows for an end user to manipulate data to identify trends. A data cube that analyzes sales can be used to direct a product to store locations that sell a high number of that product. Cubes can also be used to measure employee productivity or to analyze marketing campaigns.

Bookmark and Share


This is getting a bit more scbveutije, but I much prefer the Zune Marketplace. The interface is colorful, has more flair, and some cool features like Mixview' that let you quickly see related albums, songs, or other users related to what you're listening to. Clicking on one of those will center on that item, and another set of neighbors will come into view, allowing you to navigate around exploring by similar artists, songs, or users. Speaking of users, the Zune Social is also great fun, letting you find others with shared tastes and becoming friends with them. You then can listen to a playlist created based on an amalgamation of what all your friends are listening to, which is also enjoyable. Those concerned with privacy will be relieved to know you can prevent the public from seeing your personal listening habits if you so choose.