Capabilities

PolyBase provides a fundamental breakthrough in data processing and analytics by enabling seamless integration between traditional data warehouses and big data deployments.

• Standard SQL queries (instead of MapReduce) to access and join Hadoop data with relational data
• Query Hadoop data without IT having to pre-load data first into the warehouse
• Native Microsoft BI integration allowing analysis of relational and non-relational data with familiar tools like Excel
• Enhanced query execution performance with the power of Massively Parallel Processing technology

Get fast information to insight across petabytes of data with Microsoft Analytics Platform System.

• Up to 100x faster than legacy warehouses with in-memory and updateable columnstore
• Massively parallel processing architecture that parallelizes and distributes computing for high query concurrency and complexity
• Built-in hardware redundancies for fault tolerance
• Microsoft as a single point of contact for hardware and software support

Unlike other vendors in the data warehousing space who deliver a high-end appliance at a high price, Microsoft engineered Analytics Platform System for optimal value through software innovations which result in a lower cost for the appliance.

• Resilient, scalable, and high-performance storage features built into software, which lowers hardware costs
• Data compression up to 15x with the in-memory updateable columnstore, saving up to 70% of storage requirements
• Start small with a quarter rack allowing you to right-size the appliance rather than over-acquiring capacity
• The lowest price per terabyte for a data warehouse appliance