Oracle released MySQL 5.6 this week, marking the first major release the open source database in just over two years. Among the key enhancements is the addition of NoSQL capabilities.
“SQL is a very flexible language that allows you to do a lot of things that are not possible through a direct NoSQL type approach,” Tomas Ulin, vice president of MySQL Engineering at Oracle told InternetNews. “So we’ve tried to join the best of both worlds with the full power of SQL to do complex queries and at the same time we’re introducing a NoSQL access type API.”
Ulin added that the NoSQL API is to the same data set, so a database administrator can preserve all the things that are expected for a regular database. The NoSQL API in MySQL 5.6 provides up to a 9x improvement in speed for certain types of queries. The MySQL NoSQL API is based on the industry standard memcached API.