Modern data warehouse

Modern data warehouse solutions from Microsoft help you find new insights from Big Data by seamlessly combining traditional high volume relational stores with new data stores for unstructured data like Hadoop.

Give users real-time results on their queries

With traditional data warehouse technologies, queries can take minutes, hours or even overnight to process. The Microsoft modern data warehouse gives users near real-time results. With breakthrough query processing and in-memory technologies, customers have seen 10x to 100x faster completion times to their longest running queries.

Pizza Pizza chose an integrated business intelligence solution based on Microsoft SQL Server 2012 SP1, SQL Server Analysis Services, and Excel to build a data warehouse solution and provide employees with on-time insights and easy, on-time access to business data.

Benefits

With in-memory technologies from Microsoft’s modern data warehouse, customers have seen from 10x to 100x improvements to their longest running queries. Customers have also seen up to 10x compression of their data

Through parallelized query processing, customers have seen up to 100x performance gains for their complex queries at scale

Capabilities

Columnar storage

By reorienting data in a column rather than a row store, organizations reduce query time and increase compression on their data. Grouping data in a columnar format allows for higher efficiency in storage and the returned dataset, which ultimately reduces costs.

In-memory data warehouse technologies

In-memory columnstore can increase speed up to 100x for common data warehouse queries. When the query runs, SQL Server or PDW will automatically pick the most optimized index and will bring data into or out of memory on demand.

Parallelized query processing

With multicore hardware platforms, SQL Server shortens response time for queries that access a large amount of data. The parallel query processing capabilities of SQL Server and PDW provide near-linear speedup as the number of logical processors working on a query increases.