Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

what is the structure of data in associative data model?

Hi all,

iam a newbie to qlikview and the associative database

i have some query with the structure of the associative database

for suppose I have some data like(example)

studentid  name            group

1              qlikview         computers

2              inmemory      physics

3              associative    chemistry

i have read the associative model stores the data as items and links

how this data will be stored in the associative database. where the columns will be stored and where the data will be stored?

please help me...

thanks in advance

7 Replies
Not applicable

Re: what is the structure of data in associative data model?

Hi!

The associative model show when you have more than one table.

Create a new table with, lets say, classes:

studentid      classname     start                end

1                  TIC                2012-01-01      2012-03-31

2                  TIA                2012-01-01      2012-03-31

1                  TID                2012-01-01      2012-03-31

Then studentid will associate with your first table. Compare with SQL JOIN (but be careful, it's NOT like SQL JOIN).

You don't have to create the link, QlikView does this whenever the column name match.

Not applicable

Re: what is the structure of data in associative data model?

Ok thomas, how the data would be stored in associative database. where the columns would be and the data would be?

as we know that it will store the distinct values of every item in the table. then the data would be stored uniquely right?

then how will they relate the data with the columns and where the column names are stored.

Not applicable

Re: what is the structure of data in associative data model?

Shantheguy,

I'm just a developer :-), not that familiar with the strict technical side of QlikView. I pretty much don't care how it's done, I just accept it and work accordingly.

As a developer the best thing for you to do is try. Load a bunch of data and play with it. Attend the, free, online classes and download, for free, QlikView.

If you on the other hand really need this indepth knowledge I must refer you to someone else. Probably QlikTech...

Not applicable

Re: what is the structure of data in associative data model?

  thank you thomas for the support. But i need to get the indepth structure as i have to giv the clear explanation to my superiors to implement this tool.

Not applicable

Re: what is the structure of data in associative data model?

Try contact presales in your country, they can provide you with all of it.

Good luck!

MVP
MVP

what is the structure of data in associative data model?

I've been a QlikView developer for six years.  I have never needed to know the in depth structure of QlikView's associative data model.  Your superiors don't need to know it either, even if they think they do.

It's like evaluating Excel for your company, and your superiors asking you, "How does Excel really store the data?  What is its internal data structure?"  The answer is that nobody cares, and nobody needs to care.  All that matters is that it works.  There are vastly more relevant questions to be asking when evaluating a software tool.

That said, your superiors probably want what they want, and some random guy on a forum saying "they don't need to know that" isn't likely to dissuade them.  Fortunately, the basic ideas of how the data is stored internally are not that complicated.  I think I posted this already in another thread of yours, but here's pretty much everything I know about the actual internal data storage.

http://www.dbms2.com/2010/06/12/the-underlying-technology-of-qlikview/

jmletennier
New Contributor

Re: what is the structure of data in associative data model?

Associative Database Management systems have been around since 1962..and predate SQO by a decade.. DR Codd quantified the levels of efficiency of Data Normalization with his 1971 paper. By defining levels 1 through 6, we have since then settled on 3rd normal form as no DB exists today except  AtomicDB , which is an (N) normal form.. hence  4 dimensions more efficient.. and in DATA management  higher efficiency = Speed   .. This will explain it Associative DataBase Technology Review - YouTube

good luck