Wednesday, August 20, 2008

Part 3

A Little bit more about the QlikView associative database.

There are differences between how QlikView manages join relationships between tables and how a typical DB might handle joins.






You might be tempted to think that QlikView has a Categories.CategoryID field and a Products.ProductID field

But a better visualization is with a categoryID field stored between the two tables.










Qlikview combines the distinct datapoints into a single field. This is a Key Field

A reference is maintained through small binary pointers maintaining the relationships back to the original tables.



Compresses data by 80-90%, to 5-20% of its original size. Which is then loaded into memory.

No comments: