DEV Community

Cover image for Databases simplified
Kelechi Kizito Ugwu
Kelechi Kizito Ugwu

Posted on

Databases simplified

A database is a structured set of data, held in a computer; especially one that is accessible in various ways. A database is controlled by a Database Management System (DBMS).

Databases are mainly categorized into the following:
SQL(Structured Query Language)
NOSQL(Not Only Structured Query Language)

A SQL is a programming language used to query and retrieve information in a relational database .It groups data into rows and columns. It is best suited to data that have lots of relationships between each other. The following are examples:

A NOSQL groups data into JSON(JavaScript Object Notation) objects.NOSQL is an approach to database design that enables the storage and querying of data outside the traditional structures found in relational database i.e. It is a non-relational database. It is best suited to data that have a one-to-many relationship. Examples include:
Apache CouchDB

Other types of database software include the following:

The following table summarizes the differences between SQL and NOSQL:

more mature
shiny and new
tabular structure
document structure
requires a schema
more flexible to change
great with relationships
not great with relationships
scales vertically
horizontally scalable

While each type of database has its own advantages, companies commonly utilize both NoSQL and relational databases in a single application. Today’s cloud providers can support SQL or NoSQL databases. Which database you choose depends on your goals.

Oldest comments (0)