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.
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.
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 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.
Microsoft StreamInsight is a powerful platform to develop and deploy complex event processing applications. Its high-throughput stream processing architecture and the Microsoft .NET Framework-based development platform enable you to quickly implement robust and highly-efficient event processing applications.
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.