DEV Community

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

Posted on

 

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

Top comments (0)

DEV has this feature:

Settings

Go to your customization settings to nudge your home feed to show content more relevant to your developer experience level. 🛠