Abstract
This paper presents an architecture overview of the Microsoft SQL Server Parallel Data Warehouse (PDW) DBMS system. PDW is a massively parallel processing (MPP), share nothing, scale-out version of SQL Server focused on data warehousing workloads. The product is packaged as a database appliance built on industry standard hardware. We present an overview of the main software and hardware components of the system and an example illustrating its query processing approach.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Astrahan, M., et al.: System R: Relational Approach to Database Management. ACM TODS 1(2) (1976)
Stonebraker, M., et al.: The Design and Implementation of INGRES. ACM TODS 1(3) (1976)
Stonebraker, M., et al.: The End of an Architectural Era (It’s Time for a Complete Rewrite). In: Proc. VLDB (2007)
Agarwal, S., et al.: Microsoft SQL Server. In: Silberschatz, A., Korth, H.F., Sudarshan, S. (eds.) Database System Concepts, 6th edn., ch. 30. McGraw-Hill (January 2010)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Blakeley, J.A. et al. (2012). Microsoft SQL Server Parallel Data Warehouse: Architecture Overview. In: Castellanos, M., Dayal, U., Lehner, W. (eds) Enabling Real-Time Business Intelligence. BIRTE 2011. Lecture Notes in Business Information Processing, vol 126. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-33500-6_4
Download citation
DOI: https://doi.org/10.1007/978-3-642-33500-6_4
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-33499-3
Online ISBN: 978-3-642-33500-6
eBook Packages: Computer ScienceComputer Science (R0)