{"id":829,"date":"2014-05-08T15:28:42","date_gmt":"2014-05-08T19:28:42","guid":{"rendered":"http:\/\/binaryworld.net\/blogs\/?p=829"},"modified":"2015-12-01T16:37:36","modified_gmt":"2015-12-01T21:37:36","slug":"pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system","status":"publish","type":"post","link":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/","title":{"rendered":"Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW)"},"content":{"rendered":"<p><a title=\"Microsoft Parallel Data Warehouse (PDW)\" href=\"http:\/\/technet.microsoft.com\/en-us\/video\/sql-server-parallel-data-warehouse-2008-r2-whats-in-it-for-me.aspx\" target=\"_blank\"><strong>Microsoft Parallel Data Warehouse (PDW)<\/strong><\/a> also known as <strong>Microsoft Analytics Platform System (APS)<\/strong>\u00a0is a special version of <strong>SQL Server<\/strong> designed to\u00a0handle petabytes worth of data. It has very different architecture compared to traditional Symmetric Multiprocessing (<a title=\"SMP System\" href=\"http:\/\/en.wikipedia.org\/wiki\/Symmetric_multiprocessing\" target=\"_blank\"><strong>SMP<\/strong><\/a>) System. Check below presentation to learn more about PDW system. PDW System comes as Appliance with configured software along with it. So there is no way you can test PDW unless you have test hardware. Throughout this article I will refer <em>Microsoft SQL Server Parallel Datawarehouse<\/em> as <strong>PDW<\/strong>. \u00a0<\/p>\n<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#What_is_Microsoft_Parallel_Data_Warehouse\"><span class=\"toc_number toc_depth_1\">1<\/span> What is Microsoft Parallel Data Warehouse<\/a><\/li><li><a href=\"#Architecture_Diagram_of_Microsoft_Parallel_DataWarehouse_PDW\"><span class=\"toc_number toc_depth_1\">2<\/span> Architecture Diagram of Microsoft Parallel DataWarehouse (PDW)<\/a><\/li><li><a href=\"#PDW_cost_comparision_with_other_Vendors\"><span class=\"toc_number toc_depth_1\">3<\/span> PDW cost comparision with other Vendors<\/a><\/li><li><a href=\"#PowerPoint_Presentation_of_Parallel_Data_Warehouse_PDW\"><span class=\"toc_number toc_depth_1\">4<\/span> PowerPoint Presentation of Parallel Data Warehouse (PDW) \u00a0<\/a><\/li><li><a href=\"#Introduction_Video_Tutorial_8211_PDW_8211_Microsoft_Parallel_Data_Warehouse\"><span class=\"toc_number toc_depth_1\">5<\/span> Introduction Video Tutorial &#8211; PDW &#8211; Microsoft Parallel Data Warehouse<\/a><\/li><li><a href=\"#PDW_Hardware_8211_Microsoft_Parallel_Data_Warehouse\"><span class=\"toc_number toc_depth_1\">6<\/span> PDW Hardware &#8211; Microsoft Parallel Data Warehouse\u00a0<\/a><\/li><\/ul><\/div>\n<h2><span id=\"What_is_Microsoft_Parallel_Data_Warehouse\">What is Microsoft Parallel Data Warehouse<\/span><\/h2>\n<ul>\n<li>In simple term its special version of <strong>sql server<\/strong> designed to handle massive parallel processing (<a href=\"http:\/\/en.wikipedia.org\/wiki\/Massive_parallel_processing\">MPP<\/a>).<\/li>\n<li>Parallel Data Warehouse has few types of Nodes to handle various activities within your PDW Appliances.\n<ul>\n<li><strong>PDW Control Node<\/strong>\u00a0 (Active\/Passive Cluster) &#8211; This is entry point of all your data read\/write requests. User will always send query to this node. This is SQL Server Instance contains Metadata about PDW.<\/li>\n<li><strong>PDW Management Node<\/strong> \u00a0(Active\/Passive Cluster) &#8211; This node handles all patching related actions. Sending new Images to all compute nodes and applying seprvice packs.<\/li>\n<li><strong>PDW Landing Zone<\/strong> &#8211; This is where High performance Bulk dataloading can happen. User can FTP\/SFTP files to this node and then call <em>DWLoader<\/em> to Bulk load data into PDW. You may also use Traditional <strong>ETL Tool<\/strong> to load data such as use <strong>SSIS or Informatica<\/strong>.<\/li>\n<li><strong>PDW Backup Node<\/strong> &#8211; This node is responsible for backup related activities<\/li>\n<li><strong>PDW Compute Node<\/strong> &#8211; This is where actual query processing happens. Compute Node is dedicated SQL Server Intance behind the scene which user dont see but each query you send to PDW is distributed across all Compute nodes.\u00a0<\/li>\n<li><strong>PDW Storage Node<\/strong> &#8211; This is where data is stored. Each storage node is directly attached to Compute Node using <em>Fiber Channel<\/em> and all Nodes connected to each other using Highspeed Network called <a title=\"PDW connected by InfiniBand Network\" href=\"http:\/\/en.wikipedia.org\/wiki\/Infiniband\" target=\"_blank\">InfiniBand<\/a>\u00a0<\/li>\n<\/ul>\n<\/li>\n<li><em>Parallel Data Warehouse<\/em> comes with Minimum 2 Server Racks (As of now\u00a0two vendors\u00a0HP and Dell sell PDW Appliances). You can add more data racks to scale as you need\u00a0<\/li>\n<li><em>SQL Server <strong>PDW<\/strong><\/em> can store several petabytes worth of data compared to few Terabytes in traditional SQL Server (e.g Standard or\u00a0Enterprise Edition)<\/li>\n<li>PDW Stores data in 3 different ways.\n<ul>\n<li>Replicated tables<\/li>\n<li>Distributed tables<\/li>\n<li><\/li>\n<\/ul>\n<\/li>\n<li><em>SQL Server <strong>PDW<\/strong><\/em> System comes as base preconfigured hardware and software which can be scaled as needed according to data growth<\/li>\n<li><strong>PDW<\/strong> requires less DBA work compared to traditional Database system because there is less maintenance and setup compared to normal SQL Server.<\/li>\n<li><strong>PDW<\/strong> system uses Shared Nothing approach means each node has its own node and own processer\/memory and nothing is shared with other node compared to Clustered environment where disks are shared.<\/li>\n<li><strong>PDW<\/strong> scale several times more than regular sql server. <strong>PDW<\/strong> requires special hardware which must follow Microsoft PDW Hardware guideline.<\/li>\n<li><strong>PDW<\/strong>\u00a0 is several times more expensive compared to regular SQL Server but it gives you massive query performance in both read and write because of distributed approach.<\/li>\n<\/ul>\n<h2><span id=\"Architecture_Diagram_of_Microsoft_Parallel_DataWarehouse_PDW\">Architecture Diagram of Microsoft Parallel DataWarehouse (PDW)<\/span><\/h2>\n<p>Here is high level <em>diagram of Microsoft Parallel Data warehouse<\/em>.<\/p>\n<figure id=\"attachment_850\" aria-describedby=\"caption-attachment-850\" style=\"width: 747px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/Microsoft-Parallel-Datawarehouse-Architecture-diagram.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-850\" alt=\"Microsoft Parallel Datawarehouse Architecture Diagram\" src=\"http:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/Microsoft-Parallel-Datawarehouse-Architecture-diagram.png\" width=\"747\" height=\"573\" srcset=\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/Microsoft-Parallel-Datawarehouse-Architecture-diagram.png 747w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/Microsoft-Parallel-Datawarehouse-Architecture-diagram-300x230.png 300w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/Microsoft-Parallel-Datawarehouse-Architecture-diagram-100x76.png 100w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/Microsoft-Parallel-Datawarehouse-Architecture-diagram-150x115.png 150w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/Microsoft-Parallel-Datawarehouse-Architecture-diagram-200x153.png 200w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/Microsoft-Parallel-Datawarehouse-Architecture-diagram-450x345.png 450w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/Microsoft-Parallel-Datawarehouse-Architecture-diagram-600x460.png 600w\" sizes=\"(max-width: 747px) 100vw, 747px\" \/><\/a><figcaption id=\"caption-attachment-850\" class=\"wp-caption-text\">Microsoft Parallel Datawarehouse Architecture Diagram<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<h2><span id=\"PDW_cost_comparision_with_other_Vendors\">PDW cost comparision with other Vendors<\/span><\/h2>\n<p>Here is simple PDW cosnt comparision chart based on various factors\u00a0(<a title=\"PDW Cost comparision\" href=\"http:\/\/www.valueprism.com\/resources\/resources\/Resources\/PDW%20Compete%20Pricing%20FINAL.pdf\" target=\"_blank\">Source<\/a>) As you can see PDW appliances highly competitive in terms of Price per TB compared to other vendors selling similar offering.<\/p>\n<figure id=\"attachment_851\" aria-describedby=\"caption-attachment-851\" style=\"width: 700px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/pdw-cost-compare-with-other-vendors.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-851\" alt=\"PDW Cost Comparison with other Vendors\" src=\"http:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/pdw-cost-compare-with-other-vendors.jpg\" width=\"700\" height=\"536\" srcset=\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/pdw-cost-compare-with-other-vendors.jpg 700w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/pdw-cost-compare-with-other-vendors-300x229.jpg 300w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/pdw-cost-compare-with-other-vendors-100x76.jpg 100w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/pdw-cost-compare-with-other-vendors-150x114.jpg 150w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/pdw-cost-compare-with-other-vendors-200x153.jpg 200w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/pdw-cost-compare-with-other-vendors-450x344.jpg 450w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/pdw-cost-compare-with-other-vendors-600x459.jpg 600w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><figcaption id=\"caption-attachment-851\" class=\"wp-caption-text\">PDW Cost Comparison with other Vendors<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<h2><span id=\"PowerPoint_Presentation_of_Parallel_Data_Warehouse_PDW\">PowerPoint Presentation of Parallel Data Warehouse (PDW) \u00a0<\/span><\/h2>\n<p>\u00a0<iframe loading=\"lazy\" src=\"https:\/\/onedrive.live.com\/embed?cid=3BF17AFBA9CDFF3E&amp;resid=3BF17AFBA9CDFF3E%2117610&amp;authkey=AMWadcIhDGXquD0&amp;em=2\" height=\"488\" width=\"600\" frameborder=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<h2><span id=\"Introduction_Video_Tutorial_8211_PDW_8211_Microsoft_Parallel_Data_Warehouse\">Introduction Video Tutorial &#8211; PDW &#8211; Microsoft Parallel Data Warehouse<\/span><\/h2>\n<p>\u00a0[embedyt]http:\/\/www.youtube.com\/watch?v=AnxJ4OtmGsk[\/embedyt]<\/p>\n<h2><span id=\"PDW_Hardware_8211_Microsoft_Parallel_Data_Warehouse\">PDW Hardware &#8211; Microsoft Parallel Data Warehouse\u00a0<\/span><\/h2>\n<figure id=\"attachment_830\" aria-describedby=\"caption-attachment-830\" style=\"width: 550px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-830\" alt=\"PDW - Parallel Data Warehouse Hardware\" src=\"http:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform-1024x605.jpg\" width=\"550\" height=\"324\" srcset=\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform-1024x605.jpg 1024w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform-300x177.jpg 300w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform-100x59.jpg 100w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform-150x88.jpg 150w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform-200x118.jpg 200w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform-450x266.jpg 450w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform-600x354.jpg 600w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform-900x532.jpg 900w, https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/05\/microsoft-pdw-parallel-data-warehouse-aps-analytics-platform.jpg 1196w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/a><figcaption id=\"caption-attachment-830\" class=\"wp-caption-text\">Microsoft SQL Server Parallel Data Warehouse (PDW) Hardware<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Parallel Data Warehouse (PDW) also known as Microsoft Analytics Platform System (APS)\u00a0is a special version of SQL Server designed to\u00a0handle petabytes worth of data. It has very different architecture compared to traditional Symmetric Multiprocessing (SMP) System. Check below presentation &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/\"> <span class=\"screen-reader-text\">Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW)<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":773,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[125,126],"tags":[132,131,124,123,133],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW) - BinaryWorld Blog<\/title>\r\n<meta name=\"description\" content=\"Microsoft Parallel Data Warehouse (PDW) also known as Microsoft Analytics Platform System (APS) is a special version of SQL Server designed to handle petabytes worth of data. It has very different architecture compared to traditional Symmetric Multiprocessing (SMP) System.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW) - BinaryWorld Blog\" \/>\r\n<meta property=\"og:description\" content=\"Microsoft Parallel Data Warehouse (PDW) also known as Microsoft Analytics Platform System (APS) is a special version of SQL Server designed to handle petabytes worth of data. It has very different architecture compared to traditional Symmetric Multiprocessing (SMP) System.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/\" \/>\r\n<meta property=\"og:site_name\" content=\"BinaryWorld Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2014-05-08T19:28:42+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2015-12-01T21:37:36+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/04\/sql-server-pdw-parallel-data-warehouse-logo.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"150\" \/>\r\n\t<meta property=\"og:image:height\" content=\"150\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\r\n<meta name=\"author\" content=\"Binary World\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Binary World\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/\",\"url\":\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/\",\"name\":\"Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW) - BinaryWorld Blog\",\"isPartOf\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/04\/sql-server-pdw-parallel-data-warehouse-logo.jpg\",\"datePublished\":\"2014-05-08T19:28:42+00:00\",\"dateModified\":\"2015-12-01T21:37:36+00:00\",\"author\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0\"},\"description\":\"Microsoft Parallel Data Warehouse (PDW) also known as Microsoft Analytics Platform System (APS) is a special version of SQL Server designed to handle petabytes worth of data. It has very different architecture compared to traditional Symmetric Multiprocessing (SMP) System.\",\"breadcrumb\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#primaryimage\",\"url\":\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/04\/sql-server-pdw-parallel-data-warehouse-logo.jpg\",\"contentUrl\":\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/04\/sql-server-pdw-parallel-data-warehouse-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"Sql ServerParallel Data Warehouse (PDW)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/binaryworld.net\/blogs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/#website\",\"url\":\"https:\/\/binaryworld.net\/blogs\/\",\"name\":\"BinaryWorld Blog\",\"description\":\"Tips and Tutorials for Microsoft SQL Server, SSIS, SSAS, Business Intelligence, C#, .net\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/binaryworld.net\/blogs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0\",\"name\":\"Binary World\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g\",\"caption\":\"Binary World\"},\"description\":\"Binary World is a Software Development company located in Atlanta, USA (since 2007). Binary World specialized in Business Intelligence, mobile, cloud computing and .Net Application Development.\",\"url\":\"https:\/\/binaryworld.net\/blogs\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW) - BinaryWorld Blog","description":"Microsoft Parallel Data Warehouse (PDW) also known as Microsoft Analytics Platform System (APS) is a special version of SQL Server designed to handle petabytes worth of data. It has very different architecture compared to traditional Symmetric Multiprocessing (SMP) System.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/","og_locale":"en_US","og_type":"article","og_title":"Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW) - BinaryWorld Blog","og_description":"Microsoft Parallel Data Warehouse (PDW) also known as Microsoft Analytics Platform System (APS) is a special version of SQL Server designed to handle petabytes worth of data. It has very different architecture compared to traditional Symmetric Multiprocessing (SMP) System.","og_url":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/","og_site_name":"BinaryWorld Blog","article_published_time":"2014-05-08T19:28:42+00:00","article_modified_time":"2015-12-01T21:37:36+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/04\/sql-server-pdw-parallel-data-warehouse-logo.jpg","type":"image\/jpeg"}],"author":"Binary World","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Binary World","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/","url":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/","name":"Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW) - BinaryWorld Blog","isPartOf":{"@id":"https:\/\/binaryworld.net\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#primaryimage"},"image":{"@id":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#primaryimage"},"thumbnailUrl":"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/04\/sql-server-pdw-parallel-data-warehouse-logo.jpg","datePublished":"2014-05-08T19:28:42+00:00","dateModified":"2015-12-01T21:37:36+00:00","author":{"@id":"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0"},"description":"Microsoft Parallel Data Warehouse (PDW) also known as Microsoft Analytics Platform System (APS) is a special version of SQL Server designed to handle petabytes worth of data. It has very different architecture compared to traditional Symmetric Multiprocessing (SMP) System.","breadcrumb":{"@id":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#primaryimage","url":"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/04\/sql-server-pdw-parallel-data-warehouse-logo.jpg","contentUrl":"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/04\/sql-server-pdw-parallel-data-warehouse-logo.jpg","width":150,"height":150,"caption":"Sql ServerParallel Data Warehouse (PDW)"},{"@type":"BreadcrumbList","@id":"https:\/\/binaryworld.net\/blogs\/pdw-presentation-microsoft-parallel-data-warehouse-aps-analytics-platform-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/binaryworld.net\/blogs\/"},{"@type":"ListItem","position":2,"name":"Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW)"}]},{"@type":"WebSite","@id":"https:\/\/binaryworld.net\/blogs\/#website","url":"https:\/\/binaryworld.net\/blogs\/","name":"BinaryWorld Blog","description":"Tips and Tutorials for Microsoft SQL Server, SSIS, SSAS, Business Intelligence, C#, .net","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/binaryworld.net\/blogs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0","name":"Binary World","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g","caption":"Binary World"},"description":"Binary World is a Software Development company located in Atlanta, USA (since 2007). Binary World specialized in Business Intelligence, mobile, cloud computing and .Net Application Development.","url":"https:\/\/binaryworld.net\/blogs\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/posts\/829"}],"collection":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/comments?post=829"}],"version-history":[{"count":0,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/posts\/829\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/media\/773"}],"wp:attachment":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/media?parent=829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/categories?post=829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/tags?post=829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}