Definition

Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW)

Contributor(s): Mark Fontecchio

Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW) is a pre-built data warehouse appliance that includes Microsoft SQL Server database software, third-party server hardware and networking components.

Parallel Data Warehouse has a massively parallel processing (MPP) architecture. As such, Microsoft has billed Parallel Data Warehouse as being well-tuned for big data processing.

Like other server appliances, one of the main features of Parallel Data Warehouse is that it is easier to set up when compared to buying commodity hardware and software and configuring them in house. There are currently two versions of Parallel Data Warehouse: one uses Hewlett-Packard servers and the other uses Dell hardware.

See also: data center in a box

This was last updated in August 2013

Continue Reading About Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW)

Dig Deeper on SQL Server Data Warehousing

PRO+

Content

Find more PRO+ content and other member only offers, here.

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

For more data about Microsoft Parallel Data WareHouse concepts goto http://www.pdwtutorial.com/
Cancel

-ADS BY GOOGLE

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close