close
test_template

Relational Databases

About this sample

About this sample

close

Words: 652 |

Page: 1|

4 min read

Published: Feb 12, 2019

Words: 652|Page: 1|4 min read

Published: Feb 12, 2019

Relational databases are those databases that rely on tables, columns, rows or schemas to organize and retrieve data. A NoSQL originally refers to non-Structured Query Language or non relational database giveing a structure for storing and getting data that is presented in means other than the tabular form or relations likewise used in “relational databases”.Such databases existed from late 90’s, but didn’t obtain the NoSQL brand until a rise of popularity in the early twenty-first century, caused by the needs of Web 2.0 companies such as Yahoo, Facebook, Google, and Amazon. NoSQL databases are increasingly used in big data and real-time web applications. These are called "Not only SQL" for the fact that they may support SQL-like query languages.

'Why Violent Video Games Shouldn't Be Banned'?

Why the need of NoSQL?

RDBMSs operate with a relational model defined by schema, where each table is a strictly defined collection of rows and columns and a relationship can then be established between each row in one table and a row in another table. Relational data can be queried and manipulated by using SQL query language. But what if it is inconvenient to store data in the form of table(s) or we have other kind of relationships between records and want to quickly access the data? The emerging alternative is NoSQL. In an many of the cases, how the use of RDBMSs leads to problems due to fixed schema, which makes them ill-suited for changing business requirements, as schema changes are problematic and time-consuming, causing insufficient performance and latency for the new requirements and limited ability to scale cost-effectively. The data structures used e.g. key-value, wide column, graph, or document are different from those used by default in relational databases, making some operations faster and more flexible sometimes.

The main reason not to use an SQL database is scalability, especially given the write-heavy workloads generated by modern web applications. An app like Facebook can’t be made to work on a straightforward SQL database, except by massive partitioning and sharding, which requires significant adjustments to the app logic as well. That's why Facebook developed Cassandra. Types of nosql databases model and their classification with examples: Wide-Column :This type of databases store data in tables with rows and columns similar to RDBMS, but names and formats of columns can vary from row to row across the table. Wide-column databases group columns of related data together. E.g. Accumulo, Cassandra, Druid, HBase, Vertica.Document: This type of databases typically store self-describing JSON, XML, and BSON documents. E.g. Apache CouchDB, ArangoDB, BaseX, Clusterpoint, Couchbase, Cosmos DB, IBM Domino, MarkLogic, MongoDB, OrientDB, Qizx, RethinkDBKey-value: This type of databases emphasize simplicity and are very useful in accelerating an application to support high-speed read and write processing of non-transactional data. e.g. Aerospike, Apache Ignite, ArangoDB, Couchbase, Dynamo, FairCom c-treeACE, FoundationDB, InfinityDB, MemcacheDB, MUMPS, Oracle NoSQL Database, OrientDB, Redis, Riak, Berkeley DB, SDBM/Flat File dbmGraph: This type of databases uses graph structures to store, map, and query relationships. They provide index-free adjacency, so that adjacent elements are linked together without using an index. E.g. AllegroGraph, ArangoDB, InfiniteGraph, Apache Giraph, MarkLogic, Neo4J, OrientDB, VirtuosoMulti-model: This type of databases leverage some combination of the four types described above and therefore can support a wider range of applications. E.g. Apache Ignite, FoundationDB, ArangoDB, Couchbase, MarkLogic, InfinityDB, OrientDBKey benefits: NoSQL supported by column oriented databases where RDBMS is row oriented database. It seems to work better on both unstructured and unrelated data. NoSQL databases give up some features of the traditional databases for speed and horizontal scalability.

NoSQL databases on the other hand are perceived to be cheaper, faster and safer to extend a pre-existing program to do a new job than to implement something from scratch.

Get a custom paper now from our expert writers.

Today’s applications are expected to run non-stop and must efficiently manage continuously growing amounts of multi structured data in order to do so. This has caused NoSQL to grow from something to a serious consideration for every database, from small shops to the enterprise.

Image of Alex Wood
This essay was reviewed by
Alex Wood

Cite this Essay

Relational Databases. (2019, February 11). GradesFixer. Retrieved July 15, 2024, from https://gradesfixer.com/free-essay-examples/relational-databases/
“Relational Databases.” GradesFixer, 11 Feb. 2019, gradesfixer.com/free-essay-examples/relational-databases/
Relational Databases. [online]. Available at: <https://gradesfixer.com/free-essay-examples/relational-databases/> [Accessed 15 Jul. 2024].
Relational Databases [Internet]. GradesFixer. 2019 Feb 11 [cited 2024 Jul 15]. Available from: https://gradesfixer.com/free-essay-examples/relational-databases/
copy
Keep in mind: This sample was shared by another student.
  • 450+ experts on 30 subjects ready to help
  • Custom essay delivered in as few as 3 hours
Write my essay

Still can’t find what you need?

Browse our vast selection of original essay samples, each expertly formatted and styled

close

Where do you want us to send this sample?

    By clicking “Continue”, you agree to our terms of service and privacy policy.

    close

    Be careful. This essay is not unique

    This essay was donated by a student and is likely to have been used and submitted before

    Download this Sample

    Free samples may contain mistakes and not unique parts

    close

    Sorry, we could not paraphrase this essay. Our professional writers can rewrite it and get you a unique paper.

    close

    Thanks!

    Please check your inbox.

    We can write you a custom essay that will follow your exact instructions and meet the deadlines. Let's fix your grades together!

    clock-banner-side

    Get Your
    Personalized Essay in 3 Hours or Less!

    exit-popup-close
    We can help you get a better grade and deliver your task on time!
    • Instructions Followed To The Letter
    • Deadlines Met At Every Stage
    • Unique And Plagiarism Free
    Order your paper now