Skip to main content

Timeline for Should I avoid data duplication?

Current License: CC BY-SA 3.0

13 events
when toggle format what by license comment
Feb 22, 2015 at 12:07 answer added Greg timeline score: 1
Feb 21, 2015 at 0:26 comment added Tulains Córdova Could you substitute that mind map with a Crow's foot ER diagram? Example: upload.wikimedia.org/wikipedia/commons/9/91/…
Feb 21, 2015 at 0:19 comment added Tulains Córdova What do you mean by "assign a user to a contact"?
Feb 20, 2015 at 17:14 history tweeted twitter.com/#!/StackProgrammer/status/568821076207280128
Feb 20, 2015 at 16:38 comment added Robbie Dee As someone who has actually worked as a DBA on RDBMs with billions of rows, denormalisation is sometimes a necessary evil for performance reasons. However, that is primarily an implementation concern (what we used to called physical design). You should aim to eliminate any data duplication in the initial (logical) design.
Feb 20, 2015 at 15:36 comment added Doc Brown Data duplication is not always a bad thing, decoupling might be sometimes a serious reason to duplicate data when having careful designed synching mechanisms. But when designing a business model for an ERP system from the ground, as shown here, I would avoid any redundancy as hell. And do yourself a favor, read martinfowler.com/apsupp/accountability.pdf first before reinventing the wheel.
Feb 20, 2015 at 15:30 comment added Mawg I.M.O data duplication is always A Bad Thing (since a single datum cannot get out of synch with itself). YMMV
Feb 20, 2015 at 15:16 comment added Willem-Aart Most definitely, but I'd like to keep things separate from each other, such as user data and contact (CRM) data. Is data duplication allowed in these instances?
Feb 20, 2015 at 15:13 comment added Mawg Data duplication is A Bad Thing en.wikipedia.org/wiki/Third_normal_form
Feb 20, 2015 at 15:12 history edited Willem-Aart CC BY-SA 3.0
added 47 characters in body
Feb 20, 2015 at 15:01 history edited Willem-Aart CC BY-SA 3.0
added 168 characters in body
Feb 20, 2015 at 15:00 review First posts
Feb 20, 2015 at 16:50
Feb 20, 2015 at 14:56 history asked Willem-Aart CC BY-SA 3.0