In Detail

With the explosion of information, the open resource Apache Hadoop environment is gaining traction, due to its large atmosphere that has arisen round the center functionalities of its disbursed dossier process (HDFS) and Map decrease. As of this present day, with the ability to have SQL Server speaking to Hadoop has turn into more and more vital as the are certainly complementary. whereas petabytes of unstructured facts should be kept in Hadoop taking hours to be queried, terabytes of based information will be kept in SQL Server 2012 and queried in seconds. This results in the necessity to move and combine facts among Hadoop and SQL Server.

Microsoft SQL Server 2012 with Hadoop is aimed toward SQL Server builders. it is going to quick enable you get Hadoop activated on SQL Server 2012 (it ships with this version). as soon as this can be performed, the publication will concentrate on tips on how to deal with immense information with Hadoop and use Hadoop Hive to question the information. it's going to additionally disguise issues corresponding to utilizing in-memory capabilities via SQL Server and utilizing instruments for BI with sizeable data.

Microsoft SQL Server 2012 with Hadoop specializes in info integration innovations among relational (SQL Server 2012) and non-relational (Hadoop) worlds. it is going to stroll you thru assorted instruments for the bi-directional move of information with sensible examples.

You will discover ways to use open resource connectors like SQOOP to import and export facts among SQL Server 2012 and Hadoop, and to paintings with best in-memory BI instruments to create ETL recommendations utilizing the Hive ODBC motive force for constructing your info stream initiatives. ultimately, this ebook provides you with a glimpse of the current day self-service BI instruments corresponding to Excel and PowerView to eat Hadoop info and supply robust insights at the data.

Approach

This ebook could be a step by step instructional, which essentially teaches operating with titanic info on SQL Server via pattern examples in expanding complexity.

Who this ebook is for

Microsoft SQL Server 2012 with Hadoop is in particular detailed at readers who are looking to cross-pollinate their Hadoop talents with SQL Server 2012 company intelligence and information analytics. A uncomplicated realizing of conventional RDBMS applied sciences and question processing thoughts is essential.