Dim/Fac Vs FK/PK

What is the basic difference between Dimension/Facts relationship and PK/FK realtionships?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Is this a homework question? I'm not sure I understand the question. Usually a dimension table is the "parent" (the referenced table) of a foreign key constraint on the fact table (referencing table).
anushahannaAuthor Commented:

I'm working with a OLAP DB and hence the question to get a clarification.

sorry i should have been more clear in the quesiton: in OLAP we use PK/FK between Dim and Fact tables. In OLTP we use the same between normalized tables.

Is there anything specific about the PK/FK in the 2 models that are different? Or the PK/FK is not dependent on the model (OLAP/OLTP)..

No difference that I can think of.

OLAP doesn't necessarily imply "dimensional". If by "OLAP" you just mean a database used for business intelligence / decision support purposes then that could also be a normal form model. But either way a foreign key means the same thing in each case.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

anushahannaAuthor Commented:
Thanks for the clarification.

yes, by OLAP i mean reporting/decision support database. Thanks for the point that OLTP can be used for the same, too.

By "dimensional", you mean Facts/Dimension table concept, right?
>> By "dimensional", you mean Facts/Dimension table concept, right?

Yes I mean the "Dimensional Model" popularised by Ralph Kimball in the 1990s. In my view it's just a rather limited, inflexible and now outdated hotch potch of design patterns. Normal form is generally a much more useful way to design a data warehouse. Normal form was of course always the recommendation of Bill Inmon, who invented the term data warehouse in the first place.
anushahannaAuthor Commented:
dportas, thanks for the helpful answer and guidance and also that small piece of history.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.