Question : Assuming the choice is to stay with relational model, how are tables structured in the case of large […]
Tag: denormalization
Storing personal data on an invoice to preserve data integrity
Question : I want to store invoice data like addresses of people. But the problem is addresses can change over […]
Is splitting a CSV column into a separate table (enforcing 1NF) unnecessary complication?
Question : I had very carefully asked the table designer why he had chosen to create CSV columns in multiple […]
Is it a good approach to duplicate data in a database?
Question : I have a program that needs to store traceroutes (among other data). Here is a diagram that depicts […]
Why is data integrity not possible when using denormalization?
Question : This tutorial says the following: For proponents of denormalization, the thinking is as follows: normalization creates more tables […]
Best practice database design – user rating tables
Question : I want to create a table to store user ratings of items for collaborative filtering algorithms. So far […]
Table with only one column because of many-to-many relationship?
Question : Right now I have three tables: person, alias, and person_alias. As suggested by the names of tables, one […]
Are updates the only disadvantage of denormalization?
Question : I am trying to understand what are the disadvantages of denormalization. Say that I have the following database […]
Is it possible to store historical configuration settings for each row of data without cramming all the configuration settings into each row of data?
Question : For background: I was recently hired as a database engineer for a water treatment company. We deploy water […]
Normalizing the Test Table
Question : I’m a web developer looking to leverage more of the power of my RDBMS. I’m currently learning about […]