mySQL, NoSQL, and now NewSQL?{4}


In today’s fast paced world with data growing at an exponential rate, a database must be scalable and perform well with today’s demands in storing data. SQL databases have been around for decades and the basic architecture wasn’t created with scalability in mind. Apparently there have been new advances in database technology and it includes instances of NoSQL and NewSQL. Michael Stonebraker is a seasoned database creator who is now a chief technology officer for VoltDB, explained the benefits of using “NewSQL” to better benefit today’s demands for database performance. Stonebraker stated that traditional SQL systems have many limitations and that includes performance. SQL databases are also not scalable onto more than one server. If one were to make an SQL database scale onto more servers for better performance, it would be very complicated to manage. NoSQL was indeed created to improve on scalability and is increasing in popularity; it also has its own limitations as well. The main problem with NoSQL is that it cannot perform complicated mathematical queries. However with NewSQL, it improves on all of the issues with SQL and NewSQL, making it a more efficient database system that can process requests faster and can scale to more than one server. According to Joab Jackson, the author of the article entitled “’NewSQL’ Could Combine the Best of SQL and NoSQL” from PCWorld, using NewSQL “can execute transactions 45 times faster than a typical relational database system” and “can scale across 39 servers, and handle up to 1.6 million transactions per second across 300 CPU cores” (Jackson).

This article from PCWorld is related to this week’s topic mainly due to type of database management system used for databases. Since we are learning about the relational database management system, I found it interesting to know that this type of database is decades old technology. Although there are some disadvantages, it is still the most popular DBMS used today. It is amazing to believe that such an old database system is still currently in use today with little changes.

As I discovered in the article, database systems this old wasn’t created with scalability in mind and have performance issues in today’s world of growing data. As a result, traditional DBMS cannot be used for all situations, which is why there are variants that improves on the old.

Sources:

Jackson, J. (2011, August 24). ‘NewSQL’ could combine the best of SQL and NoSQL. Retrieved October 7, 2012, from http://www.pcworld.com/article/238728/article.html

Menegaz, G. (2012, October 1). What is NoSQL, and why do you need it?. Retrieved October 7, 2012, from http://www.zdnet.com/what-is-nosql-and-why-do-you-need-it-7000004989/