Definition

Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW)

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

Contributor(s): Mark Fontecchio
This was last updated in August 2013
Posted by: Margaret Rouse

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
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

Do you have something to add to this definition? Let us know.

Send your comments to [email protected]