PDW and Big Data (Hadoop)
Excuse me? Did you say that it is possible to access unstructured Big Data with structured PDW data? Yep, that’s right: from a single SQL query that provides complete insulation of the underlying data sources that contain the data (structured or unstructured).
The secret sauce comes in the form of something called PolyBase, a breakthrough component that enables querying across Hadoop and relational data in addition to providing integration with the whole Microsoft BI stack.
In a nutshell, PolyBase can handle a standard Transact-SQL query that joins tables from any relational source with tables from a Hadoop cluster and seamlessly return the results to the user. In other words, you don’t have to load data you already ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
