Phoneia

Advantages and disadvantages of databases

Technology - July 27, 2019

Databases are of vital importance in the dynamics of today’s world as they are behind all the tide that moves in the generation, recovery and consumption of information. In this article we will see both the advantages and disadvantages of databases.

Image 1. Advantages and disadvantages of databases

In today’s world, the management of computer and telematics systems has become an obligation, something inexcusable, essential.

Practically we need them even to mercar. But for all this to be possible, not only the internet infrastructure is required, but those beautiful data repositories better known as databases. Well, let’s look at some of its benefits.

Advantages of databases

  1. Databases make it easier to obtain information
  2. Obtain structured information.
  3. Share information simultaneously with other users or with other databases.
  4. Facilitates standardization of processes, record names, etc.
  5. Allows you to control data duplication (redundancy)
  6. Allows you to control the dupicity, triplicity, etc. of disk space storage.
  7. Allows data synchronization.
  8. The same database is used for various and multiple systems working on that DB.
  9. This, on the other hand, allows data centralization.
  10. Allows data unification.
  11. Security and integrity of information through user validation.
  12. Creation of different levels of security.
  13. Validation of log entry conditions (allowing you to control human errors in data entry).
  14. Flexibility and speed to obtain information.
  15. Increases productivity (no concerns about data organization or validation).
  16. Databases are independent of programs and/or applications (so a change in the structure of the programs or their code does not affect the DB, and vice versa).
  17. This results in data independence.
  18. Databases are not installable, but are portable. Just copy them, import them.
  19. Databases are modifiable in their structure, so we can easily add new information to a record, new tables, etc.

Database disadvantages

In our current world we have computerized access to mercar, and all this infrastructure requires not only the internet, but those wonderful repositories called Databases. However, to their full potential, they have some things and aspects that won’t always make us happy, which we’ll discuss below.

 

  1. Size, space. A BD usually requires a lot of disk space, often becoming heavy.
  2. They are a complex product, so not everyone will be able to manipulate it and/or put the way in charge of its maintenance.
  3. Cost. Some database managers and products are often expensive. Such as Oracle, DB2, Etc.
  4. They require training, counseling and accompaniment to teach their management.
  5. A person is required to be aware of maintenance or failures.
  6. When BD grows a lot it can become slow, which affects search and information retrieval.
  7. A failure in the DB affects the entire environment, especially if it is a cenreal DB and multiple applications retrieve information from the same database.
  8. If the BD becomes corrupted it is complex to repair it and return it to its previous state.

We hope it served you. If you have more advantages and disadvantages that provide or can be the databases you can help us by leaving them within the comments. If you liked this article, share it on your social networks and tell us your opinion about the subject.