Microsoft SQL Server Parallel Data Warehouse – Architecture Overview


May 24, 2012


José Blakeley




In this talk, I present an architectural overview of the SQL Server Parallel Data Warehouse DBMS system. PDW is a massively parallel-processing, share-nothing, scaled-out version of SQL Server for DW workloads. The product is packaged as a database appliance built on industry-standard hardware.


José Blakeley

José Blakeley is partner architect in Microsoft’s Data Warehousing Product Unit in the Database Systems Group, where he contributed to the development of the Microsoft SQL Server Parallel Data Warehouse (PDW) Edition DBMS. A Microsoft employee since 1994, José’s other contributions include the development of the OLE DB data access interfaces, the integration of the .NET runtime with SQL Server 2005, the extensibility features in SQL Server, and the creation of the ADO.NET Entity Framework in Microsoft Visual Studio 2008. José has authored numerous conference papers, book chapters, and journal articles on design aspects of relational and object database management systems, as well as on data access. He has 20 patents awarded and 22 patents pending. José became an ACM Fellow in 2009. Before joining Microsoft, he was a member of the technical staff at Texas Instruments, where he was co-principal investigator of the DARPA Open-OODB system. He received a B.Eng. from the Monterrey Institute of Technology (ITESM) in Mexico and a PhD in computer science from the University of Waterloo in Canada.