Skip to Main Content
Programming SQL Server 2005
book

Programming SQL Server 2005

by Bill Hamilton
February 2006
Intermediate to advanced content levelIntermediate to advanced
586 pages
17h 35m
English
O'Reilly Media, Inc.
Content preview from Programming SQL Server 2005

Chapter 20. SQL Server Analysis Services (SSAS)

SQL Server Analysis Services (SSAS) provides online analytical processing (OLAP) and data mining functionality using a combination of client- and server-side components.

A data warehouse is a data repository used to overcome issues arising from performing strategic analysis on data in an online transaction processing (OLTP) database. An OLTP database supports the day-to-day business activity of the organization and is configured to let applications write data for a single transaction as quickly as possible. A data warehouse provides users easy access to information used to make strategic business decisions.

Dimension tables store information used to categorize and hierarchically organize the information stored in fact tables. The columns of a dimension table are called attributes . Attributes are used to hierarchically organize the rows of dimension tables in a way that is meaningful for business users.

OLAP is a combination of products and processes used to aggregate large amounts of heterogeneous data and interactively examine the results in a dimensional model. OLAP evolved from the need to interactively examine large volumes of data warehouse information.

Like a data warehouse, OLAP uses dimensional modeling to represent data. Unlike a data warehouse, which typically uses a relational database to store and access data, OLAP uses cubes—multidimensional data structures organized hierarchically along a business attribute for each dimension ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

Leonard Lobel and Andrew Brust

Publisher Resources

ISBN: 0596004796Supplemental ContentErrata Page