Advertisement

Parallel Data Warehouse Patterns

  • Andy Leonard
  • Matt Masson
  • Tim Mitchell
  • Jessica M. Moss
  • Michelle Ufford

Abstract

Microsoft’s SQL Server Parallel Data Warehouse (PDW) appliance was introduced with SQL Server 2008 R2 and is Microsoft’s first massively parallel processing (MPP) offering. Although PDW is built upon the SQL Server platform, it is a completely different product. As the name suggests, MPP uses multiple servers working as one system, called an appliance, to achieve much greater performance and scan rates than in traditional SMP systems. SMP refers to symmetric multi-processing; most database systems, such as all other versions of SQL Server, are SMP.

Keywords

Compute Node Integration Service Landing Zone Control Node Create Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, and Michelle Ufford 2012

Authors and Affiliations

  • Andy Leonard
  • Matt Masson
  • Tim Mitchell
  • Jessica M. Moss
  • Michelle Ufford

There are no affiliations available

Personalised recommendations