Home | Amazing | Today | Tags | Publishers | Years | Search 
Microsoft SQL Server 2012 with Hadoop

Buy

With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indeed complementary. While petabytes of unstructured data can be stored in Hadoop taking hours to be queried, terabytes of structured data can be stored in SQL Server 2012 and queried in seconds. This leads to the need to transfer and integrate data between Hadoop and SQL Server.

Microsoft SQL Server 2012 with Hadoop is aimed at SQL Server developers. It will quickly show you how to get Hadoop activated on SQL Server 2012 (it ships with this version). Once this is done, the book will focus on how to manage big data with Hadoop and use Hadoop Hive to query the data. It will also cover topics such as using in-memory functions by SQL Server and using tools for BI with big data.

Microsoft SQL Server 2012 with Hadoop focuses on data integration techniques between relational (SQL Server 2012) and non-relational (Hadoop) worlds. It will walk you through different tools for the bi-directional movement of data with practical examples.

You will learn to use open source connectors like SQOOP to import and export data between SQL Server 2012 and Hadoop, and to work with leading in-memory BI tools to create ETL solutions using the Hive ODBC driver for developing your data movement projects. Finally, this book will give you a glimpse of the present day self-service BI tools such as Excel and PowerView to consume Hadoop data and provide powerful insights on the data.

What you will learn from this book

  • Use the Native SQOOP Connector for data movement between SQL Server 2012 and Hadoop
  • Configure and use the Hive ODBC driver to enable any ODBC compliant client to consume Hadoop data
  • Create ETL solutions and automate data movement jobs between SQL Server 2012 and Hadoop using SQL Server Integration Services
  • Provide powerful reporting on the integrated data with just a matter of a few clicks using Microsoft self-service BI tools
  • Merge structured and unstructured data together in a common warehouse for analysis, which is essential

Approach

This book will be a step-by-step tutorial, which practically teaches working with big data on SQL Server through sample examples in increasing complexity.

Who this book is written for

Microsoft SQL Server 2012 with Hadoop is specifically targeted at readers who want to cross-pollinate their Hadoop skills with SQL Server 2012 business intelligence and data analytics. A basic understanding of traditional RDBMS technologies and query processing techniques is essential.

Information, Physics, and Computation (Oxford Graduate Texts)
Information, Physics, and Computation (Oxford Graduate Texts)

This book presents a unified approach to a rich and rapidly evolving research domain at the interface between statistical physics, theoretical computer science/discrete mathematics, and coding/information theory. It is accessible to graduate students and researchers without a specific training in any of these fields. The selected topics...

Head First PHP & MySQL (A Brain-Friendly Guide)
Head First PHP & MySQL (A Brain-Friendly Guide)
If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals...
The Complete Guide to Day Trading: A Practical Manual From a Professional Day Trading Coach
The Complete Guide to Day Trading: A Practical Manual From a Professional Day Trading Coach

Do you want to be a day trader?

Every day, millions of dollars change hands in the markets, presenting the perfect opportunity for people just like you to make significant money and profits through the art of day trading.

But here's the question: is day trading right for you? And, if it is, how do you get...


XMPP: The Definitive Guide: Building Real-Time Applications with Jabber Technologies
XMPP: The Definitive Guide: Building Real-Time Applications with Jabber Technologies

This practical book provides everything you need to know about the Extensible Messaging and Presence Protocol (XMPP). This open technology for real-time communication is used in many diverse applications such as instant messaging, Voice over IP, real-time collaboration, social networking, microblogging, lightweight middleware, cloud...

Lessons in Project Management
Lessons in Project Management

Most of the project management books on the market are basically textbooks. They are dry to begin with and don't focus on the practical advice that most people need to run their projects. Lessons in Project Management does not assume you are a project manager building a nuclear reactor or sending a man to the moon. Instead, it...

Web Navigation: Designing the User Experience
Web Navigation: Designing the User Experience

Web Navigation: Designing the User Experience offers the first in depth look at designing web site navigation. Author Jennifer Fleming offers design strategies to help you uncover solutions that work for your site and audience.Acclaimed Web design author Lynda Weinman says in the foreword to this book: "Kudos to Fleming...

©2024 LearnIT (support@pdfchm.net) - Privacy Policy