Parallel Data Warehouse (PDW)

Parallel Data Warehouse Appliance

SQL Server 2008 R2 Parallel Data Warehouse is a highly scalable appliance for enterprise data warehousing. SQL Server 2008 R2 Parallel Data Warehouse uses massively parallel processing (MPP) to deliver the high performance and scalability with SQL Server 2008 R2 and industry-standard hardware. The MPP architecture helps enable better scalability, better and more predictable performance, reduced risk and a lower cost per terabyte than other DW solutions.

Benefits

  • Extract more value from existing BI investments through tight integration of SQL Server 2008 R2 Parallel Data Warehouse and Microsoft BI tools
     
  • Integrates with SQL Server technologies including Integration Services, Reporting Services and Analysis Services
     
  • Existing SMP data marts can be redeployed and 'plugged in' to the MPP cluster as 'spokes', receiving data from the MPP 'hub'
     
  • Simplify data warehouse deployment and maintenance
     
  • SQL Server 2008 R2 Parallel Data Warehouse appliances include carefully balanced, pre-assembled hardware and software from leading hardware vendors
     
  • Significantly accelerates your time to value and reduces deployment costs

Through carefully balanced configuration, tight specifications and testing, the SQL Server 2008 R2 Parallel Data Warehouse MPP data warehouse appliance is designed to deliver predictable performance.

Microsoft-designed reference configurations suit different usage scenarios, including reporting and ad hoc queries. Automated workload management and system resource balancing enable you to load data concurrently with queries, without sacrificing performance.

Using a true hub-and-spoke architecture, all enterprise data can be maintained on a SQL Server 2008 R2 Parallel Data Warehouse hub while departments or business units keep their existing data marts to suit their needs. High-speed data transfer relieves traditional barriers to hub and spoke.

Key Features

  • Data warehouse scalability from tens to hundreds of terabytes
     
  • Low cost of ownership through industry standard hardware
     
  • Appliance model simplifies deployment and maintenance
     
  • Integrates with existing SQL Server 2008 data warehouses via hub-and-spoke architecture
     
  • Greater ROI from BI investments through integration with SQL Server 2008 R2
     
  • Reduced risk through use of redundant, industry standard hardware
     
  • Balanced reference architectures deliver predictable performance
     
  • Better agility and business alignment through hub and spoke architecture

Using the Parallel Data Warehouse Appliance in conjunction with the Adatis Integration Framework we can help accelerate design, build and implementation of your Enterprise Data Warehouse.

If you would like to contact us to find out more about Data Warehousing and Business Intelligence Solutions please call 0845 0091591. 

Business Data Warehouse

The latest warehousing focused appliance from the Microsoft and HP partnership targets small data warehouses and data marts.  The appliance is optimised for SQL Server 2008 R2 and provides the best performance possible for data mart and small data warehouse workloads with data volumes of up to 5 TB.

Fast Track Data Warehouse

A Fast Track data warehouse gives you appliance-like time to value, lower TCO through industry-standard hardware and higher scale with reference architectures that scale up to 80 TB.