A Report On Relational Databases

923 Words4 Pages
NoSQL was created in the response to relational databases not being able to handle the scale and changing challenges of modern applications, they also cannot take advantage of the cheap, easy storage abilities and also the processing power accessible now. NoSQL includes a variety of different technologies that were developed in response to the surge of data stored by users, objects and products. They were also developed to contend with the rising frequency that the data is accessed and the performance and processing needs. [7] NoSQL databases can be set into different categories such as • Document databases - Document databases pair each key with a complex data structure known as a document. Documents can contain many different…show more content…
The architecture used by NoSQL databases allows for the databases to be scaled efficiently rather than the more strict architecture found in relational databases. Pros and Cons When comparing the benefits to downfalls of both SQL and NoSQL, there are 6 areas which need to be looked at. These are how the systems allow for querying, how transactions are carried out, the consistency the systems offer, how saleable they are, also how easily managed the systems are and finally the schemas which are used by the systems. SQL based databases support a ever expanding set of languages for queries, as well as the a massive number of filters, sorting options, projections and index queries. NoSQL on the other hand allows for all this as well but does not have the more powerful aggregation options which are available to SQL based databases. Transactions allow for changes to be made to databases and atomicity ensures that these changes are done entirely. Having atomically made changes guaranties that these changes are never done partially, this is important because without it multiple users could make transactions relating to the same data and be working with different result causing data to be lost or new data being created, some NoSQL platforms do not support transactions but most SQL platforms do. Following the atomicity of the transactions consistency is also a big part of both types of platforms. MySQL
Open Document