How Will SQL 2012 Integrate With Hadoop?

Microsoft intends to integrate Hadoop's "Big Data" capabilities into SQL 2012 before mid-2012. Microsoft hopes Hadoop's ability to process large, unstructured data sets that are too big for traditional methods (such as SQL2012) will allow SQL 2012 to manage all types of data whether it is stored in one database or on dozens of computer clusters. Microsoft is convinced that the integration of both databases management systems will help to address their weaknesses while also giving customers an incentive to buy SQL 2012.

SQL 2012 is an RDBMS (relational database management system) that uses tables to store, present and show data. It can also be used to display relationships between data sets. It is designed to be used to analyse homogeneous information on a small to medium scale. SQL 2012's table display fails when used with discordant data. SQL's implementation and interface are still viewed by many as being more user-friendly than Hadoop's MapReduce. Microsoft will use Hadoop Connectors and the SQL Server Parallel Data Warehouse in order to transfer data from Hadoop to SQL. Then, users can use SQL's relatively easy tools to analyze the "big data."

Hadoop is one of the most popular platforms for large-scale data analytics. Hadoop's MapReduce platform is capable of storing and analyzing discordant data at petabyte-scale, but it has some drawbacks. MapReduce requires a basic level of Javascripting in order to be used correctly. Its time-consuming queries make it unsuitable for small-scale data analysis. Microsoft partnered with Hadoop partners such as Cloudera, Hortonworks and open-source developers in order to solve MapReduce's speed and efficiency problems. Hadoop v0.23 will improve performance by reducing the minimum MapReduce latency, and offering a higher-level query interface discordtree.com.

Hadoop and SQL integration will include additional components that secure SQL as a Business Intelligence Platform. Microsoft will provide an open database connectivity driver (ODBC), which allows all Windows applications run queries against Hive's data warehouse, and an Excel Hive add-in that lets users move data from Hive directly into PowerPivot/Excel.

Microsoft may be able to achieve its vision by combining the strengths of these two programs and eliminating their weaknesses with open-source support from qualified third parties. Microsoft has a business interest in accommodating both developers and less qualified users. Therefore, they are likely to strive for a user-friendly interface with fewer learning curves.

Visit Magenic for more information on SQL 2012 database development. Magenic is one of the top software development companies in the country, providing innovative custom software to meet the unique business needs of some of the nation's most recognized companies.