Upgrading Oracle MySQL Version 5.6: Key Differences and NoSQL Comparisons
Oracle has released MySQL version 5.6, presenting significant enhancements in performance, availability, and scalability. These updates aim to compete with NoSQL databases that cater to massive quantities of data with unique requirements. Unlike traditional SQL, NoSQL databases prioritize flexibility over relationships and do not ensure ACID compliance. New MySQL features include online schema changes, improved scalability through thread management, and enhanced query optimization. Key references showcase how MySQL 5.6 addresses the challenges posed by NoSQL technologies.
Upgrading Oracle MySQL Version 5.6: Key Differences and NoSQL Comparisons
E N D
Presentation Transcript
Oracle MySQL Released Version 5.6 Emre Eftelioglu Jin Zhao Group 3
What are the Differences? • The Upgrades can be shown under 3 categories • Performance • Availability • Scalability • Availability and Scalability Features are to compete with NoSQL DB users
What is NoSQL (not only SQL)? • Useful for Huge Quantity of Data • Relationship is not important. Store and Retrieve is more Important • Does not use SQL as its query language • Does not guarantee ACID • Twitter, Facebook, Internet Stores (eg. Amazon) • MongoDB, Cassandra, Riak
What is New? • Changing DB schema when DBMS is online • Memcached API • Better scalability by improved thread handling
What is New? • Sub Query Optimization • New Index Condition Pushdown • Batch Key Access • Better Database Optimizer
Details About NoSQL No SQL data objects can be json, bson, xml files. "lesson": { "name":"Calculus", "description":“New Lesson", "class": "b-3" }, db.product.remove() db.users.find({'last_name': 'Smith'}) db.users.find({last_name: 'Smith'}, {'ssn': 1});
Reference • Computer World (Jaob Jackson, February 05, 2013) • http://www.computerworld.com/s/article/9236511/MySQL_5.6_tackles_NoSQL_competitors • Information Week (Doug Henschen, February 05, 2013) • http://www.informationweek.com/software/information-management/oracle-mysql-upgrade-challenges-nosql-on/240147829 • MongoDB (MongoDB User Guide) • http://docs.mongodb.org/manual/# • Wikipedia • http://en.wikipedia.org/wiki/NoSQL
