Positioning FAQ ¨C Oracle NoSQL Database & MySQL Database

ALLSTARS_ORACLE

Positioning FAQ ¨C Oracle NoSQL Database & MySQL Database

Web-based applications, used by high profile web properties including Google, Yahoo!, Facebook, Twitter, YouTube and thousands of mid-sized companies.
MySQL is a key part of LAMP (Linux, Apache, MySQL, PHP/Perl/Python), the open source web stack, and supports all major platforms including Linux, Windows, Mac OS X, Solaris, and many more.
Q. What has Oracle announced?
A: Oracle announced it is now offering customers an end-to-end solution for Big Data, the Oracle Big Data Appliance, which in conjunction with the Oracle Exadata Database Machine and the new Oracle Exalytics Business Intelligence Machine, delivers everything customers need to acquire, organize, analyze and maximize the value of Big Data within their enterprise.
Oracle also announced 3 new software products for big data: Oracle NoSQL Database, Oracle Loader for Hadoop and Oracle R Enterprise
Q: What is the Oracle Big Data Appliance?
A: The Oracle Big Data Appliance is a new engineered system that includes an open source distribution of Apache™ Hadoop™, Oracle NoSQL Database, Oracle Data Integrator Application Adapter for Hadoop, Oracle Loader for Hadoop, and an open source distribution of R.
Oracle NoSQL Database and Oracle Loader for Hadoop will both be available separately as well as included in Big Data Appliance.
Q: What is the Oracle NoSQL Database?
Oracle NoSQL Database is a commercial grade, general-purpose NoSQL database using a key/value paradigm. It allows you to manage massive quantities of data, cope with changing data formats, and submit simple queries. Complex queries are supported using Hadoop or Oracle Database operating upon Oracle NoSQL Database data.
Key Features:
 Key Value Pair Database
 Dynamic Data model
 Highly scalable & Available

 Transparent load balancing
 Built using Berkeley DB
Q: Oracle recently announced a new feature enabling NoSQL access to MySQL (for the InnoDB & MySQL Cluster storage engines), is there any overlap with the Oracle NoSQL Database?
A: No, the products are complementary and enable Oracle to offer a complete solution stack to its customers. For web applications well served by a relational database, users can fully rely on MySQL, with the option to use the NoSQL access to MySQL via memcached to speed up key value read and write operations. And for applications primarily handling large amounts of unstructured and/or evolving data, they can rely on the Oracle NoSQL Database, in conjunction with Hadoop and the Oracle database for complex queries.
Q: Can you summarize when it makes sense to use the Oracle NoSQL Database vs the NoSQL Access to MySQL & MySQL Cluster via memcached?
A: We recommend considering the options according to the following scenarios:
MySQL & MySQL Cluster with NoSQL Access via memcached
Oracle NoSQL Database
 Mostly Schema-based data.
 Need to perform both simple Key Value and complex SQL queries across the same data set in the same database.
 Wish to re-use existing memcached infrastructure while adding persistence, HA and write scalability.
 Need multiple access methods including Memcached, Java, Node.js/JavaScript, REST, Java, & C++.
 Existing MySQL users with limited needs for KV operations & wishing to avoid duplication among different data stores.
 Unstructured data, or frequent changes of type & structure of data.
 Primary need to perform simple NoSQL queries, while executing complex queries via Hadoop and Oracle Exadata and Exalytics.
 Need to handle large amounts of data with exponential growth, i.e. tens of TB.
 Need scalability to handle distributed data over up to hundreds of nodes
Q: Does MySQL also integrate with Hadoop?
A: Yes. It is possible to get data to and from Hadoop using DBInputFormat Apache Sqoop, among other options. Oracle additionally released the MySQL Applier for Hadoop as early access feature in April 2013: http://dev.mysql.com/tech-resour ... hadoop-applier.html

Q: Can You Explain the Licensing and Pricing of MySQL?
A: MySQL Community Edition is available for download free of charge under the GNU General Public License (GPL). For customers who are looking for the advantages of MySQL with additional value-added features, management tools and world-class 24x7 Support, Oracle offers MySQL Enterprise Edition.
MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools and services enabling organizations to achieve the highest levels of MySQL scalability, reliability, security and uptime.
MySQL Cluster Carrier Grade Edition (CGE) adds MySQL Cluster and cluster-specific advanced features / tools to MySQL Enterprise Edition.
More information, including subscription components and pricing, is available at:
http://www.mysql.com/products/enterprise/
Q: Where can I get more information about the products?
A: Here are a few sources you can use: