The Tool Language: The Future Of The SQL Language

1017 Words3 Pages

Since the SQL language appeared in mid 1970s, it has been leading the relational database industry for many years. With the modern era of databases not everyone sees the advantages of using relational databases. NoSQL, was first developed in the twenty first century (MongoDB, para 19) to address the issues that the SQL language could not handle. NoSQL cannot handle pure relational database models, it can use any of five different kinds of models, including relational to solve problems. With the variety of models, designers are wondering if there is a future for the strictly relational language SQL, and it’s other disadvantages compared to that of NoSQL.

Databases

NoSQL is seeing a large surge in popularity in recent years. Compared to the …show more content…

With the advancement in database systems and software, Eric Brewer in his new article that: “The modern CAP goal should be to maximize combinations of consistency and availability that make sense for the specific application.Such an approach incorporates plans for operation during a partition and for recovery afterward, thus helping designers think about CAP beyond its historically perceived limitations.” (Brewer, 2012)

Meaning that with the great advancement in technology, the creation of NoSQL, designers are able to optimize their database systems to get achieve the best results from the CAP theorem as possible.

How it Works

With the modernization of NoSQL and it’s adaptation to fix problems with old relational databases, it is able to store data in many different ways. There are five main database types for NoSQL: relational, key-value, document databases, column family stores and graph databases. Each of the four are unique in their own way and thus different systems and companies support different database types. A key-value database is described by Pramod Sadalage, in his article on …show more content…

In a journal written by Alexandru Boicea, Florin Radulescu and Laura Ioana Agapin, they cover the comparison of both a system using the SQL language and a system of the NoSQL language. The two management systems in place are Oracle, a system built off of SQL and MongoDB a system off of NoSQL. The authors are quick to say the main key features including that of the flexibility the MongoDB system has compared to Oracle. Oracle has defined schemas and do not provide the designer a lot of flexibility to quickly add new data. Oracle follows a strict relational model where as MongoDB does not. With MongoDB not following the traditional relational database model, allows the system to scale larger and become

More about The Tool Language: The Future Of The SQL Language

Open Document