1 / 8

Oracle MySQL Released Version 5.6

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)?.

chloe
Download Presentation

Oracle MySQL Released Version 5.6

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle MySQL Released Version 5.6 Emre Eftelioglu Jin Zhao Group 3

  2. 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

  3. 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

  4. What is New? • Changing DB schema when DBMS is online • Memcached API • Better scalability by improved thread handling

  5. What is New? • Sub Query Optimization • New Index Condition Pushdown • Batch Key Access • Better Database Optimizer

  6. Conclusion

  7. 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});

  8. 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

More Related