Db2 Big SQL is a SQL engine for Hadoop that concurrently exploits Hive, HBase and Spark using a single database connection — even a single query. Db2 Big SQL is also the ultimate platform for data warehouse offload and consolidation, a key use case for many Hadoop users. This is because Db2 Big SQL is the first and only SQL-on-Hadoop solution to understand commonly used ANSI SQL syntax from other vendors and products such as Oracle, IBM DB2 and IBM PureData Systems for Analytics. And where data can’t be moved to Hadoop, Db2 Big SQL provides federated access to RDBMS sources outside of Hadoop with industry-leading IBM Fluid Query technology.
What Db2 Big SQL Does
Db2 Big SQL is also the ultimate platform for data warehouse offload and consolidation, a key use case for many Hadoop users. This is because Db2 Big SQL is the first and only SQL-onHadoop solution to understand commonly used SQL syntax from other vendors and products such as Oracle, IBM DB2® and IBM Netezza®. And where data can’t be moved to Hadoop, Db2 Big SQL provides federated access to RDBMS sources outside of Hadoop with industry-leading Fluid Query technology. Hadoop has many next-generation analytics engines to solve big data problems.
Some of the unique capabilities of Db2 Big SQL includes:
Deep integration into the Hadoop Ecosystem and extends Hive’s core capabilities. Db2 Big SQL can concurrently exploit Hive, HBase and Spark using a single database connection—even a single query.
Where all data cannot be moved into your Hadoop system, BigSQL has unique capabilities to federate the data assets across the enterprise with the Hadoop Ecosystem.
Save costs by offloading data to Hadoop and exploit Db2 Big SQL’s next-generation, fit-for-purpose analytics and SQL optimizer for Hadoop to scale the concurrency of existing Hadoop SQL access.
Hortonworks and IBM’s partnership has brought multiple joint solutions for Global Data Management to the market. From HDP on Power Systems and Spectrum Scale Storage which provides customers fast access...
TDWI Best Practices Report Practical Predictive...
Practical Predictive Analytics A TDWI Best Practices Report Almost everyone sees an application for predictive analytics and machine learning in their business. Half of the respondents to this TDWI survey...
Apache, Hadoop, Falcon, Atlas, Tez, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie, Phoenix, NiFi, Nifi Registry, HAWQ, Zeppelin, Slider, Mahout, MapReduce, HDFS, YARN, Metron and the Hadoop elephant and Apache project logos are either registered trademarks or trademarks of the Apache Software Foundation in the United States or other countries.