Oracle MySQL Released Version 5.6

1
Oracle MySQL Released Version 5.6
Group 3

• Emre Eftelioglu
• Jin Zhao

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/MyS
  QL_5.6_tackles_NoSQL_competitors
• Information Week (Doug Henschen, February 05,
  2013)
• http//www.informationweek.com/software/informatio
  n-management/oracle-mysql-upgrade-challenges-nosql
  -on/240147829
• MongoDB (MongoDB User Guide)
• http//docs.mongodb.org/manual/
• Wikipedia
• http//en.wikipedia.org/wiki/NoSQL