Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Relational/Dimensional/Object databases

Hi

I am reading about Relational and Object databases, and in this context I would guess that dimensional design is still a part of the relational approach, but where dimensional is focused on OLAP and not OLTP? That is why QlikView care less about NF?   

Edit: I switched OLTP/OLAP around, so it makes more sense now.

11 Replies
hic
Former Employee
Former Employee

When I make applications, I look at data and make a data model from that. Then I listen to the user and tweak the data model.

In other words: The data model is really decided from data and not from the user wanting to see this or that in a pivot table. A good, logical data model will meet most (or all) user demands without any changes.

HIC

Not applicable
Author

Thx, that is the way I have been thinking so far.

But then I dont understand all this hype with fact/dimension database design in a star design, why is that so important? I dont find that "logical" to work with, I find thematic tables side by side, perceptual easier too figure out and work with.