3 ms·
Hey thanks for your comments, views sound like the way to go for now. I can see how to go from normalized data to views, but what if there was a way to go the
by zackmorris 14y ago
Hey thanks for your comments, views sound like the way to go for now.
I can see how to go from normalized data to views, but what if there was a way to go the other direction? So like, the SQL that generated the view could be used in reverse, so when you run an update on the view, it would know which fields to update in the original pure data.
If someone got all of that working, then I really question why database organization matters. I know it's important for seeing relationships and all that, but in reality, data just exists. The relationships are a level above that. I really think that someone could make a database that works more like a zip file, where it wouldn't matter how you laid it out, for the most part it would just look like a spreadsheet and each entity would just have all of the data in one row. This is how "regular" folks view things.
Also this is a bit off topic, but automatic normalization has a lot in common with the semantic web. I just don't think it's all that difficult of a problem, but waiting around for humans to do it manually is never going to happen. I guess I'm just naive but, all the semantic web needs is iteration and the relationships will refine and converge quickly. I don't understand why it's not happening.