0

what is redundancy and in what way it's removed in SQL

Explain Redundancy

12th Jul 2016, 7:44 PM
Vedant Patadia
Vedant Patadia - avatar
4 Respostas
+ 1
Redundancia tiene que ver con la duplicidad de los datos. Tener en varias tablas los mismos datos no es bueno ya que puede traer errores en las consultas además de ralentizar la BD. Al momento de modelar la BD lo que se hace es normalizar tu BD para prevenir por ejemplo la redundancia.
12th Jul 2016, 10:13 PM
César Augusto Gaete
César Augusto Gaete - avatar
0
Ehm...I can understand English...
12th Jul 2016, 10:15 PM
Vedant Patadia
Vedant Patadia - avatar
0
Redundancy means that there is duplication of data. e.g. if you have multiple tables are repeating the same data information. That's not good because you can generate errors in SQL queries and also causes the DB is slower.
12th Jul 2016, 10:28 PM
César Augusto Gaete
César Augusto Gaete - avatar
0
At first when the database modeling what is done is a process called 'normalize' precisely to prevent redundancy. Excuse my bad english.
12th Jul 2016, 10:36 PM
César Augusto Gaete
César Augusto Gaete - avatar