CONVERGENCE FROM SQL NoSQL to NewSQL
Management of database includes software data management developing tools such as oldsql and now trending nosql and next generation data language newsql. As the database had been revolutionised from 40 years starting from oldSql to nosql and now to the upcoming newsql, oldsql includes features like relational model to handle data entry app and dimensional model to access data warehouse apps but it does not have features like object model, document model and graph model which is advantage of nosql whose examples are db2, hadoop, mongodb etc. The sql only use to deal with transaction problem, and cannot deal for big velocity applications does not have capacity of storing bulk data and update today's requirement of data, sql is accepted as the only standard rdbms language. We are in the middle of a database revolution that is "nosql" notable as "nosequel" It is open source distributed in nature as well as it is having high performance in a linear way that is horizontally scalable ,fast ,information retrieval database and is portable. But it can't solve large transaction problem. So to overcome the problem of both oldsql and nosql new sql is coming up with solution combination of both. We also investigate that which database is suitable for what job? choosing the right sql database is important according to users need to notice that the architecture of real world systems is not only driven by performance requirements, but has to completly include many other standard trademark requirements for selecting proper database. Such as national intelligence, cyber security, education system, marketing, business and medical informatics. Companies such as Google, Amazonetc are analyzing large volumes of data for business analysis and decisions, impacting existing and future technology all of them have different requirements, so through this paper we would conclude which query language would be better for individual need.