DEV Community

Seonyoung Chloe (she/they)
Seonyoung Chloe (she/they)

Posted on

3

37: Why do we need a Database

A database is a collection of data, usually stored in electronic form. A database is typically designed so that it is easy to store and access information.


The various reasons a database is important are:

  • Manages large amounts of data
    A database stores and manages a large amount of data on a daily basis. This would not be possible using any other tool such as a spreadsheet as they would simply not work.

  • Accurate
    A database is pretty accurate as it has all sorts of build in constraints, checks etc. This means that the information available in a database is guaranteed to be correct in most cases.

  • Easy to update data
    In a database, it is easy to update data using various Data Manipulation languages (DML) available. One of these languages is SQL.

  • Security of data
    Databases have various methods to ensure security of data. There are user logins required before accessing a database and various access specifiers. These allow only authorised users to access the database.

  • Data integrity
    This is ensured in databases by using various constraints for data. Data integrity in databases makes sure that the data is accurate and consistent in a database.

  • Easy to research data
    It is very easy to access and research data in a database. This is done using Data Query Languages (DQL) which allow searching of any data in the database and performing computations on it.

LEARN DATABASE

Heroku

This site is built on Heroku

Join the ranks of developers at Salesforce, Airbase, DEV, and more who deploy their mission critical applications on Heroku. Sign up today and launch your first app!

Get Started

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more